HELP | Completion Message | Teradata FastLoad - 17.10 - Completion Message - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

The Teradata FastLoad completion message follows:

Listed below is the syntax of each Teradata FastLoad command.
   Single-line commands may be preceded by a [.] or terminated by a [;].
   Multi-line commands must NOT be preceded by a [.] but must be terminated by a [;].
   SQL statements must NOT be preceded by a [.] and MUST be terminated by a [;].
   AXSMOD name [ "<init-string>" ] ;
   BEGIN LOADING [dbname.]tname1
      ERRORFILES [dbname.]errortname1,         [dbname.]errortname2
      [ CHECKPOINT integer ]
      [ INDICATORS         ] ;
   CLEAR ;
              { INTEGERDATE }
   DATEFORM { ----------- } ;
              { ANSIDATE    }
   DEF[INE]
        [ fieldname (data type [,NULLIF [=] value ]) ...
        [,fieldname (data type [,NULLIF [=] value ])] ]
        [ { FILE=filename } ]
        [ {               } ] ;
        [ { INMOD=name    } ]
   END LOADING ;
   ERRLIMIT n ;

   HELP ;
   HELP TABLE tname ;
   The INSERT statement has two formats:
   1.  INS[ERT] [INTO] tname.* ;
   2.  INS[ERT] [INTO] tname (cname [... ,cname])
   VALUES (:fieldname [... ,fieldname]) ;
   LOGOFF ;
   LOG[ON] [tdpid/] username,password [ , 'acctid' ] ;
           { OFF    }
           { ---    } [ EXIT  [name] [TEXT "string"] ]
   NOTIFY { LOW    } [ MSG   [text]               ] ;
          { MEDIUM } [ QUEUE [options]            ]
          { HIGH   }
   OS oscommand ;
   QUIT ;
   RECORD [startrecordnumber] [THRU endrecordnumber] ;
   SESSIONS n|* [ m|* ] ;
               { FORMATTED                               }
   SET RECORD  { ---------                               } ;
               { UNFORMATTED                             }
               { VARTEXT [ c ] [DISPLAY_ERRORS] [NOSTOP] }
                        { 0 - 255      }
                        { ASCII        }
   SET SESSION CHARSET  { -----        } ;
                        { KanjiEUC_0U  }
                        { KanjiSJIS_0S }
   SHOW ;
   SHOW VERSION[S] ;
   SLEEP n ;
   TENACITY n ;
   The following DBS/SQL statements are supported by the
   FastLoad utility:
   CREATE TABLE
   DATABASE dbname ;
   DEL[ETE] FROM tname [ ALL ] ;
   DROP TABLE tname ;
Replace “FILE=” with “DDNAME=” for z/OS.