IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to load into IMS segment ?


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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: 1448
Location: Chicago, IL

PostPosted: Wed Dec 28, 2005 8:39 am
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
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Jan 11, 2006 7:08 pm
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: 1448
Location: Chicago, IL

PostPosted: Wed Jan 11, 2006 7:17 pm
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: 1104
Location: The Netherlands at Hole 19

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

More information about DLITEST behind this link :
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: 1104
Location: The Netherlands at Hole 19

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

Direct access to the manual with the DLITEST subject behind this link:
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Thu Jan 12, 2006 6:14 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts REASON 00D70014 in load utility DB2 6
No new posts DB2 Load - Sort Or order BY DB2 1
No new posts DB2 Load - NUMRECS DB2 3
Search our Forums:

Back to Top