Yuan_Edward wrote:Did you set the environment variable APT_ORACLE_LOAD_DELIMITED in your job? Also are there any double quotes in the input data?
What error did you get in the sqlldr log? Can you post the sqlldr log file?
xinhuang66 wrote:thanks for your output.ArndW wrote:Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the explicit column definitions into this file. You should take it up with your support provider. ...
I still couldn't make it work. I use upsert method at this moment. And I raised my questions to IBM guys. They did the test. And come back to me say that it works on their Oracle system.
I don't know whether I need to do some special configuration in Oracle. However, if I test a sqlldr control file (with column length) in my oracle, it works
Sqlldr complain the column exceed the maximum length. Since I use fixed length format like Char(2000), it still gets the error, I didn't consider the
APT_ORACLE_LOAD_DELIMITED environment issue.
Thanks