View previous topic :: View next topic
|
Author |
Message |
sid_aec
New User
Joined: 01 Jul 2008 Posts: 60 Location: Kolkata
|
|
|
|
Hi,
I have an IMS data base which is ACCESS=HIDAM,OSAM. It has 2 secondary indexes.
I have a VSAM which has two alternate Indexes.
I need to load from that VSAM to the HIDAM database.
Can anyone tell me How to load that VSAM into HIDAM data base? If I need to write the records from VSAM to HIDAM through a program then how to load the secondary Index data bases associated with HIDAM. Please help. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you consider unloading the vsam data into a sequential file. Then loading the data into IMS building needed alternate indexes.
If there is any volume of data, i believe you want the bulk load rather than some code that inserts 1 row at a time. . . |
|
Back to top |
|
|
sid_aec
New User
Joined: 01 Jul 2008 Posts: 60 Location: Kolkata
|
|
|
|
Hi,
Can you please suggest any utility for bulk load and then secondary index build utility. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to talk with your dba and learn how this is typically done on your system.
DB2 and BMC both do this. You need to follow whatever process is acceptable on your system, not something picked up online. |
|
Back to top |
|
|
|