|
View previous topic :: View next topic
|
| Author |
Message |
Sivkumar Srinivasan
New User
Joined: 02 Aug 2007
Posts: 6
Location: Denver
|
|
|
|
| Is there any IMS utility that can unload a database in a sorted order of the keyfield forthat particular database?? I am currently using DFSURGU0 which is not providing unloads in a sorted order |
|
| Back to top |
|
 |
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| I guess this is not a HIDAM structure? |
|
| Back to top |
|
|
Sivkumar Srinivasan
New User
Joined: 02 Aug 2007
Posts: 6
Location: Denver
|
|
|
|
| its a HDAM database |
|
| Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
You can check BMC unload utilities.
Also from File Aid you can do unload. |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| HDAM is not KEYED sequential. |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| Hmmmmm - forgot to ask WHY you want it unloaded in key sequence? |
|
| Back to top |
|
|
Sivkumar Srinivasan
New User
Joined: 02 Aug 2007
Posts: 6
Location: Denver
|
|
|
|
| I need them sequential bcos all my PSBs are having a load sequential PSBs |
|
| Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
You can write a COBOL program to read all segments sequentially and write it to output file.
Create another Load program which will read this input file and loads to database in sequential |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| If your structure is HDAM and you extract a file from it, it will not be in key sequence. If you try to do a load, you will abend. You must use a simple external sort to first sort before the load. |
|
| Back to top |
|
|
|
|
