Sunday, January 30, 2011

What is the command in BTEQ to check for session settings ?

What is the command in BTEQ to check for session settings ?

Answer
The BTEQ .SHOW CONTROL command displays BTEQ settings.



The .SHOW CONTROL command shows all BTEQ session parameters
Example
 [SET] FOLDLINE          = OFF ALL                                              
 [SET] FOOTING           = NULL                                                 
 [SET] FORMAT            = OFF                                                  
 [SET] FORMCHAR          = OFF                                                  
 [SET] HEADING           = NULL                                                 
 [SET] INDICDATA         = OFF                                                  
 [SET] NOTIFY            = OFF                                                  
 [SET] NULL              = ?                                                    
 [SET] OMIT              = OFF ALL                                              
 [SET] PAGEBREAK         = OFF ALL                                              
 [SET] PAGELENGTH        = 55                                                   
 [SET] QUIET             = OFF                                                  
 [SET] RECORDMODE        = OFF                                                  
 [SET] RETCANCEL         = OFF                                                  
 [SET] RETLIMIT          = No Limit                                             
 [SET] RETRY             = ON                                                   
 [SET] RTITLE            = NULL                                                 
 [SET] SECURITY          = NONE                                                 
 [SET] SEPARATOR         = two blanks                                           
 [SET] SESSION CHARSET   = ASCII                                                
 [SET] SESSION SQLFLAG   = NONE                                                 
 [SET] SESSION TRANSACTION = BTET                                               
 [SET] SESSIONS          = 1                                                    
 [SET] SIDETITLES        = OFF for the normal report. 
 [SET] SKIPDOUBLE        = OFF ALL                                             
 [SET] SKIPLINE          = OFF ALL                                             
 [SET] SUPPRESS          = OFF ALL                                             
 [SET] TDP               = l5442                                               
 [SET] TITLEDASHES       = ON for the normal report.                           
       And, it is   ON for results of WITH clause number: 1 2 3 4 5 6 7 8 9.   
 [SET] UNDERLINE         = OFF ALL                                             
 [SET] WIDTH             = 75

1 comment:

  1. Great Job! Really Thanks for your efforts.
    Is this website is only for informational purpose..
    How do I trade on the stock market?
    Sensex
    Sensex

    ReplyDelete