Hi,
we are trying to create data for the Datapool(generator) based on the subset rules that we created in GT SUBSET.
we see that one table has a column name as "KEY" (which is a keyword)
Below is the error that we are getting and these tables which has this error are not being USED in the Datapool.
Failed to insert data for TABLE_NAME
SQLSTATE = 42000Microsoft SQL Server Native Client 11.0Incorrect syntax near the keyword 'KEY'.No changes made to database.
INSERT INTO MV_196_98626_3100 ( column_1,
KEY, VALUE, DELETED, DELETED_DT, DELETEDBY, CREATED_DT, CREATEDBY, MODIFIED_DT, MODIFIEDBY, VERSION ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
please advise
akhilesh.