Column getting truncated when referenced in another column in Portal

Document ID : KB000008896
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

In an FD (File Delimited) layout and in a row, a value is created. In a column in the same row, we need to use that column's value to make a call the to the DB to get another value.  In this case, the first column is 30 char long with the target column being 8 char long. When pulling from position 11 in the 30 character value, a NULL value is returned. As a result, we are getting a DB2 SQL Error in the Portal: SQLCODE=-104, SQLSTATE=42601.

Environment:
TDM Portal 4.3.15.0DB2
Cause:

The code needs to be modified to fix this defect.

Resolution:

Please obtain the Patch from Support or check with Support if this patch is contained in the current GA.  You can open a support case by going to https://support.ca.com/us.html or https://www.ca.com/us/services-support/ca-support/contact-support.html

 

Below are the instructions to implement this patch (TDMWeb-4.3.46.0.zip):

***************************************************** 
The changes apply to this list functions: 
Lov, seqlov, and randlov will have an additional optional parameter truncate_to_db_length. 
The parameter accepts only true\false. 
The default value when this parameter is not specified is true, i.e., it works as before. 
The truncate_to_db_length parameter when specified false will not truncate the evaluated value. 
***************************************************** 

Please note that you have to go down to the lowest equation in your series of Column to Column references and make sure the fix above is applied to all levels.