IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Equivalent syntax


IBM Mainframe Forums -> IDMS/ADSO
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shriya reddy
Warnings : 1

New User


Joined: 05 Jun 2004
Posts: 43

PostPosted: Wed Feb 16, 2005 6:26 pm
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
harishskumar

New User


Joined: 18 Feb 2005
Posts: 13
Location: Bangalore

PostPosted: Fri Feb 18, 2005 4:59 pm
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IDMS/ADSO

 


Similar Topics
Topic Forum Replies
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts File matching functionality in Easytr... DFSORT/ICETOOL 14
No new posts Cobol Db2 program (inserting Char Equ... COBOL Programming 0
No new posts CNTL= Command Syntax Documentation CA Products 3
This topic is locked: you cannot edit posts or make replies. issue with Syntax error SYNCSORT 2
Search our Forums:

Back to Top