SQLPrepare failed On Update existing rows only

aoriano · Post by **aoriano** » Fri Feb 27, 2009 8:40 am

Hi,

I am using an ODBC Stage to access a SQL Server 2000 Database and updates rows on a table.

The option is "Update existing rows only".

My Job had no problem but i added a column in the ODBC stage and now, There's an error on the SQLPrepare Select which determines if the rows exist or not. The select query is generated but there is no space between the last colmun I added and the FROM close.

Does anyone have an idea about why there is such a problem on a generated query ?

Code: Select all

SELECT COL1, COL2, COL3FROM TABLE

SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]'COL1' : incorrect column name

SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]'COL2' : incorrect column name

SQLSTATE=S0022, DBMS.CODE=207
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]'COL3FROM' : incorrect column name

ray.wurlod · Post by **ray.wurlod** » Fri Feb 27, 2009 1:07 pm

No space, or a non-space character, between COL3 and FROM ?

How come there is a FROM in an UPDATE anyway?

chulett · Post by **chulett** » Fri Feb 27, 2009 1:46 pm

And a SELECT as well.

aoriano · Post by **aoriano** » Fri Feb 27, 2009 4:46 pm

I just don't know why there is a select.

As I thought it was suspicious, I checked the option again and it's "Update existing rows only". And How could it be a "Select", there is just an Input Stream connected to my ODBC stage.

chulett · Post by **chulett** » Fri Feb 27, 2009 4:56 pm

No clue. Suggest you delete the ODBC stage, add it back to the job and see if that straightens things out for you.