XQE-DAT-0001 Data source adapter error: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0199] Keyword AS not expected. Valid tokens: FULL LEFT CROSS INNER RIGHT EXCEPTION.
The SQL will run on the IBMi. It will also validate in Cognos with no errors. However, when I try to run the report in HTML or any other format, I get the above error. I’m not sure why this will validate in Cognos but not run in Cognos.