|
View previous topic :: View next topic
|
| Author |
Message |
yogi.47eie
New User
Joined: 16 Aug 2006
Posts: 45
Location: india
|
|
|
|
Hi ,
We have a situation to unload the data from remote DB2 for LUW server to Mainframe Zos DB2 .
Remote unload using DSNTIAUL is working fine for normal tables not having LOB columns.
But while unloading the CLOB columns data is getting truncated and maximum length allowed is restricted till 32755 .Our CLOB columns are having length more than 32755 & JSON content.
Any alternative way to unload CLOB columns from remote server to mainframe DB2 ?
Note:
We tried cross loader also but ended with
DSNU283I -DSNURWBF - LOB ERROR
SQLCODE = -433
SQLERRM = <Lob-Value
i.e. -433 VALUE value IS TOO LONG
Any DB2 experts view will be helpful .
Thanks
Yogi |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2024
Location: USA
|
|
| Back to top |
|
|
yogi.47eie
New User
Joined: 16 Aug 2006
Posts: 45
Location: india
|
|
|
|
Thanks .The link you shared is for DB2 for zos .i.e. Unload utility that will perfectly work for CLOB table within Mainframe(zOS).But it won't work for a table present in remote location (DB2 for LUW).We tried this option too already. This Unload utility will not recognize the Remote table .We will get error DSNU056I csect-name TABLE table-name NOT FOUND.
I am referring here REMOTE unload.i.e. RemotLocation.Schema.Table
Thanks for the advice ! |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Did you try giving LOBFILE in Parms ? |
|
| Back to top |
|
|
yogi.47eie
New User
Joined: 16 Aug 2006
Posts: 45
Location: india
|
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Glad it worked .. the link that you shared can’t be opened .. |
|
| Back to top |
|
|
yogi.47eie
New User
Joined: 16 Aug 2006
Posts: 45
Location: india
|
|
| Back to top |
|
|
|
|
