|
|
| Author |
Message |
Prabha
Warnings : 1
Active User
Joined: 05 Dec 2005
Posts: 64
|
|
|
|
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 |
|
 |
References
|
 Posted: Sat May 24, 2008 4:43 pm Post subject: Re: Need to retrive information in singlw call |
|
|
|
|
star_dhruv2000
Active User
Joined: 03 Nov 2006
Posts: 75
Location: India
|
|
|
|
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
Senior Member
Joined: 13 Jun 2007
Posts: 410
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: 25
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 |
|
|
|
|
