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

book

Article ID: 131445

calendar_today

Updated On:

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

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. 

Environment

Release:
Component: TDMMNF

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.