TERADATA-BULK option
TERADATA-BULK generates the control statements necessary to create a Teradata table and load a large amount of data into it using the Teradata Bulk Data Load utility.
The CREATE DDL statements (DBC/SQL) and the Bulk Data Load statements must be processed separately.
When the TERADATA-BULK option is specified, UNLOAD PLUS creates control statements similar to those in the following example for use with the Bulk Data Load utility:
( <colName1> <colType(length)> NOT NULL
, <colName2> <colType(length)>
);
LOGON 0/USERID,PASSWORD;
*
DEFINE
<colName1> (<colType(length)>)
, <colName2> (<colType(length)>)
DDNAME = <ddname>;
*
INDICATORS OFF;
*
INSERT INTO <tableName> VALUES
( :<colName1>
, :<colName2>
);
LOGOFF;
When the unload has completed, edit the data set containing the control statements just produced, extract and modify the CREATE TABLE DDL, then use this DDL to define the table to Teradata.
When the table to be loaded is defined to Teradata, modify the LOGON statement as required by your installation, and use these statements as input to the Bulk Data Load utility.
When UNLOAD PLUS creates DDL for tables with more than 50 columns, ALTER statements are generated for columns 51 and higher. In cases where the Teradata limit of 256 columns is reached, all statements are generated and a warning message is issued.
Due to Teradata restrictions, when more than 50 columns are to be loaded, you must modify the control statements to process multiple utility executions.
Related topic