View previous topic :: View next topic |
Author |
Message |
Siva Kumar Sunku Beginner
Joined: 17 Aug 2004 Posts: 25 Topics: 14
|
Posted: Wed Sep 29, 2004 1:15 am Post subject: Current Position after GN/GNP calls |
|
|
Hi,
I have following Requirement
Quote: |
Extract all the records of SDELNQCY and SFNCLTRN segments for a patricular SFNCLSUM Segment.
|
Database structure is as follows.
Code: |
1 DBD-CMDDCYC1 SACCOUNT
2 SFNCLSUM
3 SJFNCLS2
3 SFNCLDLT
4 SDELNQCY
5 SJDELNQ2
4 SFNCLTRN
5 SJFNCLT2
|
I issued DLI call to keep the parentage at SFNCLDLT segment, and tried to read all the SDELNQCY (UnQualified GNP Call)segment records till I get 'GE' status(Para#1),
Then I tried to read al SFNCLTRN(UnQualifed GNP Call) segments till I get 'GE' status.(Para#2)
This code is working fine.
Problem comes when SDELNQCY segment has no occurences. In this case Para#1 am getting 'GE' status which is expected. Even in Para#2 also am getting 'GE' status though SFNCLTRN segments are present.
Do I need to reposition parentage after Para#1? or is there any work around?
-Siva. |
|
Back to top |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Wed Sep 29, 2004 10:02 am Post subject: |
|
|
Try using a command code of F for first on the first GNP for SFNCLTRN. That should get you the first occurrance. Remember to clear the command code on subsequent calls. |
|
Back to top |
|
|
Siva Kumar Sunku Beginner
Joined: 17 Aug 2004 Posts: 25 Topics: 14
|
Posted: Thu Sep 30, 2004 11:49 am Post subject: |
|
|
Hi Bithead.
The code is working very fine.
Thanks a lot.
-Siva. |
|
Back to top |
|
|
|
|