DSXchange

one of the target database has column names as number.
will the datastage support the Column names as number.
i have checked already but need to load the data from file to Database using schema file.

DataStage doesn't support number as column names. Column names should start with alphabet. But you can create alias to your column name and use that in DataStage.

Ok, when we go for Schema File with RCP we cannot use derivations.
Just wanted to know is there any other method to load using Column names as numbers. Handling $ and # characters we can do.

Not really. I guess you could create synonyms in the database. But DataStage can't deal with column names that are numeric.

Thanks Ray, I have renamed the Columns in Table and recreated.