program for report generation

rkr · New User Joined: 19 Apr 2005 Posts: 12

hi all

i want a cobol program and the run jcl for report generation in which the data is retrieved from a table in database .
and i want the output in spool not in to be assigned to the printer.

if anybody has knows it, plz send it asap.
thanks in advance ..

regards
rkr

Rama Nelluri · New User Joined: 16 Sep 2005 Posts: 6

Hi,
Unload the Table data to Flat file. Read this flat file until End of file ,write the record to sysout.

In File control,
Select Infile assign to XXXXX.
Select Outfile assign to SYSOUT.

and Other logic is: (We can do below logic also But this is not good way...)
Declare Cursor with select * from Table.
Put the Fetch Cursor loop Until end-of-table(or SQL code=100)
Move the Table values to output file variables, write the output file.

Regards,
Rama.N

rkr · New User Joined: 19 Apr 2005 Posts: 12

hi rama,
thanks for ur reply.but can we generate report using qmf ?
there is also all the facilities for report generation.
thanks in advance.

regards
rkr

Rama Nelluri · New User Joined: 16 Sep 2005 Posts: 6

Hi,

I have't worked in QMF.In my workshop we do not support QMF.

Regards,
Rama.