March 12th, 2007, 12:35 PM
|
|
|
|
SQLSTATE=42601 Error on Query
I am trying to query a DB2 Database through DTS in SQL Server 2000, however I am getting an error message I don't understand. I am a SQL Server Person by nature and don't really understand the DB2 syntax. Listed below is the query:
here is my error message:
Quote: | Error Description: [IBM][CLI Driver][DB2] SQL0199N The use of the reserved word "FOR" following "" is not valid. Expected tokens may include: ") OR ". SQLSTATE=42601 | Any help that you could provide would be greatly appreciated.
Thanks.
PS: I copied the format from another query that's run through DTS (no error), just had to add a number of new fields, so I'm not sure what I'm not seeing.
[EDIT]Realized my issue, forgot an ending Parenthesis, if someone can explain to me how that Error Message relates to that issue, I would appreciate it.[/EDIT]
Last edited by mehere : March 12th, 2007 at 01:11 PM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
