ODBC Column name error
Posted: Thu Nov 06, 2008 1:27 am
Hi,
I am selecting a column called "Match-type" using ODBC stage from progress database.
I get [OpenLink][ODBC][Progress Server]Syntax error (7587).
is the "-" hyphen causing problem?
I read "Server and Parallel Jobs
Column names can be any length. They must begin with an alphabetic
character or $ and contain alphanumeric, underscore, period, and $
characters"
Also its mentioned in ODBC guide.
Names are translated exactly except when the external data source column name contains a character that DataStage does not support. In that case, two underscored characters replace the unsupported character.
Should it be converted to two underscore character?
But this is not happening currently.
Is it somthing to do with the NLS setting ?
The NLS setting for project is ISO8859-1
Can anyone guide me?
Thanks
Harshada
I am selecting a column called "Match-type" using ODBC stage from progress database.
I get [OpenLink][ODBC][Progress Server]Syntax error (7587).
is the "-" hyphen causing problem?
I read "Server and Parallel Jobs
Column names can be any length. They must begin with an alphabetic
character or $ and contain alphanumeric, underscore, period, and $
characters"
Also its mentioned in ODBC guide.
Names are translated exactly except when the external data source column name contains a character that DataStage does not support. In that case, two underscored characters replace the unsupported character.
Should it be converted to two underscore character?
But this is not happening currently.
Is it somthing to do with the NLS setting ?
The NLS setting for project is ISO8859-1
Can anyone guide me?
Thanks
Harshada