Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
View previous topic :: :: View next topic  
Author Message
Prabha
Warnings : 2

New User


Joined: 05 Dec 2005
Posts: 79

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

star_dhruv2000

New User


Joined: 03 Nov 2006
Posts: 87
Location: Plymouth, MN USA

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

Active Member


Joined: 13 Jun 2007
Posts: 826
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: 27
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. how to get Job information from IOF u... rsshanmugam CLIST & REXX 13 Mon Feb 05, 2018 4:22 pm
No new posts Need to obtain VTOC information via R... djeffbland CLIST & REXX 10 Thu Jan 11, 2018 4:13 am
No new posts JCL INFORMATION - Need to know what t... gauravd01 JCL & VSAM 8 Wed Nov 29, 2017 12:54 pm
This topic is locked: you cannot edit posts or make replies. Rexx to Grab ISMF Information. upendrasri All Other Mainframe Topics 16 Sun Nov 26, 2017 12:35 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us