Default values, generator keeps the apostrophes for a 1 character length field. Generator states it is 3 characters.

Article Id: 194864

Status: Published

Updated On: 10-07-2020 10:16

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

Hello,

When the definition of a field in an Oracle table includes a default text value, the generator retains the apostrophes. So, for a field length of 1 the generator sets a default value of 3 characters. We have to remove the apostrophes manually for all fields with a default value. The generator should remove these apostrophes.

Table definition:

CREATE TABLE SCRAMBLE.JFB_TEST_PUBLISH_SQL
(
APOSTROPHE VARCHAR2(260 CHAR),
DEFAUT CHAR(1 BYTE) DEFAULT 'E' NOT NULL

)

Environment:

Release : 4.9

Component : CA Test Data Manager

Resolution:

The fixed binary is available at TDMWeb-4.9.68.0.zip. Please contact Braodcom Support for this version or later.