Replacing IMS call stmt to DB2 exec SQL

karthikbabudh · Posted: Mon May 02, 2005 12:21 pm

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.

sridhard · New User Joined: 02 Jun 2005 Posts: 8 Location: Chennai

Hi,

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

Thanks
Sridhar

Karthikt · New User Joined: 15 Aug 2005 Posts: 51

Replace GU - SELECT
GN - CURSORS

ISRT -INSERT
REPL - UPDATE
DELET -DELETE

lakshmi83durga · New User Joined: 10 Feb 2007 Posts: 6 Location: Bangalore

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

Devzee · Posted: Sun Feb 11, 2007 1:29 am

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.

lakshmi83durga · New User Joined: 10 Feb 2007 Posts: 6 Location: Bangalore

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

guptae · Posted: Tue Feb 13, 2007 10:49 am

Hi Durga,

It is something similar to SQLCA

lakshmi83durga · New User Joined: 10 Feb 2007 Posts: 6 Location: Bangalore

Thanks Ekta...

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

Thanks
Durga

guptae · Posted: Tue Feb 13, 2007 11:19 am

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.

lakshmi83durga · New User Joined: 10 Feb 2007 Posts: 6 Location: Bangalore

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

guptae · Posted: Tue Feb 13, 2007 11:59 am

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

Bitneuker · Posted: Tue Feb 13, 2007 5:03 pm

Ekta: thank you so much for this.........

lakshmi83durga · New User Joined: 10 Feb 2007 Posts: 6 Location: Bangalore

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

Thanks
Durga

Bitneuker · Posted: Wed Feb 14, 2007 5:43 pm

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.

Bitneuker · Posted: Wed Feb 14, 2007 6:02 pm

Here's another one. Click have a look at the fact sheet; maybe the strategy is of use.

Dryice · New User Joined: 04 Jan 2006 Posts: 1

Hi Durga,

Here's another one : Use [URL] BBCode for External Links

pruduct name is H2R

it offers a IMS migration to Oracle or DB2...