Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
program for report generation

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
rkr

New User


Joined: 19 Apr 2005
Posts: 12

PostPosted: Sat Sep 17, 2005 10:46 am    Post subject: program for report generation
Reply with quote

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
Back to top
View user's profile Send private message

Rama Nelluri

New User


Joined: 16 Sep 2005
Posts: 6

PostPosted: Mon Sep 19, 2005 4:29 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
rkr

New User


Joined: 19 Apr 2005
Posts: 12

PostPosted: Tue Sep 20, 2005 7:30 pm    Post subject: Re: program for report generation
Reply with quote

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
Back to top
View user's profile Send private message
Rama Nelluri

New User


Joined: 16 Sep 2005
Posts: 6

PostPosted: Tue Sep 20, 2005 7:51 pm    Post subject:
Reply with quote

Hi,

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

Regards,
Rama.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts Copying part of the report using SARBCH Aedulla CA Products 1 Tue Oct 24, 2017 9:24 am
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us