search cancel

TDM Mainframe mask REPLACE function fails when using space character

book

Article ID: 215382

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Using the REPLACE function on the mainframe with the following section in MAPCSV works OK on Windows in FDM: 
,REPLACE, 01,   ,
This is meant to replace 01 that has a preceding space character with a string of 3 spaces.
It fails on the mainframe with:  00048E   Parameter 2 must be set

Environment

Release : 4.9

Component : CA Test Data Manager - Others

Resolution

Enclose the values to be replaced in double quotes: 
,REPLACE," 01","   ",
In general it is good practice to enclose strings in double quotes.