Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Handling of inserts L & F commands code in DB2 inserts

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
k_v_mahesh

New User


Joined: 25 May 2010
Posts: 15
Location: chennai

PostPosted: Wed Feb 26, 2014 8:57 am    Post subject: Handling of inserts L & F commands code in DB2 inserts
Reply with quote

Looking for equivalent for L&F command codes in Db2.

In IMS wth L & F we can overrides rules first and here and place the record even if segment has no key or non unique key in it. IMS will still retrieve the first and last record using these.

I feel that kind of thing may not be possible in DB2 while we do insert unless we use some kind of seq # or key and order it for retrieving back.

Any thoughts will really help and if someone has handled it.

Regards
Mags
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1624
Location: NY,USA

PostPosted: Wed Feb 26, 2014 10:09 am    Post subject:
Reply with quote

should this be under DB2 forum?


However, are you doing any migration from IMS DB to DB2? What is exactly expected? I see you can do this by using "CURRENT OF " in DB2 or use a scrollable cursor with variety of options.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 26, 2014 7:43 pm    Post subject:
Reply with quote

Hello,

Quote:
should this be under DB2 forum?

I suspect we have more IMS users that know db2 rather than db2 users that know IMS. . .

I'm ok with this topic here in the IMS part of the forum, but if someone strongly believes it needs to be moved, i'm willing.
Back to top
View user's profile Send private message
pmartyn

New User


Joined: 28 Feb 2013
Posts: 3
Location: USA

PostPosted: Tue Mar 11, 2014 1:48 am    Post subject:
Reply with quote

What you have discovered is the difference between Hierarchical vs Relational DBMS methodologies. The reason why IMS has that feature via the Command Codes you mentioned is because pointers are already present and available for use. In DB2 those pointers do not exist. What you are trying to do is possible but you need to design/code for it.
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
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us