I am very new to Teradata. Hopefully, I am asking write question in the forum. :)
I have written fastload script that works absolutely on the local machine but fails to authenticate on the main environments.
The main environments uses LDAP authentication. I have used "logmech ldap" in my script but it still doesn't work. Please see below the script I am trying to run:
Error Message: Invalid username password.
LOGON server/dbc,"dbc"; DATABASE DemoDB;
CREATE TABLE SALES3 ,FALLBACK ,NO BEFORE JOURNAL ,NO AFTER JOURNAL ( ID VARCHAR(50) TITLE 'ID' NULL , BatchId BIGINT TITLE 'BatchId' NULL ,CREATED DATE TITLE 'Created On' NULL ,COL0 VARCHAR(50) TITLE 'COL0' NULL ,COL1 VARCHAR(50) TITLE 'COL1' NULL ,COL2 VARCHAR(50) TITLE 'COL2' NULL ,COL3 VARCHAR(50) TITLE 'COL3' NULL ,COL4 VARCHAR(50) TITLE 'COL4' NULL ,COL5 VARCHAR(50) TITLE 'COL5' NULL ,COL6 VARCHAR(50) TITLE 'COL6' NULL ,COL7 VARCHAR(50) TITLE 'COL7' NULL ,COL8 VARCHAR(50) TITLE 'COL8' NULL ,COL9 VARCHAR(50) TITLE 'COL9' NULL );
BEGIN LOADING DemoDB.SALES3 ERRORFILES SALES3_ET, SALES3_UV CHECKPOINT 100000; SET RECORD VARTEXT '≡';