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
 
Equivalent syntax

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
Author Message
shriya reddy
Warnings : 1

New User


Joined: 05 Jun 2004
Posts: 45

PostPosted: Wed Feb 16, 2005 6:26 pm    Post subject: Equivalent syntax
Reply with quote

Hi friends,

help me out of this IDMS equivalent DB2 syntax.

OBTAIN CALC CATEGORYS

OBTAIN NEXT CIMEX WITHIN IX-CIMEX

Regards,
Shriya Reddy
Back to top
View user's profile Send private message
References
PostPosted: Wed Feb 16, 2005 6:26 pm    Post subject: Re: Equivalent syntax Reply with quote

harishskumar

New User


Joined: 18 Feb 2005
Posts: 13
Location: Bangalore

PostPosted: Fri Feb 18, 2005 4:59 pm    Post subject:
Reply with quote

Shriya !


Well there is no equivalent syntax for the snippnet you have posted. I can help you understand what that code is doing.

CATEGORYS is the owner record.

CIMEX is the member record

and IX-CIMEX is the set record which define's the relationship between the owner and member record.

Actually in this code you are obtaining the owner record using a calc key.. which is similar to a primary key in db2 . But you will obtain the member record which is stored close to owner record sequentially.. and unfortunately you don't have equivalent syntax in db2.

Hope this will be of some use to you.....
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1