Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Loading an input Flat file into a IMS-DB segment

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

New User


Joined: 08 Jul 2005
Posts: 31

PostPosted: Wed Dec 21, 2005 2:23 pm    Post subject: Loading an input Flat file into a IMS-DB segment
Reply with quote

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...
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Wed Dec 21, 2005 4:31 pm    Post subject: Re: help needed in IMS-DB
Reply with quote

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...
Quote:
WE have a requirement


Regards,

Priyesh.
Back to top
View user's profile Send private message
mbr_raja

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Wed Apr 05, 2006 8:32 pm    Post subject: Re: help needed in IMS-DB
Reply with quote

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.
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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us