Column Naming Conventions

laknar · Post by **laknar** » Thu Jul 01, 2010 10:06 am

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.

anbu · Post by **anbu** » Thu Jul 01, 2010 10:20 am

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.

laknar · Post by **laknar** » Thu Jul 01, 2010 10:38 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 01, 2010 11:24 am

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

laknar · Post by **laknar** » Thu Jul 01, 2010 1:11 pm

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