IBM Support

Error number -119 character in CAST argument is invalid, and DMS-E-INVALIDNULL

Troubleshooting


Problem

Descri[ption: After upgrading a report from Impromptu 7.0 to 7.3, receiving two error messages: Error number -119 character in CAST argument is invalid, and DMS-E-INVALIDNULL. There are also cast conversions in the SQL that were not present in version 7.0. Environment: Win2000, Impromptu 7.3.648, DB2/400 on V5R2 via iseries access express V5R2 Error Message - Error number -119: DMS-I-INFORMATION, The target database has returned information concerning the 'fetch' operation. [IMB][iSeries Acess ODBC Driver][DB2 UDB]SQL0420 - Character in CAST argument not valid. DMS-E-INVALIDNULL, The database returned a NULL value for a column previously described as not nullable. Solution: Examine the calculation in the report, looking specifically for nested conversions around a calculation, of the form:

number-to-string ( string-to-number (number-to-string ( numericfield ) + stringfield + '01' ) )
If such a calculation exists, remove the two redundant conversions so that it looks like:
number-to-string ( numericfield ) + stringfield + '01'
] This does not eliminate the cast statements in version 7.3. The report functions properly.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 7.3;PowerPlay Transformer 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","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

1012943

Document Information

Modified date:
09 May 2025

UID

swg21350204