Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Download IMS DB segments into displayable format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
nmr4u

New User


Joined: 14 May 2007
Posts: 9
Location: India

PostPosted: Wed Sep 05, 2007 10:42 am    Post subject: Download IMS DB segments into displayable format
Reply with quote

Hi,

I would need to download all the segments of an IMS DB into a flat file with all the COMP & COMP-3 fields converted to a displayable format (numeric or character).

Can I get the utilities or tools or methods which would do the above.

Thanks,
Mohan
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Sep 05, 2007 1:36 pm    Post subject:
Reply with quote

You should write a small COBOL program for doing this.
Back to top
View user's profile Send private message
abin

Active User


Joined: 14 Aug 2006
Posts: 198

PostPosted: Tue Sep 11, 2007 5:08 pm    Post subject:
Reply with quote

Hi Mohan,

If the flat file is for viewing purpose only and the user knows how to operate fileaid.
If you have IMS Fileaid in your shop, it can be used to unload the Db to a flat file.
Using the fileaid you can view this file.

Or more simply you can view IMS DB using fileaid.

Regards,
Abin
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Sep 11, 2007 7:22 pm    Post subject:
Reply with quote

Quote:
IMS Fileaid in your shop, it can be used to unload the Db to a flat file.

This will not do conversion
Quote:
COMP & COMP-3 fields converted to a displayable format (numeric or character).
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Sep 12, 2007 1:52 am    Post subject:
Reply with quote

DLITEST and convert the data like Devzee said.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Sep 12, 2007 5:10 am    Post subject: Re: Download IMS DB segments into displayable format
Reply with quote

nmr4u wrote:
Hi,

I would need to download all the segments of an IMS DB into a flat file with all the COMP & COMP-3 fields converted to a displayable format (numeric or character).

Can I get the utilities or tools or methods which would do the above.

Thanks,
Mohan

Try the DB2 UNLOAD utility.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Sep 12, 2007 8:59 am    Post subject:
Reply with quote

Quote:
Try the DB2 UNLOAD utility.

Do you say use DB2 unlaod for IMS db?
Back to top
View user's profile Send private message
amrita.chatterjee

New User


Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India

PostPosted: Wed Sep 12, 2007 11:27 am    Post subject: Reply to: Download IMS DB segments into displayable format
Reply with quote

I think, u can use Extract/Load option available under FI(file aid for IMS)
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Sep 12, 2007 11:38 am    Post subject:
Reply with quote

amrita.chatterjee

Quote:
COMP & COMP-3 fields converted to a displayable format (numeric or character).

Can this be done from your solution? Moreover your answer is same with what abin has posted.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Sep 12, 2007 12:04 pm    Post subject: Re: Download IMS DB segments into displayable format
Reply with quote

Craq Giegerich wrote:
Try the DB2 UNLOAD utility.
For IMS unload, DB2 unload will not work... Or is there any option, I'm not aware of?
Back to top
View user's profile Send private message
amrita.chatterjee

New User


Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India

PostPosted: Wed Sep 12, 2007 12:17 pm    Post subject: Reply to: Download IMS DB segments into displayable format
Reply with quote

Devzee,

I am not aware of any option like Db2 unload for IMS DB, for this reason, I have mention Extract option of Fileaid for IMS.
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 Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us