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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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