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 Testing rerad cursor for status with ... John F Dutcher DB2 7 Fri May 19, 2017 9:35 pm
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm


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