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.
Trim function - Oracle Enterprise
Moderators: chulett, rschirm, roy
Re: Trim function - Oracle Enterprise
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.
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.
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.