ddtablemodify

The DDTableModify table contains one entry for each table which was written to by Script Manager executions. All writes to a given table via a given profile during a given execution are logged as a single row.

Column Name Column Datatype Column Null Option Column Comment
executionid integer not null The ID from the Execution table for the execution which performed this data transfer.
ddtablemodifyname varchar(128) not null The name of the table into which the data transfer occurred.
ddtableproviderid integer not null The ID from the Provider table for the profile which was used to write this data transfer.
requestid integer not null The ID from the Request table which performed this data transfer.
ddtablemodifytime date not null Time at which this data transfer was logged NOTE: time is when execution ended not started.
ddtabledatabasename varchar(128) with null The name of database (if any) into which the data transfer occurred.
ddtableuserid integer not null The ID from the User table for the user owning the request.

ddnumrowsinserted integer with null The number of rows inserted during this data transfer.
ddnumrowsupdated integer with null The number of updates performed during this data transfer.

Product Name: Data Transformer

Table Type: Table


Copyright © 2006 CA. All rights reserved.