ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Mass changes needed for sql queries in GTDataMaker

book

Article ID: 187094

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We need to make sure we can maintain our SQL queries, en mass. 
Please let us know where this information is saved outside of GTDataMaker so we can develop a system to make changes to many queries at once.

Environment

Release : 4.6

Component : CA Test Data Manager

Resolution

The columns are stored in gtrep_test_column (tc_column_name and tc_definition) and you need to link it to gtrep_test_row (tc_tr_id <> tr_id) then to gtrep_table_def (tr_table_id <> td_table_id) and gtrep_level_detail (tr_ld_id <> ld_id)



If size of tc_definition data is 2000 then data is stored in gtrep_tc_clob (tcc_definition)