I need to generate data in a VARBINARY field.
When I publishto directly into the table (TGT) everything works well.
When I publishto a SQL file, TDM puts the value between quotes. It should not.
Tested on the TDM portal with version 4.9.291.
1- the create table
2- the generator (I put the value 1 in the field)
3- the submitted request of the TGT publishto
4- the submitted request of the SQL publishto (DBMS SQL Server)
5- The SQL file produced
6- The content of the generated SQL file indicating the apostrophes
7- The result of the execution of the inserts with and without apostrophes
Release : 4.9.1
Component : CA Agile Requirements Designer - TMX Script Generator
This has been addressed in later versions of 4.9 releases.
Download and install the latest patch from TDM patches link given below to fix this issue.