year and month in oracle 9i dirct load

[ratikmishra1]

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.

[chulett]

Those are reserved words and must be double-quoted if you want to use them in a sqlldr control file.

[ratikmishra1]

How do I do that in the oracle enterprise stage. Is there any option setting that allows me to put quotes in the column names?

Thanks
Rati

[ArndW]

Convert the SQL to custom SQL and add the double quotes.

[ratikmishra1]

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?

Thanks
Rati

[ratikmishra1]

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?

Thanks
Rati

[ArndW]

... Am I missing something?

Nope, I did. How about declaring DB/2 synonyms for the columns that use reserved words?

[ratikmishra1]

Oracle synonyms are at table level not at column level. So that option is not available.