Re: Delphi DB2 Access via ODBC

[Jromeh <Jromeh@xxxxxxx>]

Dean replied to Bleddyn...

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

Did it? Why would this statement cause SQL to complain about parens? SQL 
can use that sort of naming, but on the 400 it can also use our trusty 
slash. What did M. represent in the first place? Is this something 
related to the ODBC?

Just interested,

Jerome

/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
/* Jerome Hughes                        jromeh@aol.com                 */
/* InterPro Consulting Services         www.interproinc.com            */ 
/* Rosemont IL USA                      these are my own opinions only */
/* OMNI User Communications Director    www.omniuser.org               */
/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
We try to solve the problem by rushing through the design process so that
enough time is left at the end of the project to uncover the errors that
were made because we rushed through the design process. -- Glenford Myers


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