• Subject: Re: Delphi DB2 Access via ODBC
  • From: DAsmussen <DAsmussen@xxxxxxx>
  • Date: Sun, 11 Jan 1998 16:09:26 EST
  • Organization: AOL (http://www.aol.com)

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
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].