|
|
Sponsored Content
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
12-04-2008
Quote:
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
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
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ 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
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
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
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
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
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
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
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
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 NETBSD
weekly
WEEKLY(5) BSD File Formats Manual WEEKLY(5) NAME
weekly, weekly.conf -- weekly maintenance DESCRIPTION
The /etc/weekly script is run, by default, every Saturday morning on a NetBSD system. The /etc/weekly.conf file specifies which of the stan- dard weekly services are performed. The variables described below can be set to ``YES'' or ``NO'' in the /etc/weekly.conf file. The default settings are in the /etc/defaults/weekly.conf file. (Note that you should never edit /etc/defaults/weekly.conf directly, as it is often replaced during system upgrades.) rebuild_locatedb This rebuilds the locate(1) database, /var/db/locate.database, which must also exist, in order to be rebuilt. rebuild_mandb This rebuilds the apropos(1) database /var/db/man.db, using makemandb(8) with the -f option. rebuild_whatisdb This rebuilds the whatis(1) database(s). Note that NetBSD provides a default whatis.db for the system manual pages and this may not be needed. (Adjust your /etc/man.conf as necessary; see man.conf(5) for details.) FILES
/etc/weekly weekly maintenance script /etc/weekly.conf weekly maintenance configuration /etc/weekly.local local site additions to /etc/weekly SEE ALSO
daily.conf(5), monthly.conf(5) HISTORY
The /etc/weekly script first appeared in 4.3BSD. The /etc/weekly.conf configuration file appeared in NetBSD 1.3. BSD
March 6, 2012 BSD