simplerequest

The SimpleRequest table contains one entry for every request of type simple.

Column Name Column Datatype Column Null Option Column Comment
requestid integer not null The ID from the Request table for this simple request.
sourceproviderid integer not null The ID from the Profile table for this simple request.
sourceservername varchar(128) with null The server name field for overriding the source profile.
sourcedatabasename varchar(128) with null The database name field for overriding the source profile.
sourceloginname varchar(32) with null The login name field for overriding the source profile.
sourceloginpassword byte(32) with null The login password name field for overriding the source profile.
sourceother varchar(128) with null The other field for overriding the source profile.
destproviderid integer not null The ID from the Profile table for the destination profile.
destservername varchar(128) with null The server name field for overriding the destination profile.
destdatabasename varchar(128) with null The database name field for overriding the destination profile.
destloginname varchar(32) with null The login name field for overriding the destination profile.
destloginpassword byte(32) with null The login password field for overriding the destination profile.
destother varchar(128) with null The other field for overriding the destination profile.
desttablename varchar(128) with null The destination table name.
desttableoverwrite integer1 not null The Boolean indicating whether to delete data (TRUE) from the destination table before the data transfer.
bulktransfer integer1 with null The Boolean indicating whether to use bulk transfer mode to the destination (TRUE), if the destination database supports bulk.
deletestring varchar(255) with null Currently not supported.

Product Name: Data Transformer

Table Type: Table


Copyright © 2006 CA. All rights reserved.