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: 10231
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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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