CATDM- generating the SQL commands file, the SYSDATE is between quotes.
search cancel

CATDM- generating the SQL commands file, the SYSDATE is between quotes.

book

Article ID: 244901

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When generating the SQL commands file, the SYSDATE is between quotes.  Have to manually remove the quotes for the insert to work.
Ex.: INSERT INTO JFB_TEST_DEFAULT_VALUE ("TMS_CREA","DA_EFCTV") VALUES (SYSTIMESTAMP,'SYSDATE');

This has been tested on TDM portal version 4.10.29

Environment

Release : 4.10

Component :

Resolution

This is known.  It is working as designed.  However, Development is taking this as a specific enhancement. - US814784