Datamaker: DB2 TimeStamp Column type -> Publishing to SQL Server Datetime Column Error

Document ID : KB000009111
Last Modified Date : 14/02/2018
Show Technical Document Details

Working with DB2 and SQL Server database publishing, an error was found in the scripts that are generated during the process.  After investigation, it appears Quotes are missing.  Is this an error with Datamaker?

DB2SQL ServerGTDatamaker 4.3

When trying to publish from DB2 z/OS or UDB into SQL Server a column of Timestamp data type Datamaker will not put quotes around the information being inserted into SQL Server and the insert fails. This is an error in code.


If a Datamaker patch is needed due to the quotes issue as mentioned, please contact CA Support. You can open a case following this video. Ask support to determine if this patch is in the latest GA version of software delivered after October 13, 2017.  If one could not be included, CA Support team will work with you and development to make sure this fix can be adapted to your environment and specific version if appropriate.

Additional Information:

You can download the latest version of TDM by following the directions in this document:   

To contact support, go to