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.

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.

hi,

we are using MicroSoft Crystal Report for generating reports from DB2, it is powerfull , give simliar capablites to sql reports

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.

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.

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.