you can use Trim in both Transformer and OCI enterprise stage.arun_im4u wrote:Hi,
How can I trim the columns in a user defined sql via Oracle enterprise stage?? I tried using Trim(column_name) in my user-defined sql and it did not work.
Do I have to use a transformer to trim fields??
Thanks,
AR.
Search found 1 match
- Wed May 17, 2006 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim function - Oracle Enterprise
- Replies: 3
- Views: 1447