Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Need to retrive information in singlw call

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
Author Message
Prabha
Warnings : 1

Active User


Joined: 05 Dec 2005
Posts: 64

PostPosted: Sat May 24, 2008 4:43 pm    Post subject: Need to retrive information in singlw call
Reply with quote

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
View user's profile Send private message
References
star_dhruv2000

Active User


Joined: 03 Nov 2006
Posts: 77
Location: India

PostPosted: Sat May 24, 2008 5:49 pm    Post subject:
Reply with quote

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 icon_biggrin.gif
Back to top
View user's profile Send private message
Sandy Zimmer

Senior Member


Joined: 13 Jun 2007
Posts: 472
Location: Wilmington, DE

PostPosted: Sun May 25, 2008 6:45 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Sinkaravelan S

New User


Joined: 21 Apr 2008
Posts: 31
Location: coimbatore-TN india

PostPosted: Tue May 27, 2008 7:23 pm    Post subject: Reply to: Need to retrive information in singlw call
Reply with quote

Welcome Prabha,

I think you can use path call otherwise you should retrive all the info by using SSA's.


Thanks,
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1