i am tying to load a table via dirct load. This table has year and month column. While running the job sqlloader abends with invalid keyword error message (as I have columns named as year and month). I can write a custome sqlloader control file to load the data by putting quotes around year adnd month columns). I'd like to use the datastage oracle enterprise stage to do the load. Is there any way to quote the column names. I tried providing select list where the column names are quoted. it does not work.
Will appreciate any help.
Custom SQL?
I am talking about direct load option in OracleEnterprise stage in 7.5 parallel. Are you talking about a different stage?
I 've chosen the Write method=Load and Write mode=Append. And with this setting I am unable to see any way to enter custom SQL. Am I missing something?
Custom SQL?
I am talking about direct load option in OracleEnterprise stage in 7.5 parallel. Are you talking about a different stage?
I 've chosen the Write method=Load and Write mode=Append. And with this setting I am unable to see any way to enter custom SQL. Am I missing something?