Troubleshooting
Problem
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. [IBM][CLI Driver] CLI0118E Invalid SQL syntax. SQLSTATE=37000 This error occurs when you are trying to concatenate a string and a substring against DB2 on an MVS platform using the '+' sign.
Resolving The Problem
Open the cogdmd2.ini file.
Under the [Exceptions Value Expression DATABASE:DSN VERSION:05] section, add the following:
StrCat=T
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
86630
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21331458