IBM Support

Connecting to database provided by JAMIS via a Transoft ODBC driver

Troubleshooting


Problem

Database and Impromptu 5.0 version provided by JAMIS Connecting via Transoft ODBC Unable to use a Jamis Impromptu 5.0 catalog with Impromptu 7.0 to create new or run existing reports. For example, when attempting to use the wildcard (%) in a prompt, the following error occurs - Error number -239: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. DMS-E-SS_PARSER, An error was detected during processing of the SQL request. DMS-E-SS_UNSUPP_FEATURE, The target database does not support the ESCAPE clause of the LIKE operator. Other errors may include Transoft ODBC errors - Error number -239 DMS-E-GENERAL, A general exception has occurred during operation 'prepare request' DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request. [Transoft][TSODBC][usqlsd]'FROM' expected here (c1)

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 6.0;Impromptu 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

114583

Document Information

Modified date:
09 May 2025

UID

swg21333001

Page Feedback