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
 

 

Copying IMS databse to Flat file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Copying IMS databse to Flat file
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Tue Jan 15, 2008 5:11 pm    Post subject: Reply to: Copying IMS databse to Flat file
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    Post subject:
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: Bangalore

PostPosted: Wed Jan 23, 2008 3:08 pm    Post subject: Reply to: Copying IMS databse to Flat file
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    Post subject: Reply to: Copying IMS databse to Flat file
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    Post subject:
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    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 Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 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
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


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