Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL errors
The DB I am reading from is on an AS/400, it is a DB2 DB. I have tried to comment out all but the first IIF statement and that didn't work. If you are right and you cannot use the IIF statement, is there an alternative that would accomplish the same thing? I basically need to evaluate a field...- dfauber
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
SQL errors
I receive the following 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: ) ,. when using this sql statement: SELECT * FROM wtecdlib.wqesmpllog WHERE IIF(PDTerm =...- dfauber
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
