|
View previous topic :: View next topic
|
| Author |
Message |
nmr4u
New User
Joined: 14 May 2007
Posts: 9
Location: India
|
|
|
|
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 |
|
 |
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| You should write a small COBOL program for doing this. |
|
| Back to top |
|
|
abin
Active User
.jpg)
Joined: 14 Aug 2006
Posts: 198
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| 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 |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19
|
|
|
|
| DLITEST and convert the data like Devzee said. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| 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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| Quote: |
| Try the DB2 UNLOAD utility. |
Do you say use DB2 unlaod for IMS db? |
|
| Back to top |
|
|
amrita.chatterjee
New User
Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India
|
|
|
|
| I think, u can use Extract/Load option available under FI(file aid for IMS) |
|
| Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| 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 |
|
|
amrita.chatterjee
New User
Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India
|
|
|
|
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 |
|
|
|
|
