|
View previous topic :: View next topic
|
| Author |
Message |
Heindba
New User
Joined: 11 May 2010
Posts: 16
Location: South Africa
|
|
|
|
Hi guys,
Please need your help, I have to unload DB2 data from the mainframe to an AIX readable format. Now the unload part I can do that is not a problem but getting it to a AIX readable format is where I get stuck.
Can some one please assist me regarding this situation.
Thanks  |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
When you unload the data on the mainframe, convert all of the content to a delimited text file (i prefer using the tab character - x'05').
Possibly i misunderstand where you are stuck. . . |
|
| Back to top |
|
|
Heindba
New User
Joined: 11 May 2010
Posts: 16
Location: South Africa
|
|
|
|
| thanks for the reply, should I state that in my Unload JCL? |
|
| Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
You should specify numeric columns to be unloaded in display format, if you have mixed contents in you table. Packed or binary fields will not survive an EBCDIC to ASCII conversion.
Unload formats can be specified in control cards DD to your unload utility, and you may also be able to specify any fixed delimiter chars in there. |
|
| Back to top |
|
|
Heindba
New User
Joined: 11 May 2010
Posts: 16
Location: South Africa
|
|
|
|
| Cool, thanks for the help guys. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
| Back to top |
|
|
|
|
