To Generate Reports in DB2

[treddys]

Hello All:
I am new to DB2, but have ample exp. in oracle. Now I have to write sql statements to generate reports similar to sqlplus in oracle.

in oracle we have so many options to format a report.
like
col name_of_the_field format a40 justify l (to display data in the leftside of the column)
set pagesize 100 (to set the no of lines in each page )
set linesize 100 (each linesize 100)

so can someone give me pointer to look for the formating syntax in db2.

The report generated by DB2 and Oracle has to similar.

[kris109]

I would say look at DB2 documentation. ANSI SQL is same on both databases.

[jodie]

I don't know the answer for you, but thought you may try www.dbforums.com. They have a db2 forum that is almost exactly the same format we have here at dbasupport.com. There don't appear to be as many experts there as we have here, but I have found answers to several db2 questions there.

Good luck!
Jodie

[kris109]

The only DB2 DBA in our company was laid off last November.

Otherwise I would have asked him to help you out.