Re: ODBC / SQL ERROR SQL0010

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Tim. the second number appears to have the final apostrophe missing. Or the
starting apostrophe should be removed.

HTH

Vern

At 11:47 AM 12/27/02 -0800, you wrote:
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> This is from the ODBC trace... Any idea, what would cause this error?  If I
> copy and paste this command into the SQL script function it works...
>
> thanks, tim
>
>                 HSTMT               00C02988
>                 UCHAR *             0x00E70BB0 [      97] "UPDATE
> EXDBFA.EXPPLVH SET VHVEXP = 4624 WHERE VHINVN = '187538810001' AND VHCLID =
> '187538810001'"
>                 SDWORD                    97
>
>                 DIAG [37000] [IBM][Client Access Express ODBC Driver
> (32-bit)][DB2/400 SQL]SQL0010 - String constant beginning '18753881' not
> delimited. (-10)
>
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review, use, disclosure or distribution is
> prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.