Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: getting the column header in the output !
Top Forums Shell Programming and Scripting getting the column header in the output ! Post 302264442 by vidyadhar85 on Thursday 4th of December 2008 02:32:21 AM
Old 12-04-2008
Quote:
Originally Posted by ali560045
i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ?

below the script:
------------------------------------------------------------------------

#!/bin/ksh

. $HOME/conf/systemProperties/EnvSetup.properties

connect1=`sqlplus -silent pipe/da!!a5p@ednmudp.world << END
set pagesize 1000 linesize 1000 feedback off verify off heading off echo off
select substr(module,1,39) "Module",
substr(state,1,15) "State",
to_char(start_time,'mm/dd/yy hh24:mi:ss') "Start",
to_char(end_time,'mm/dd/yy hh24:mi:ss') "End",
round((end_time-start_time)*1440,2) "Duration",
step "Step"
from dbsync_runtime_stats
order by step;
exit;
END`

echo "$connect1"
------------------------------------------------------------

result i got

MeterExchange Derive 12/03/08 22:02:05 12/03/08 22:02:10 .08 80
Incr_Sync TrimTXUTable 12/03/08 22:02:10 12/03/08 22:02:10 0 100
Incr_Sync TrimTable 12/03/08 22:02:10 12/03/08 22:02:53 .72 110
CTPT Derive 12/03/08 22:02:53 12/03/08 22:03:22 .48 1300

----------------------------------------------------------------------

my desired o/p should with the column header:

Module State Start End Duration Step
--------------------------------------- --------------- ----------------- ----------------- ---------- ----------

MeterExchange Derive 12/03/08 22:02:05 12/03/08 22:02:10 .08 80
Incr_Sync TrimTXUTable 12/03/08 22:02:10 12/03/08 22:02:10 0 100
Incr_Sync TrimTable 12/03/08 22:02:10 12/03/08 22:02:53 .72 110
CTPT Derive 12/03/08 22:02:53 12/03/08 22:03:22 .48 1300
remove that heading off thats itSmilie
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

2. Shell Programming and Scripting

Column header

Hello all, We are trying to run a script in Oracle DB from AIX. We need to set the Column Header while executing the query to generate the Output. For eg. select city, name from emp; It need to generate report in .csv format as CITY NAME atla tom cincin jack How I... (1 Reply)
Discussion started by: velappangs
1 Replies

3. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

4. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

5. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

6. Shell Programming and Scripting

Reading column header

Hi, I have some 10 tab delimited flat files, for some files the column header starts from 1st row whereas for some other files the column header starts from row or row 3 or row4 and so on.... Is there any way in UNIX so that we can read the column headers dynamically.' I am new to UNIX, so... (12 Replies)
Discussion started by: kedar_laveti
12 Replies

7. Shell Programming and Scripting

Print column header

Hi, Below is the data in a tab limited file Here ACCENT is just a heading and the line starting with Pcode has the column headers, and there is a 2 lines space between the file header and column header. I want to print $2, that is Dealer Name I used the below code nawk... (1 Reply)
Discussion started by: kedar_laveti
1 Replies

8. Shell Programming and Scripting

Manipulate all rows except header, but header should be output as well

Hello There... I have a sample input file .. number:department:amount 125:Market:125.23 126:Hardware store:434.95 127:Video store:7.45 128:Book store:14.32 129:Gasolline:16.10 I will be doing some manipulations on all the records except the header, but the header should always be... (2 Replies)
Discussion started by: juzz4fun
2 Replies

9. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies

LEARN ABOUT OPENDARWIN

funindex

funindex(1)							SAORD Documentation						       funindex(1)

NAME

       funindex - create an index for a column of a FITS binary table

SYNOPSIS

       funindex <switches>  <iname> [oname]

OPTIONS

	 NB: these options are not compatible with Funtools processing. Please
	 use the defaults instead.
	 -c	   # compress output using gzip"
	 -a	   # ASCII output, ignore -c (default: FITS table)"
	 -f	   # FITS table output (default: FITS table)"
	 -l	   # long output, i.e. with key value(s) (default: long)"
	 -s	   # short output, i.e. no key value(s) (default: long)"

DESCRIPTION

       The funindex script creates an index for the specified column (key) by running funtable -s (sort) and then saving the column value and the
       record number for each sorted row. This index will be used automatically
	by funtools filtering of that column, provided the index file's modification date is later than that of the data file.

       The first required argument is the name of the FITS binary table to index. Please note that text files cannot be indexed at this time.  The
       second required argument is the column (key) name to index. While multiple keys can be specified in principle, the funtools index process-
       ing assume a single key and will not recognize files containing multiple keys.

       By default, the output index file name is [root]_[key].idx, where [root] is the root of the input file. Funtools looks for this specific
       file name when deciding whether to use an index for faster filtering. Therefore, the optional third argument (output file name) should not
       be used for funtools processing.

       For example, to create an index on column Y for a given FITS file, use:

	 funindex foo.fits Y

       This will generate an index named foo_y.idx, which will be used by funtools for filters involving the Y column.

SEE ALSO

       See funtools(7) for a list of Funtools help pages

version 1.4.2							  January 2, 2008						       funindex(1)
All times are GMT -4. The time now is 03:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy