View previous topic :: View next topic
|
Author |
Message |
t1nt1n
New User
Joined: 08 Jul 2005 Posts: 31
|
|
|
|
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 |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
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 |
|
|
itssreehere Warnings : 1 New User
Joined: 10 Jan 2006 Posts: 65 Location: chennai
|
|
|
|
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 |
|
|
gowtham_1982 Warnings : 1 Active User
Joined: 02 Dec 2005 Posts: 109
|
|
|
|
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 |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
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 |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
I have never used it in my shop... May be it is SHOP specific Utility for us.
Regards,
Priyesh. |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
Back to top |
|
|
SathyaS
New User
Joined: 20 Sep 2005 Posts: 11
|
|
|
|
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 |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Sathyas: Sorry for the confusion. We use to say DLITEST which is DL/I Test which in its turn is in fact DFSDDLT0. |
|
Back to top |
|
|
shulba
New User
Joined: 20 Feb 2006 Posts: 2 Location: India
|
|
|
|
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 |
|
|
|