Although the documentation and the error message content if you try to do this suggests that this is possible, it isn't.
We would like XML to be supported with spanned unloads just as LOB columns are today (and have been supported in the core IBM unload since DB2 10)
|Who would benefit from this IDEA?||Anyone who needs performance while unloading XML and definitely anyone using options not available in the core IBM unload.|
How should it work?
I would suggest using the same spanned syntax option as for LOB unloads.
|Priority Justification||This is missing core functionality and we are constrained to ensure that all unloads of XML columns have only the most basic options that IBM Unload will support.|
|Customer Name||Natwest Group|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions