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

Copying IMS databse to Flat file


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
raj_mainframe08

New User


Joined: 11 Sep 2007
Posts: 65
Location: Gurgaon

PostPosted: Tue Jan 15, 2008 4:46 pm
Reply with quote

Hi All,

Since i am very new to IMS DB so please excuse me if my question is irrelevant.

Is it possible to copy a IMS databse to a flat file through JCL. If yes, please let me know the JCL... A little bit of explanation will be appreciated.

Thanks and Regards
Rajiv Garg
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Jan 15, 2008 5:11 pm
Reply with quote

Quote:
If yes, please let me know the JCL


JCL will not do what You want...

JCL will only execute programs,
and as a side effect allocate(create) new files, delete old files..

For something real to happen some program must be executed..

To process an IMS/DB(aka DL/1) database a program must be run,
it could be a user written program or a utility provided by some program product

for a very high speed sequential unload check the HSSR add on package for IMS
Back to top
View user's profile Send private message
srinivas_443

New User


Joined: 19 Dec 2007
Posts: 11
Location: chennai

PostPosted: Wed Jan 23, 2008 1:00 pm
Reply with quote

Hi,

There is no option for this I think, as per my knowledge read what segments you want and write in to file using cobol program/eztrive or you can see segments using IMS-FILEAID.

Regards,
Srinivas Jala
Back to top
View user's profile Send private message
guruji
Warnings : 1

New User


Joined: 13 Apr 2007
Posts: 59
Location: Chennai

PostPosted: Wed Jan 23, 2008 3:08 pm
Reply with quote

Yes. According to my knowledge, FILEAID will do it.
There is a copy option in FILEAID Utilities. U can specify the FROM as your Region DB and TO as your pesonal PDS.
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Mon Dec 29, 2008 3:45 pm
Reply with quote

Yes we can do it with the help of option '4' EXTRACT\LOAD in Fileaid for IMS.Before that we need to enter the selection critera in option 6.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Dec 29, 2008 6:17 pm
Reply with quote

There are probably "unload" products out there. But, first you must know what exactly you want - why do you want the database in a sequential file - what info are you looking for - what format - etc. A cobol DLI program is the most simple option - that way you get exactly what you want. It should not take more than a few hours for the program - executing JCL and testing.
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 Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top