Title: TDM File Conversion is failing for Packed Sign (18.0) field.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While trying to convert the generated VSUBSet data for the VSUBSET cluster that is used during the GTXMSKVS subsetting efforts, the numeric_value for the vsubset is not being converted correctly

Environment

TDM 
Test Data Manager
Mainframe

Cause

Due to how DataMaker generates synthetic data and how the interpretation of the ASCII data will be converted to EBCDIC signed packed 18 field.
What is happening is that one byte is being set aside for the signed of the generated numeric value. 

Resolution

Create a function as the following: 
@execsql(S,select format(2343434,'+000000000000000000'))@ 
Where you will add the "+" to the format definition and it will generate the following dataset: 
BUNDLE_REC CUST_NUM +000000000002343434 
Once you execute the file conversion utility, the correct value is added to the packed signed field.