| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
shriya reddy
Joined: 05 Jun 2004
Posts: 45
|
| Posted: Wed Feb 16, 2005 6:26 pm Post subject: Equivalent syntax |
|
|
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 |
|
harishskumar
Joined: 18 Feb 2005
Posts: 13
Location: Bangalore
|
| Posted: Fri Feb 18, 2005 4:59 pm Post subject: |
|
|
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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
