BTEQ - Get Help in Teradata

The BTEQ help displays a brief description of BTEQ, a listing of each command in alphabetical order, and additional notes on input.

Syntax:
.HELP BTEQ


Output Message:
.HELP BTEQ
 BTEQ is a general-purpose utility which enables you to submit DBC/SQL queries to the DBC/1012; it formats the results and returns them to the screen,file, or printer.

BTEQ Commands are:                                

 <BREAK>                                                 
 <BREAK> <BREAK>                                         
 <BREAK> <BREAK> <BREAK>                                 
 abort (can only be used after a request is been interrupted) 
 COMPILE { FILE | DD | DDNAME} [=] xxx [ WITH {{PRINT | NOPRINT} [SPL | NOSPL]}]
                                       [ WITH {{SPL | NOSPL} [PRINT | NOPRINT]}]
 EXPORT {DATA      {FILE|DDNAME}=xxx [[,LIMIT=n] [,CLOSE|OPEN]]}
        {INDICDATA {FILE|DDNAME}=xxx [[,LIMIT=n] [,CLOSE|OPEN]]}
                                     [AXSMOD <modname> ['Init-String']]}
        {REPORT [BOM|NOBOM] {FILE|DDNAME}=xxx [[,LIMIT=[n|*] {n|*}
                                              [,CLOSE|OPEN]]}
        {DIF [BOM|NOBOM] [DATALABELS] {FILE|DDNAME}=xxx [[,LIMIT=n]
                                                        [,CLOSE|OPEN]]}
        {RESET}                                          
 =[n]                                                    
 GOTO   labelname                                        
 HANG   [n]                                              
 HELP   BTEQ                                             
 IF     {ERRORCODE    }                  {BTEQcommand}   
        {             } operator n THEN  {              }
        {ACTIVITYCOUNT}                  {DBC/SQLrequest}
 IMPORT {DATA       {FILE|DDNAME}=xxx [,SKIP=number]}      
        {INDICDATA  {FILE|DDNAME}=xxx [,SKIP=number]}      
                                      [AXSMOD <modname> ['Init-String']]}
        {VARTEXT [Delimiter Char]  {FILE|DDNAME}=xxx [,SKIP=number] }    
        {REPORT     {FILE|DDNAME}=xxx [,SKIP=number]}      
 LABEL  labelname                                        
 LOGDATA  [mechanismdata]                                
 LOGMECH  [mechanismname]                                
 LOGOFF                                                  
 LOGON                                                   
        Batch mode:                                      
          LOGON  [tdpid/]username,password[,'acctid']    
        Interactive mode:                                
          LOGON  [tdpid/]username                        
 MESSAGEOUT [BOM|NOBOM] {FILE|DDNAME}=xxx                 
 OS     os-command                                       
 {QUIT|EXIT} [n|ERRORCODE|ERRORLEVEL|ACTIVITYCO]         
 REMARK {                            }                   
        {'string[//string[//string]]'}                   
        {"string[//string[//string]]"}                 
 REPEAT [n|*|RECS n] [PACK {n}]                          
 RUN    {FILE|DDNAME}=xxx [,SKIP=n]                       

   [SET] AUTOKEYRETRIEVE [OFF|COLUMN|ROW]
   [SET] DECIMALDIGITS   [DEFAULT|n]
   [SET] DEFAULTS                                        
   [SET] ECHOREQ         [ON|OFF]                        
   [SET] ENCRYPTION      [ON|OFF]
   [SET] ERRORLEVEL      [ON|OFF]                        
   [SET] ERRORLEVEL      eeee SEVERITY n                 
   [SET] ERROROUT        [STDOUT|STDERR]                 
   [SET] FOLDLINE        [ON|OFF] [Columnnumber|ALL]     
   [SET] FOOTING         {'string'|"string"}           
   [SET] FORMAT          [ON|OFF]                        
   [SET] FORMCHAR        {[ON|OFF|"Numeric Sequence in HEX"xb]}
                         {[ON|OFF|'Numeric Sequence in HEX'xb]}
   [SET] FULLYEAR        [ON|OFF]                       
   [SET] HEADING         {'string'|"string"}           
   [SET] INDICDATA       [ON|OFF]                        
   [SET] LARGEDATAMODE   [ON|OFF]                        
   [SET] LOGONPROMPT     [ON|OFF]                        
   [SET] NULL            [AS]     {'string'|"string"}  
   [SET] NOTIFY          LOW|MEDIUM|HIGH MSG 'msg'|EXIT exitname
   [SET] NOTIFY          OFF 
   [SET] OMIT            [ON|OFF] [Columnnumber|ALL]     
   [SET] PACK            [n]                             
   [SET] PAGEBREAK       [ON|OFF] [Columnnumber|ALL]     
   [SET] PAGELENGTH      n                               
   [SET] PREPAREMODE     [OFF|PREPINFO|STMTINFO]
   [SET] QUIET           [ON|OFF]                        
   [SET] RECORDMODE      [ON|OFF]                        
   [SET] REPEATSTOP      [ON|OFF]                        
   [SET] RETCANCEL       [ON|OFF]                        
   [SET] RETLIMIT        [{n|*} [n|*]]                   
   [SET] RETRY           [ON|OFF]                        
   [SET] RTITLE          {'string'|"string"}           
   [SET] SECURITY        [NONE|PASSWORD|PASSWORDS|ALL]   
   [SET] SEPARATOR       ['string'|"string"|n] [ALL]   
   [SET] SESSION CHARSET ['string'|"string"|n]
   [SET] SESSION RESPBUFLEN    [DEFAULT|n|MAX32|MAX64|MAX1MB]
   [SET] SESSION SQLFLAG [NONE|ENTRY|INTERMEDIATE]
   [SET] SESSION TRANS[ACTION] [BTET|ANSI]
   [SET] SESSION TWORESPBUFS   [ON|OFF]
   [SET] SESSIONS        n                               
   [SET] SIDETITLES      [ON|OFF] [withnumber]           
   [SET] SKIPDOUBLE      [ON|OFF] [Columnnumber|ALL]     
   [SET] SKIPLINE        [ON|OFF] [Columnnumber|ALL]     
   [SET] SUPPRESS        [ON|OFF] [Columnnumber|ALL]     
   [SET] TDP             tdpid                           
   [SET] TIMEMSG         DEFAULT|QUERY|NONE              
   [SET] TITLEDASHES     [ON|OFF] [withnumber]
   [SET] UNDERLINE       [ON|OFF] [Columnnumber|ALL]     
   [SET] WIDTH           n                             

 SHOW  {CONTROL[S]}                                      
 SHOW  {ERRORMAP}                                        
 SHOW  {VERSION[S]}                                      

Bteq Command Notes:

 - All BTEQ commands must be preceded by a dot '.' character.      
 - BTEQ commands may end with a semicolon ';'.             
 - Any command that does not start with a dot is assumed to be
   a DBC/SQL query and it will be submitted to the DBC/1012.
 - BTEQ commands may be executed in a DBC/SQL macro by using the 
   ECHO statement, for example: 

      ECHO '.HELP BTEQ';