Sqlserver from datastage: load table with strange name

sangi1981 · Post by **sangi1981** » Tue Jun 21, 2011 7:44 am

Hi All,

I have a sqlserve table, whose name is like "Vers-xxx_yyy".
As you can see, there is a character "-".
I don't know why this table was made so
But, I have to load it from datastage job.
So when I run my job, I obtain error "table doesn't exist".
I use odbc stage.

Directly on sqlserver it is possible to use sintax [Vers-xxx_yyy], but not in datastage.

Is there a way to avoid/resolve the problem?

Thanks in advance

chulett · Post by **chulett** » Tue Jun 21, 2011 8:02 am

Actually, I thought you need to do the exact same thing in DataStage... did you try it? What happened?

sangi1981 · Post by **sangi1981** » Tue Jun 21, 2011 8:14 am

OK, thanks.

I used the odbc stage with write option, and in this case the use of square brackets gives error.
By using the upsert option within odbc stage, now table with square brackets is properly recognized.
Thanks