CURSOR is required or not for this requirement

rameshbabu · New User Joined: 23 May 2005 Posts: 27

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).

rameshbabu · New User Joined: 23 May 2005 Posts: 27

[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]

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

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..