Varchar field is null-padded after converting from Binary

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gazelle
Premium Member
Premium Member
Posts: 108
Joined: Mon Nov 24, 2003 11:36 pm
Location: Australia (Melbourne)

Varchar field is null-padded after converting from Binary

Post by Gazelle »

I have a PX job that reads in an entire record as a single binary column.
The binary column is later passed to a Column Export, that converts the binary column into a Varchar(4000) field, which is then output to a delimited Sequential File, with variable-width records.

The problem is that the text file is right-padded with null characters.

How can I output the original binary field as a variable-width Varchar(4000) field?
Post Reply