Joined: 15 Aug 2006 Posts: 44 Location: Virginia, USA
I am trying to unload data from a table that has CLOB column in it and need to load the same into other test region. I am getting error
"DSNU1218I -PA0D 266 09:08:39.66 DSNUULIA - LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED THE LIMIT FOR TABLE CDF0001.CLOB_TBL_XML
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
As per the DB2 V10 Messages & Codes manual:
Code:
--------------------------------------------------------------------------
DSNU1220I UNLOAD OF lob-or-xml FROM IMAGE COPY NOT SUPPORTED
Explanation:
For the UNLOAD utility, one or more XML, BLOB, CLOB, and/or DBCLOB columns
are selected on the indicated table when the source object is an image
copy data set.
System Action:
The utility job terminates.
User Response:
Specify a field selection list that does not include any XML, BLOB, CLOB,
or DBCLOB column from the indicated table.
Problem Determination:
When the source object of the UNLOAD utility is an image copy, selection
of a LOB or XML column is not supported.