View previous topic :: View next topic
|
Author |
Message |
Prabha Warnings : 2 New User
Joined: 05 Dec 2005 Posts: 79
|
|
|
|
Hi,
I need to retrive information in singlw call.
My requirement is
EMployee
|
|
Personal Info
|
|
Salary
EMployee id is 123456 and for this i need to get personal information about this id for the 4th month of salary.(salary contains 12 occurences)
I need to do this in single call. Pls help me how to do. |
|
Back to top |
|
|
star_dhruv2000
New User
Joined: 03 Nov 2006 Posts: 87 Location: Plymouth, MN USA
|
|
|
|
Key for Salary segement is not mentioned. I assume it to be Non-Unique Month number. In that case use following SSA with appropiate KEY field values. :
Code: |
01 EMP-SSA.
05 SEGNAME PIC X(08) VALUE 'SALARY '.
05 CMD-CODE PIC X(05) VALUE '*DC'.
05 FILLER PIC X(01) VALUE '('.
05 KEY-EMP PIC X(06) VALUE '123456'.
05 KEY-INFO PIC X(??) VALUE SPACES.
05 KEY-SAL PIC X(02) VALUE '04'.
05 FILLER PIC X(01) VALUE ')'. |
NOTE:
1. Kindly check the PIC definition and values for all the keys.
2. Use an I/O large enough to hold the retrieved segements.
Hope this will resolve your issue.
CHEERS!
Happy coding |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
Can we please see the DBD? In order to do it in a single call, you will need to issue a path call. We need to see the child segments of the root. |
|
Back to top |
|
|
Sinkaravelan S
New User
Joined: 21 Apr 2008 Posts: 27 Location: coimbatore-TN india
|
|
|
|
Welcome Prabha,
I think you can use path call otherwise you should retrive all the info by using SSA's.
Thanks, |
|
Back to top |
|
|
|