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
 

 

CURSOR is required or not for this requirement

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

New User


Joined: 23 May 2005
Posts: 27

PostPosted: Wed Jun 08, 2005 11:59 am    Post subject: CURSOR is required or not for this requirement
Reply with quote

hi guys plse go thru this requirement i am expecting cursor is needed for this one plse suggest me

Write a new batch program NSRMB08:

1. Read Consumer Credit input file. In case input has no records, stop processing.

2. Using input account number access Account Table (VS1ACT) to obtain household number for the account. Accept only those accounts that have only one unique associated household.

3. Select all rows in VS1ACL Table (ACL) using the above household number to obtain all unique telephone numbers. For each unique telephone number set home/business flag and populate the output record fields.

4. If the input account number does not match to a household, or if it matches to more than one unique household, then access ACL Table using Primary SSN to obtain household number. Accept only those primary SSN that have only one unique associated household. Then proceed as in 3 above.

5. If the input primary SSN does not match to a household, or if it matches to more than one unique household, then access ACL Table using secondary SSN to obtain household number. Accept only those secondary SSN that have only one unique associated household. Then proceed as in 3. above.


6. Write the output record. Include all necessary accumulations. Include error handling in accordance with the existing structure of NCIS (see any NCIS batch COBOL/DB2 program as an example).
Back to top
View user's profile Send private message

rameshbabu
Warnings : 1

New User


Joined: 23 May 2005
Posts: 27

PostPosted: Fri Jun 10, 2005 11:09 am    Post subject: Re: CURSOR is required or not for this requirement
Reply with quote

[quote="rameshbabu"]hi guys plse go thru this requirement i am expecting cursor is needed for this one plse suggest me

Write a new batch program
1. Read Consumer Credit input file. In case input has no records, stop processing.

2. Using input account number access Account Table to obtain household number for the account. Accept only those accounts that have only one unique associated household.

3. Select all rows in Table (ACL) using the above household number to obtain all unique telephone numbers. For each unique telephone number set home/business flag and populate the output record fields.

4. If the input account number does not match to a household, or if it matches to more than one unique household, then access ACL Table using Primary SSN to obtain household number. Accept only those primary SSN that have only one unique associated household. Then proceed as in 3 above.

5. If the input primary SSN does not match to a household, or if it matches to more than one unique household, then access ACL Table using secondary SSN to obtain household number. Accept only those secondary SSN that have only one unique associated household. Then proceed as in 3. above.


6. Write the output record. Include all necessary accumulations. Include error handling in accordance with the existing structure of NCIS (see any NCIS batch COBOL/DB2 program as an example).[/quote]
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Nov 03, 2005 2:51 pm    Post subject: cursor problem
Reply with quote

hi frnd,
why do u confuse urself. simple concept if you r in need to retrive more than one row at-a-time then use cursor. if retriving only single row dont use the cursor. simple ha..
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 Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Cards mainframe developer requirement... capricorn Mainframe Jobs 0 Sun Sep 11, 2016 9:57 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am
No new posts FTP help required amitc23 All Other Mainframe Topics 3 Thu Apr 28, 2016 12:02 pm


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