Welcome to the new CogKnowHow.com!

If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Cognos 11.0.9 XQE-DAT-0001 Data source adapter error

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.