Re: Delphi DB2 Access via ODBC

[DAsmussen <DAsmussen@xxxxxxx>]

Bleddyn,

In a message dated 98-01-11 13:02:46 EST, you write:

> I'm trying to use the 'LIKE' keyword in my client queries and get the 
>  following error 'SQL0104 Token ( was not valid ..'. My query is something 
>  like 'SELECT * FROM M.COMPANIES WHERE NAME LIKE '%TEST%'. I am running 
>  client access ODBC drivers and the AS400 is on V4R1M0. We are developing 
>  with Delphi 3.

I'm guessing that your file name is the problem.  SQL uses naming conventions
similar to the /38, where a period (.) separates library
(directory/library/volume) names from file names.  Try a CRTDUPOBJ from
M.COMPANIES into something called just COMPANIES with DATA(*YES).  That
_should_ correct your problem...

HTH,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"Jimi Hendrix was the first rocker on the Internet, his modem was a purple
Hayes."
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---