Teradata BTEQ Script

Teradata BTEQ Script

Teradata BTEQ Script for import

/*Section 1*/ .logon 192.168.106.2/teradatapoint,teradatapoint;

/*Section 2*/ CREATE SET TABLE teradatapoint.employee ,NOFALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM=DEFAULT, DEFAULT MERGEBLOCKRATIO      ( emp_IDINTEGER, emp_nameVARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC, mgr_IDINTEGER) PRIMARY INDEX( emp_ID );

.IMPORT DATA FILE=C:\teradatapoint\import_data.txt;

/*Section 3*/ .QUIET ON .REPEAT *

/*Section 4*/ USING emp_ID (INTEGER), emp_name (VARCHAR(10)), mgr_ID (INTEGER)

INSERT INTO teradatapoint.employee     (emp_ID, emp_name, mgr_ID) VALUES    (:emp_ID, :emp_name, :mgr_ID);

/*Section 5*/ .LOGOFF .EXIT

 

Section 1- In this section, We need to provide logon information like tdpid or ip_address of Teradata system, username, password.

Section 2- We need to provide source filename and structure of the data in it.

Section 3- Quiet on limits the output to reporting onlyerrors and processing statistics. .REPEAT * causes BTEQ to read the records till the end of the file.

Section 4- The USING Specifies the parameters of the inputfile.

Section 5- BTEQ logs off from the Teradata system.

Leave a Comment