I am running UV/ODBC software against my mainframe database but am trying to create an excel spreadsheet from the data.
I am performing a simple select but am receiving an error: "Error ID: 29 Severity: ERROR Facility: FPSRVERR - Line 3, column 20 (around "ORDER"): Syntax error."
This is my select statement:
FROM WOOR_FILE WOOR_FILE_O
WHERE (WOOR_FILE_O."ORDER" Not Like '%*%')
All I am trying to do is select keys (ORDER) that do not contain an asterisk '*'. I cannot get this simple select statement to work. I would imagine it is something stupid that I am missing but can anyone tell me what is wrong with this?