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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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