|
|
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 DEBIAN
shcomp
SHCOMP(1) User Environment Utilities SHCOMP(1) NAME
shcomp - compile a ksh93 shell script SYNOPSIS
shcomp [ options ] [infile] [outfile]] ORIGIN OF THIS MAN PAGE
This man page was written by Christophe Martin <Schplurtz@free.fr> for the Debian GNU/Linux system. It is based on "shcomp --man" output. DESCRIPTION
Unless -D is specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 can read and execute with the same effect as the original script. Since aliases are processed as the script is read, alias definitions whose value requires variable expansion will not work correctly. If -D is specified, all double quoted strings that are preceded by $ are output. These are the messages that need to be translated to locale specific versions for internationalization. If outfile is omitted, then the results will be written to standard output. If infile is also omitted, the shell script will be read from standard input. OPTIONS
-D, --dictionary Generate a list of strings that need to be placed in a message catalog for internationalization. -n, --noexec Displays warning messages for obsolete or non-conforming constructs. -v, --verbose Displays input from infile onto standard error as it reads it. --man Displays this man page on standard error and exits. --help Shows a short help message and exits. EXIT STATUS
0 Successful completion. >0 An error occurred. DEBIAN WARNING
On a Debian GNU/Linux system, more than one package may provide ksh. the output of shcomp can only be used by ksh93. Any other ksh will be unable to run the compiled script. EXAMPLE
( echo '#! /bin/ksh93' ; shcomp myscript ) > myscript.bin && chmod 755 myscript.bin ./myscript.bin SEE ALSO
ksh(1) IMPLEMENTATION
version shcomp (AT&T Labs Research) 2012-02-29 author David Korn <dgk@research.att.com> copyright Copyright (c) 1982-2012 AT&T Intellectual Property license http://www.eclipse.org/org/documents/epl-v10.html KSH93 Fri Jun 3 2005 SHCOMP(1)