title: Teradata Fastload LDAP authentication issue
body: <p>I am very new to Teradata. Hopefully, I am asking write question in the forum. :)</p>
  
  <p>I have written fastload script that works absolutely fine on the local machine but fails to authenticate on the environment that requires LDAP for auth.</p>
  
  <p>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:</p>
  
  <p>Error Message: Invalid username password.</p>
  
  <p>Please help me understand what additional commands/info is needed to run this script using LDAP authentication.</p>
  
  <p>The following is the script:</p>
  
  <pre><code>logmech ldap;
  
  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 '≡';
  
        DEFINE
           "COL0" (VARCHAR(50)),
           "COL1" (VARCHAR(50)),
           "COL2" (VARCHAR(50)),
           "COL3" (VARCHAR(50)),
           "COL4" (VARCHAR(50)),
           "COL5" (VARCHAR(50)),
           "COL6" (VARCHAR(50)),
           "COL7" (VARCHAR(50)),
           "COL8" (VARCHAR(50)),
           "COL9" (VARCHAR(50)),
           "ID" (VARCHAR(50)),
           FILE = 'D:\test.csv';
            INSERT INTO DemoDB.SALES3 (
              BatchId,
              "COL0",
              "COL1",
              "COL2",
              "COL3",
              "COL4",
              "COL5",
              "COL6",
              "COL7",
              "COL8",
              "COL9",
              "ID"
            )
          VALUES (
              10049,    
           :"COL0",
          :"COL1",
          :"COL2",
          :"COL3",
          :"COL4",
          :"COL5",
          :"COL6",
          :"COL7",
          :"COL8",
          :"COL9",
          :"ID"        
        );
  
     END LOADING;  
  LOGOFF;
  </code></pre>
  
  <p>The following is the BTEQ Script:</p>
  
  <pre><code>.logmech ldap;
  .LOGON server/dbc,"dbc";
  SELECT 1 FROM dbc.TablesV WHERE databasename='DemoDB' AND TableName='dwlogSALES3';
  .IF activitycount =0 THEN .GOTO FirstLabel
  DROP TABLE DemoDB.dwlogSALES3;
  .Label FirstLabel
    SELECT 1 FROM dbc.TablesV WHERE databasename='DemoDB' AND TableName='SALES3_UV';
  .IF activitycount =0 THEN .GOTO SecondLabel
  DROP TABLE DemoDB.SALES3_UV;
  .Label SecondLabel
   SELECT 1 FROM dbc.TablesV WHERE databasename='DemoDB' AND TableName='SALES3_ET';
  .IF activitycount =0 THEN .GOTO ThirdLabel
  DROP TABLE DemoDB.SALES3_ET;
  .Label ThirdLabel
    SELECT 1 FROM dbc.TablesV WHERE databasename='DemoDB' AND TableName='SALES3_WK';
  .IF activitycount =0 THEN .GOTO FourthLabel
  DROP TABLE DemoDB.SALES3_WK;
  .Label FourthLabel
  SELECT 1 FROM dbc.TablesV WHERE databasename='DemoDB' AND TableName='sales3';
  .IF activitycount =0 THEN .GOTO FifthLabel
  DROP TABLE DemoDB.sales3;
  .Label FifthLabel
   .LOGOFF;
  </code></pre>