-
To Generate Reports in DB2
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.
-
I would say look at DB2 documentation. ANSI SQL is same on both databases.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
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
-
The only DB2 DBA in our company was laid off last November.
Otherwise I would have asked him to help you out.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|