I can manage this in a Server job but it throws a "metadata mismatch" warning because I have to declare the column as LongVarChar rather than the LongNVarchar it really wants. I have to because, while I can View Data just find in the Server job with it as LongNVarchar, I can't compile the dang job that way since NLS is not installed here.
I was hoping to make this a PX job and use a message handler to demote the warning but I can't even View Data from the OE stage. All I get is:
Code: Select all
Error executing View Data command:
##E TDOD 000001 09:30:45(006) <main_program> Datatype Not Supported