Server to EE job migration - Missing columns action in EE?

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
ffsw13
Premium Member
Premium Member
Posts: 31
Joined: Mon Feb 01, 2016 10:29 am
Location: USA
Contact:

Server to EE job migration - Missing columns action in EE?

Post by ffsw13 »

Greetings,

Trying to migrate DataStage server jobs ported to 11.5 and in all the Server source Sequential File stages I see on the output tab they have set the Missing column action to "Pad with SQL NULL". How to I do the same thing in the EE (parallel) job? I don't see that option on the parallel SF stage.. Maybe I have to do something different to achieve the same result?

Same question on the Default Padding option where the default is #

TIA,

ff
The UNIVERSE is vast and expansive
I never Metadata I didn't like
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Check the environment variable APT_IMPORT_HANDLE_SHORT, that might be part of your solution
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Post Reply