I'm trying to run a wildcard query on a physical file in my iSeries platform from my VBscript asp page. Every time I do so, I get this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0104 - Token % was not valid. Valid tokens: ( ? : USER CURRENT
My SQL statement is SQL="SELECT * FROM FILENAME WHERE FIELDNAME LIKE %1234% "
I've used %,*,and ? as the wildcard symbol, but still the physical file does not recognize it.What's going on?
Your query has no valid syntax.
Here is the syntax:
SQL="SELECT * FROM FILENAME WHERE FIELDNAME LIKE '%1234%'
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
Check out this Search400.com Featured Topic: Networking and the iSeries
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
Dig Deeper on iSeries Access (Client Access)
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.