Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Splitting a report based on a field abdulrafi DFSORT/ICETOOL 7 Thu Mar 23, 2017 6:56 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us