HELP - FastLoad

Purpose  

The HELP command returns the syntax of all Teradata FastLoad commands and lists the Teradata SQL statements supported by Teradata FastLoad.

Syntax  

Usage Notes

Table 34 describes the things to consider when using the HELP command.

Table 34: Usage Notes for HELP

Topic	Usage Notes
Using the HELP Command	The HELP command is intended for online use.
Return Message Symbols	The HELP command return messages use these symbols: [ ] (brackets) indicate an optional entry. { } (curly braces) indicate a choice of entries, one of which must be selected.

Example  

The following command example returns a list of Teradata FastLoad commands:

HELP ; 

The Teradata FastLoad completion message is:

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 ;

Note: Replace “FILE=” with “DDNAME=” for z/OS.