Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Option in sql script to include column headers when spooling file to .csv format
Top Forums UNIX for Dummies Questions & Answers Option in sql script to include column headers when spooling file to .csv format Post 302324367 by s1a2m3 on Wednesday 10th of June 2009 02:11:28 PM
Old 06-10-2009
page size entry removed and I am getting header.

thanks a lot.
 

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... (1 Reply)
Discussion started by: mdap
1 Replies

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 Replies)
Discussion started by: phoeberunner
3 Replies

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 Replies)
Discussion started by: Sriranga
4 Replies

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... (6 Replies)
Discussion started by: mcclunyboy
6 Replies

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', (4 Replies)
Discussion started by: mady135
4 Replies

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 ' ' ',' >>... (6 Replies)
Discussion started by: a1_win
6 Replies

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 Replies)
Discussion started by: Pramod_009
8 Replies

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 !! (1 Reply)
Discussion started by: chandu123
1 Replies

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... (6 Replies)
Discussion started by: dani1234
6 Replies

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... (7 Replies)
Discussion started by: ks_reddy
7 Replies

LEARN ABOUT OSF1

xmfontlistremoveentry

XmFontListRemoveEntry(3X)												 XmFontListRemoveEntry(3X)

NAME

       XmFontListRemoveEntry - A font list function that removes a font list entry from a font list

SYNOPSIS

       #include <Xm/Xm.h>

       XmFontList XmFontListRemoveEntry (oldlist, entry)
	       XmFontList oldlist;
	       XmFontListEntry entry;

DESCRIPTION

       XmFontListRemoveEntry  creates  a  new  font list that contains the contents of oldlist minus those entries specified in entry. The routine
       removes any entries from oldlist that match the components (tag, type font/font set) of the specified entry.  The function deallocates  the
       original  font  list  after  extracting	the required information.  The caller uses XmFontListEntryFree to recover memory allocated for the
       specified entry.  This routine does not free the XFontSet or XFontStruct associated with the font list entry that  is  removed.	 Specifies
       the font list Specifies the font list entry to be removed

RETURN VALUE

       If  oldlist  is NULL, the function returns NULL.  If entry is NULL or no entries are removed,  the function returns oldlist.  Otherwise, it
       returns a new font list.

SEE ALSO

       XmFontList(3X), XmFontListAppendEntry(3X), XmFontListEntryCreate(3X), XmFontListEntryFree(3X), XmFontListEntryLoad(3X), XmFontListFree(3X)

															 XmFontListRemoveEntry(3X)
All times are GMT -4. The time now is 04:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy