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
 

 

How to load into IMS 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: Tue Dec 20, 2005 9:01 am    Post subject: How to load into IMS segment ?
Reply with quote

Hello

I have a flat file containing some values. I have a IMS-DB Segment which can store this. I need to load the contents of the flat file into the segment. Is there any utility to do it in JCL ? or is there asny simpler way of doing it other than writing a program to do the same.

thanks in advance
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 28, 2005 8:39 am    Post subject: Re: How to load into IMS segment ?
Reply with quote

Quote:
I need to load the contents of the flat file into the segment. Is there any utility to do it in JCL ? or is there asny simpler way of doing it other than writing a program to do the same.

It should be possible by FileAid for IMS or XPERT.

Regards,

Priyesh.
Back to top
View user's profile Send private message
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Wed Jan 11, 2006 11:12 am    Post subject:
Reply with quote

Priyesh,

Are you sure that you can load an imsdb from an input file using file aid.
I dont think so.One by one you can insert the records in each segment.
Eventhough it is possible how will you know the parentage of each segment occurances?

Sreejith
Back to top
View user's profile Send private message
gowtham_1982
Warnings : 1

Active User


Joined: 02 Dec 2005
Posts: 109

PostPosted: Wed Jan 11, 2006 11:53 am    Post subject:
Reply with quote

itssreehere wrote:
Priyesh,

Are you sure that you can load an imsdb from an input file using file aid.
I dont think so.One by one you can insert the records in each segment.
Eventhough it is possible how will you know the parentage of each segment occurances?

Sreejith



hai priyesh,

i second Sreejith's post. i don't think we can do it through file-aid. the only idea i've on this to go for coding in COBOL or PL/I.

corrections welcomed...

gowtham
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Jan 11, 2006 7:08 pm    Post subject:
Reply with quote

A long time ago I used DLITEST to get testdata in the database. With this you can specify DLI-calls navigating through the database and perform ISRT functions.
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 Jan 11, 2006 7:17 pm    Post subject: Re: How to load into IMS segment ?
Reply with quote

I have never used it in my shop... May be it is SHOP specific Utility for us.

Regards,

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

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Jan 11, 2006 7:30 pm    Post subject:
Reply with quote

More information about DLITEST behind this link :
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.ims9.doc.adb/xf41a9.htm
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Jan 11, 2006 7:56 pm    Post subject:
Reply with quote

Direct access to the manual with the DLITEST subject behind this link:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DFSP20F3/APPENDIX1.4?DT=20020906094838
Back to top
View user's profile Send private message
SathyaS

New User


Joined: 20 Sep 2005
Posts: 11

PostPosted: Thu Jan 12, 2006 6:02 pm    Post subject:
Reply with quote

U can also use DFSDDLT0 program to insert segmens into the DB. But i guess u need to prepare the input file with the DBD name, segment name and data to be inserted in the specified format. This we can use if we need to do very few inserts. If the insertion volume is huge it is better to go for a program.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Thu Jan 12, 2006 6:14 pm    Post subject:
Reply with quote

Sathyas: Sorry for the confusion. We use to say DLITEST which is DL/I Test which in its turn is in fact DFSDDLT0. icon_wink.gif
Back to top
View user's profile Send private message
shulba

New User


Joined: 20 Feb 2006
Posts: 2
Location: India

PostPosted: Tue Apr 25, 2006 3:26 pm    Post subject: copy File-Aid format data to personal PDS
Reply with quote

I want to copy the data from edit mode=v , to my personal PDS, please suggest me any method for this, its bit urgent !
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 Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm


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