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
 
Replacing IMS call stmt to DB2 exec SQL

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

New User


Joined: 08 Sep 2003
Posts: 32
Location: Toronto <-> Bangalore

PostPosted: Mon May 02, 2005 12:21 pm    Post subject: Replacing IMS call stmt to DB2 exec SQL
Reply with quote

Hi,
Can anyone tell me how to replace ims call stmt to db2 exec sql statement.if u have any docs please mail it.

Thankx,
Karthik.
Back to top
View user's profile Send private message

sridhard

New User


Joined: 02 Jun 2005
Posts: 8
Location: Chennai

PostPosted: Thu Jun 09, 2005 8:44 pm    Post subject: Re: Replacing IMS call stmt to DB2 exec SQL
Reply with quote

Hi,

Its very difficult question. You can't simply replace.
There should have been IMS database existing.

Thanks
Sridhar
Back to top
View user's profile Send private message
Karthikt

New User


Joined: 15 Aug 2005
Posts: 51

PostPosted: Tue Aug 16, 2005 2:06 pm    Post subject:
Reply with quote

Replace GU - SELECT
GN - CURSORS

ISRT -INSERT
REPL - UPDATE
DELET -DELETE
Back to top
View user's profile Send private message
lakshmi83durga

New User


Joined: 10 Feb 2007
Posts: 6
Location: Bangalore

PostPosted: Sat Feb 10, 2007 2:31 pm    Post subject: Re: Replacing IMS call stmt to DB2 exec SQL
Reply with quote

Hi kartik..

Can u please help me out in replacing IMS calls to sql calls..Am having confusions in the PCB-mask parameter in the CBLTDLI call. Also the Logical child parameter. How to replace it in db2.

Thanks,
Durga icon_exclaim.gif
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sun Feb 11, 2007 1:29 am    Post subject:
Reply with quote

Its not an easy task of changing all IMS calls with equivalent DB2 calls.

If you have working knowledge of IMS and Db2, and full information of existing IMS database then you can manually change the calls.

First get information of existing IMS DB like number of segments, parent child relations, logical db, secondary indexed db etc.
Second get information of the IMS database is migrating or mapped to Db2 table.

Changing the IMS calls to DB2 will vary depending on each application program, you need to consider any command codes, qual ssa and unqual ssa. etc

This task depends on how complex your IMS DB application system is developed.
Back to top
View user's profile Send private message
lakshmi83durga

New User


Joined: 10 Feb 2007
Posts: 6
Location: Bangalore

PostPosted: Tue Feb 13, 2007 10:46 am    Post subject: Re: Replacing IMS call stmt to DB2 exec SQL
Reply with quote

Thanks devsee..

But could u please help me out in the details of PCB mask which is used as a parameter in CBTDLI call and is declared in Linkage section.. what is the equivalent for this in DB2.

Thanks
Durga
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Feb 13, 2007 10:49 am    Post subject:
Reply with quote

Hi Durga,

It is something similar to SQLCA
Back to top
View user's profile Send private message
lakshmi83durga

New User


Joined: 10 Feb 2007
Posts: 6
Location: Bangalore

PostPosted: Tue Feb 13, 2007 11:15 am    Post subject:
Reply with quote

Thanks Ekta...

Do u have any idea about the Logical child in DBD.. How to replace that in DB2 database.

Thanks
Durga
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Feb 13, 2007 11:19 am    Post subject:
Reply with quote

Hi Durga,

Its depend upom ur ims database like number of sgement ,child parent relationship,key field etc & how u convert this IMS database to DB2 database.
Back to top
View user's profile Send private message
lakshmi83durga

New User


Joined: 10 Feb 2007
Posts: 6
Location: Bangalore

PostPosted: Tue Feb 13, 2007 11:29 am    Post subject:
Reply with quote

Thanks Ekta.. I've converted the segments into tables of a DBD.. I've converted the Parent-Child relationship into primary-foreign key relnship between tables. BUt am not clear with this logical child. Am understanding the use of it but couldn find an equivalent for this in db2. Is that again primary-foreign key relnship??

Also can u please suggest any study docs/sites for this migration if u have any idea.. I couldn find much docs regarding this.

Thanks
Durga
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Feb 13, 2007 11:59 am    Post subject:
Reply with quote

Hi Durga,

Yes i think u can go with primary-foreign key relationship but i dont have much idea Bitneuker can help u regarding this
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue Feb 13, 2007 5:03 pm    Post subject:
Reply with quote

Ekta: thank you so much for this......... icon_rolleyes.gif icon_wink.gif
Quote:
but i dont have much idea Bitneuker can help u regarding this



I'll give it a try icon_wink.gif I suppose you have multiple DBD's allowing you to re-arrange into different logical DBD's. This way a dependent segment in one DB may be the root in another logical DB. The relationship is done by a bi-directional pointer holding each key. So I expect you converted both DB's into two seperate DB2-tables. If you want the relationship to continue it seems to me you define the foreign-keys in both tables. In fact include the bi-directional pointer in the tables. If this doesn't help get back and we will do some further investigation.[/quote]
Back to top
View user's profile Send private message
lakshmi83durga

New User


Joined: 10 Feb 2007
Posts: 6
Location: Bangalore

PostPosted: Wed Feb 14, 2007 4:46 pm    Post subject: Help Docs
Reply with quote

Thanks Bitneuker..
Can u please suggest me some sites or send me some docs for this migration from IMS to DB2?

Thanks
Durga
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 14, 2007 5:43 pm    Post subject:
Reply with quote

Hi Durga,

There are tools that can migrate from IMS to DB2. Suppose it will cost you but just have a look here. Found it in this forum after some Googling.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 14, 2007 6:02 pm    Post subject:
Reply with quote

Here's another one. Click have a look at the fact sheet; maybe the strategy is of use.
Back to top
View user's profile Send private message
Dryice

New User


Joined: 04 Jan 2006
Posts: 1

PostPosted: Fri Oct 12, 2007 1:24 pm    Post subject: Reply to: Replacing IMS call stmt to DB2 exec SQL
Reply with quote

Hi Durga,

Here's another one : www.htwc.com

pruduct name is H2R

it offers a IMS migration to Oracle or DB2...
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
This topic is locked: you cannot edit posts or make replies. ISREDIT Macro is not returning back t... nico_neoz CLIST & REXX 21 Sat Nov 18, 2017 7:40 pm
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts exec macro in the end of edit anatol CLIST & REXX 8 Fri Sep 22, 2017 5:10 am
No new posts replacing junk with hyphen Nitin32 DFSORT/ICETOOL 10 Fri Jun 02, 2017 7:47 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am

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