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
 
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: 1883
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 Handling result sets in the calling N... Rusikesh DB2 7 Fri Apr 13, 2018 12:25 am
No new posts Getting GG return code abdulrafi IMS DB/DC 2 Tue Apr 10, 2018 12:31 pm
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts How to get the output from submit com... Joanna2016 CLIST & REXX 10 Tue Feb 06, 2018 7:26 am
No new posts Conditional setting of return-code af... sanvan COBOL Programming 9 Wed Jan 31, 2018 11:05 pm

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