Failed to retrieve data from the database Informix [Database Vendor Code -11060]

[Former Member]

I am using Crystal Reports Version 11.5 and have successfully connected to an Informix DB.  I am using the Crystal Command to write my SQL Select Statement.  For the most part everything works fine exect when I add a "CASE WHEN" in my select statement.  This Select statement works fine in the Informix DB Access tool, it also works fine in Aqua Data Studio management tool.  However when I attempt to use it in the Crystal Command if gives me an error of "Failed to retrieve data from the database. Details: HY000:[Informix][Informix ODBC Driver] General error.Syntax error [Database Vendor Code: -11060]".  I am working with an Infromix DB version 9.52C1 and Informix ODBC Driver 3.31.00.10287 which is a 32 BIT Driver.  Any help is appreciated.  Please see SQL Statement below

Select a.Vendor, a.Buyer, Case When a.Facility = '1' Then 'Grocery' When a.Facility = '2' Then 'Deli' When a.Facility = '3' Then 'Meat' Else 'Other' End Department From Customer a

[Former Member]

Select a.Vendor, a.Buyer, Case When a.Facility = '1' Then 'Grocery' When a.Facility = '2' Then 'Deli' When a.Facility = '3' Then 'Meat' Else 'Other' End

Try:

As Department

From Customer a

[Former Member]

you might also need to add you schema name before the table.

[Former Member]

The error:

Details: HY000:[Informix][Informix ODBC Driver] General error.Syntax error [Database Vendor Code: -11060]".

is coming directly from the db client - unmodified by the CR engine. E.g.; look up the error in your database documentation.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces