ALTER STATEMENT In ODBC

dganeshm · Post by **dganeshm** » Thu Mar 25, 2010 11:04 am

When I give the following user defined SQL in the ODBC Stage ...

alter sequence maximo.queryseq increment by ? .. its throwing an error ::

[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-01722: invalid number
LASTQUERYID = 3881

Any ideas ??

DSguru2B · Post by **DSguru2B** » Thu Mar 25, 2010 11:18 am

Where you providing that, in the main sql or before/after tab?

dganeshm · Post by **dganeshm** » Thu Mar 25, 2010 11:30 am

It doesnt have a before/after sql..this is in the main sql..

DSguru2B · Post by **DSguru2B** » Thu Mar 25, 2010 11:32 am

I doubt you can provide any statement other than DML instructions there. What exactly are you trying to accomplish? The statement reveals that you are setting the sequence object for each incoming row. May I ask why?

dganeshm · Post by **dganeshm** » Thu Mar 25, 2010 11:40 am

I am trying to get the max sequence id in a previous stage pass it to this ODBC stage and altering the sequence to increment by that number... it works when I had code a value or pass it as job parameter..

DSguru2B · Post by **DSguru2B** » Thu Mar 25, 2010 11:42 am

Make sure there is no new line character or even an extra space in your sql. Sometimes that causes issues.