Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

getting the column header in the output !

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting getting the column header in the output !
# 1  
Old 12-04-2008
getting the column header in the output !
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:
------------------------------------------------------------------------

Code:
#!/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

Code:
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:

Code:
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

Last edited by DukeNuke2; 12-04-2008 at 03:31 AM.. Reason: added code tags for better reading
# 2  
Old 12-04-2008
Try the set option
Code:
 heading on

instead of
Code:
 heading off

, on line 6

Link
# 3  
Old 12-04-2008
ali560045,

Code:
set pagesize 1000 linesize 1000 feedback off verify off heading off echo off
Replace the above line as
set pagesize 1000 linesize 1000 feedback off verify off heading on echo off

# 4  
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
# 5  
Old 12-04-2008
thanks a lot for the help. got it
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
Login or Register to Ask a Question