search cancel

Trying to use a Numeric field and manipulate it as a string and getting an error when using it in the Main Frame module.

book

Article ID: 42148

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

During a masking job the following errors occurred: 

17.07.45 JOB00861 CAPE025I D2MJ100A STEP05 UNHANDLED CONDITION IGZ0040S RAISED IN PROGRAM CEEPLPKA AT OFFSET +0CCF98. 
17.07.45 JOB00861 SEND 'CAPE025I D2MJ100A STEP05 UNHANDLED CONDITION IGZ0040S RAISED IN PROGRAM CEEPLPKA AT OFFSET +0CCF98. ' 

Few lines down... 
… 
Program name GTXMSKF 
Program version 5.1.2 
Program date 2015-09-28 
IGZ0040S An invalid separate sign was detected in program GTXMSKFB on line 3260. 
From compile unit GTXMSKFB at entry point GTXMSKFB at compile unit offset +00006898 at entry offset +00006898 
at address 2AAA6020. 

Cause

The error occurs as they are trying to use SUBSTR on a numeric field.

Environment

Release: TDMTDD99000-3.5-Test Data Manager-for Test Data on Demand
Component: Test Data Manager-Mainframe DB2 Add On

Resolution

If this is required, the numeric value needs to be assigned to a work string; then manipulated as a string; and assigned back to the numeric. (It is your responsibility to ensure the value being re-assigned back to the numeric is valid (numeric and size). 
Unfortunately this editing cannot be done within Datamaker (does not support the work variables) and must be done manually against the transformation map file. 
See user guide for more details on the SETSTR & ASSIGNSTR functions. 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/mainframe/masking-functions-for-mainframe/internal-string-variables.html