Loading an input Flat file into a IMS-DB segment

t1nt1n · New User Joined: 08 Jul 2005 Posts: 31

Hello

WE have a requirement like we get an input flat file with some values and we need to load it into a IMS-DB segment. What are the steps do we need to do for accomplishing this ? can some one help please...

priyesh.agrawal · Posted: Wed Dec 21, 2005 4:31 pm

t1nt1n,

It is not much different than what you do while making a GU or GN call to retrieve data from IMS DB.

1> Read Values from INPUT File.
2> Move read value to corresponding DB Variable.
3> Issue an ISRT call to segment.
4> check for Return Code.

Dont tell me you dont know how to make a call to IMS DB. I take seriously your say...

mbr_raja · Posted: Wed Apr 05, 2006 8:32 pm

There are two options available. They are

1). Using ISRT call, and insert each and everyone segment one by one by giving Unqualified SSA.

2). Using ISRT call with Command code as 'P' in PSB, you can use ISRT with multiple insert at a single short.

Try in both the ways, i will work fine. But the second option is optimised, if you insert multiple records of a given segment.