Is it mandatory to specify length in case of varchar datatypes. Actually the jobs throw a lot of warnings in case we map fields of different lengths etc.
Would it not be simpler to leave the length blank ? Any downside to it?
Search found 2 matches
- Mon Mar 25, 2019 6:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar datatype length issues
- Replies: 1
- Views: 1992
- Sun Feb 24, 2019 9:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key stage issue
- Replies: 3
- Views: 3219
Surrogate Key stage issue
We recently migrated the OS from Sun Solaris to some Linux version. However, all jobs using the surrogate key tab in transformer are aborting. There are over 600 odd jobs. The source is specified as file. Is there something we missed or the only way to fix the issue is recreate the surrogate key sou...