lognvarchar output of Stored proc getting truncated

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
memrinal
Participant
Posts: 74
Joined: Wed Nov 24, 2004 9:13 pm

lognvarchar output of Stored proc getting truncated

Post by memrinal »

We have job where the output of a stored proc is getting truncated.
The column in question contains an XML document of length - 1073741823 characters.
We have used longvarchar as the data type for this column and have not provided any length for it.

Please let me know if there is some way we can extract the output of the prod (XML) correctly without it getting truncated.

Typically for strings etc. of such length what data type is used?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”