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
 

 

Please how do i proceed on this requiremnt?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
babu_hi

New User


Joined: 11 Apr 2006
Posts: 93

PostPosted: Fri Jun 20, 2008 1:36 pm    Post subject: Please how do i proceed on this requiremnt?
Reply with quote

In the source programs(COBOL-DB2 Batch progrmas) we have different types database enquiries.Each type enquiry is declared in cursor and get the reight data from the database.All enquiries use only one table but in where cluse we are mention different fields in all enquiries.

Insted of doing enquiries in source programs,we are going to design a subroutine for all types of enquiries placed in this routine and return the right date in to commom output area in this subroutine.Then the source progrms use this common output area and do rest of logic in existing program.

For this we have use dynemic sql in the subroutine.

How do proceed for this kind of requirement.Please let me know the approach on this?
Back to top
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri Jun 20, 2008 2:53 pm    Post subject:
Reply with quote

You mean to say that your cursor is going to be different of different inputs to the subprogram ...

If so for a particular input, construct the required cursor in your subprogram ... prepare, open and fetch the particular cursor only and return the result set ...
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need a cursor to achieve the below re... sandeep kumar302 DB2 10 Tue Mar 31, 2015 10:52 am
This topic is locked: you cannot edit posts or make replies. URGENT REQUIREMNT FOR Senior Software... scorp_rahul23 Mainframe Jobs 0 Tue Jul 07, 2009 9:11 am


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