EMS logo

Produits

DB Extract for DB2

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

DB Extract for DB2

Documentation en ligne

Extract Options section


Section [#ExtractOptions#] stores values set on Step 7 of Wizard application.

 

The configuration parameters are listed below.

 

 

 

 

DropTableStmt

0 = Do not add DROP statements for the extracted objects

1 = Add DROP statements for the extracted objects to the result script

 

RecordsInBlock

The number of INSERT statements in a block after which the COMMIT statement is to be added

 

InsertCommit

0 = Do not insert COMMIT statement after each block

1 = Insert COMMIT statement after each block

 

DeleteAllRecords

0 = Do not delete any records from the tables before the INSERT statements

1 = Delete all records from the tables before the INSERT statements

 

Tablespaces

0 = Do not include definition of tablespaces into the extraction script

1 = Include definition of tablespaces into the extraction script

 

Privileges

0 = Do not include access privileges for the extracted objects

1 = Include access privileges for the extracted objects

 

ExtractDependentObjects

0 = Extract dependent objects

1 = Do not extract dependent objects

 

 

 

 

 

BlobExtractType

0 = Do not extract BLOB fields

1 = Extract BLOB fields to strings

2 = Extract BLOB fields into file

 

AddDateTimeToBlob

0 = Do not add the current date and time to BLOB filename

1 = Add the current date and time to BLOB filename

 

AddDateTimeTypeBlob

0 = Date will be added to BLOB filename

1 = Time will be added to BLOB filename

2 = Datetime will be added to BLOB filename

 

 

 

 

 

 


See also:

General and Connection sections

Common Options section

File Options section

Scheduled Task sections

Data Query sections

Databases section