topic Change Number format On ctl File (sql loader) in Talend Studio

Change Number format On ctl File (sql loader)

Anonymous — Sat, 16 Nov 2024 12:58:58 GMT

Hello,
I would like to know if there is a possibility to put another format in my ctl file when I use a tOracleBulkExec.
In fact, for example, I have this on my file :
- "IDCT" "TO_NUMBER(ltrim(rtrim(:IDCT)), '999999999999D999999999999', 'NLS_NUMERIC_CHARACTERS=''. ''')"
When I want to hava more than 12 integers on my number ('999999999999999999999999D999999999999').
I want to create a new ctl file at each execution, so I don't want to create one, change it manually and use every next time this file.
Thanks for any suggestion !

Re: Change Number format On ctl File (sql loader)

Anonymous — Fri, 15 Apr 2011 02:16:05 GMT

not 100%% sure, but the "Specify .ctl files INTO TABLE clause manually" checkbox in the Advanced Settings sub-tab might work.

Re: Change Number format On ctl File (sql loader)

Anonymous — Fri, 15 Apr 2011 11:37:03 GMT

Thanks for your reply !
I think if I use this checkbox I have to write and describe every fields of my table.