vp schrieb:
Hi all,
Can we create a report of this format using DB2.
Report#
Date:
column1 column2 column3
total
Field Name1 999 999 999
9999
Field Name 2 888 888 88
8888
Field Name 3 77 77 777
7777
Please suggest me a way to do... as of now I am using DB2 SQL in AIX
korn shell script... and we are not using any tool so is the problem...
thanks
are you trying to reformat a resultset (tabular-output) you are getting
with:
( only an example!)
db2 "select name,amount,remark from user_table"
NAME AMOUNT REMARK
--------------------------- --------------------
-----------------------------------------
Bush 10000.00 president
Schwarzenegger 20000.00 gouvernor
2 record(s) selected
to a report look-alike with header, footer, sum-ups ? or what are you
trying to achieve ?
use a perl-script to parse the output from the db2-command
joerg