DSXchange

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.

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.

you can use Trim in both Transformer and OCI enterprise stage.

I used

select trim(column name) from table in a user-defined sql from my oracle enterprise stage and it did not work.

Gave me this error: Lookup_12: Error when checking operator: Key field "column name" not found in input schema
main_program: Could not check all operators because of previous error(s)

If i take the trim off then it works?? The datatype is char.

Any suggestions.

Try Rtrim()