Option in sql script to include column headers when spooling file to .csv format Post: 302324356

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file...

2. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you...

3. Shell Programming and Scripting

SQL Script's output to a CSV file

I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ? I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I...

4. Shell Programming and Scripting

How to include SQL within a script

Hi, I have a script I am developing (actually more than 1 just now). 1st part - executes SQL in a 2nd script. 2nd part - reformats the output of the sql into a csv Problem: How am I able to run the SQL from the first script? I assume there is a sql command? I generally use isql when...

5. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c',

6. Shell Programming and Scripting

Sar -u generates multiple column headers in csv file

Hi All, The below sar -u command generates multiple column headers in csv file Expected output should print column headers only once in the csv file shell script: $cat sar_cpu_EBS.sh #!/bin/bash while ; do sar -u 15 1 | awk '/^/ {print $1,$2,$4,$6,$7}' | tr -s ' ' ',' >>...

7. UNIX for Dummies Questions & Answers

Spooling data from the database in .csv file with boundary

Hi Guys, Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below: 20140327 BU 9A 3 20140327 SPACE 9A 3 20140327...

8. Shell Programming and Scripting

Checking data in csv file after headers

I had a requirement to check if data exists after headers (typically row 2 & so on) in csv file. please help how we can check through shellscript in linux. Thank you !!

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

10. Shell Programming and Scripting

Row bind multiple csv files having different column headers

All, I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search. Here is my request I have many files out of which 2 sample files provided below. File-1 (with A,B as column headers) A,B 1,2 File-2 (with C, D as column headers) C,D 4,5 I...

LEARN ABOUT DEBIAN

git-prune

GIT-PRUNE(1)							    Git Manual							      GIT-PRUNE(1)

NAME

       git-prune - Prune all unreachable objects from the object database

SYNOPSIS

       git prune [-n] [-v] [--expire <expire>] [--] [<head>...]

DESCRIPTION

	   Note
	   In most cases, users should run git gc, which calls git prune. See the section "NOTES", below.

       This runs git fsck --unreachable using all the refs available in refs/, optionally with additional set of objects specified on the command
       line, and prunes all unpacked objects unreachable from any of these head objects from the object database. In addition, it prunes the
       unpacked objects that are also found in packs by running git prune-packed.

       Note that unreachable, packed objects will remain. If this is not desired, see git-repack(1).

OPTIONS

       -n, --dry-run
	   Do not remove anything; just report what it would remove.

       -v, --verbose
	   Report all removed objects.

       --
	   Do not interpret any more arguments as options.

       --expire <time>
	   Only expire loose objects older than <time>.

       <head>...
	   In addition to objects reachable from any of our references, keep objects reachable from listed <head>s.

EXAMPLE

       To prune objects not used by your repository nor another that borrows from your repository via its .git/objects/info/alternates:

	   $ git prune $(cd ../another && $(git rev-parse --all))

NOTES

       In most cases, users will not need to call git prune directly, but should instead call git gc, which handles pruning along with many other
       housekeeping tasks.

       For a description of which objects are considered for pruning, see git fsck's --unreachable option.

SEE ALSO

       git-fsck(1), git-gc(1), git-reflog(1)

GIT

       Part of the git(1) suite

Git 1.7.10.4							    11/24/2012							      GIT-PRUNE(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

Discussion started by: mdap

2. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Discussion started by: phoeberunner

3. Shell Programming and Scripting

SQL Script's output to a CSV file

Discussion started by: Sriranga

4. Shell Programming and Scripting

How to include SQL within a script

Discussion started by: mcclunyboy