DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: To Generate Reports in DB2

  1. #1
    Join Date
    Jan 2004
    Posts
    1

    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.

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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

  3. #3
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    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

  4. #4
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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
  •  


Click Here to Expand Forum to Full Width