Results 1 to 6 of 6

Thread: reports in db2

  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: 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 2003
    Location
    USA
    Posts
    5,737
    DB2 does not have a built-in report writer like Oracle Reports (or what ever it is called). But there are many 3rd party programs tht do this. Keep in mind that DB2 is about half the price as Oracle in many configuratons.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Re: reports in db2

    hi,

    we are using MicroSoft Crystal Report for generating reports from DB2, it is powerfull , give simliar capablites to sql reports
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  4. #4
    Join Date
    Jan 2004
    Posts
    14

    Re: reports in db2

    hi,

    I have to do the reports with one sql statement, so formatting of the fields to be displayed and also reight or left align can also be defined in oracle. I want to know if we have the features in DB2.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    No! DB2 does not have a built-in report writer. I bleive that the Oracle Report Writer is a seperate piece of code, whether it is free or costs extra, I don't know.
    Last edited by Marcus_A; 01-27-04 at 10:58.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: reports in db2

    Originally posted by treddy123
    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.
    You are out of luck. DB2 command line processor does not have formatting capabilities of SQLplus. The best you can do is to turn off headings and various messages to output bare data and then format them using OS tools (if you're on *nix).

    Alternatively, you can use 3d party report software (e.g. Crystal Reports) or even MS Excel to format your output.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •