Bteq: Displays all the BTEQ control command options currently configured

.logon userid/tdpid

.password ****

.show controls 

Example Output of show control command:

BTEQ -- Enter your SQL request or BTEQ command:

.show controls

 .show controls

 Maximum Instruction Bytes           = 1048500

 Maximum Record Bytes                = 1024000

 Maximum Request Buffer Bytes        = 7340032

 Maximum Response Buffer Bytes       = 16775168

 Maximum Packed Records              = 64000

 Activity Count Bytes                = 8

 Maximum Sessions                    = 200

 Maximum Repeat Factor               = 2147483647

 Maximum String Length               = 254

 Maximum Report Columns              = 65535

 Maximum WITH Clauses for a Report   = 10

 Maximum Report Title Lines          = 10

 Maximum Report Page Lines           = 2147483647

 Minimum Report Width                = 20

 Maximum Report Width                = 1048575 

 Maximum Notify MSG Text Bytes       = 254

 Maximum Bytes Saved for SUPPRESS,

 PAGEBREAK, SKIPLINE, UNDERLINE,

 and SKIPDOUBLE Commands, and for

 &n Substitutions                    = 256 

 Client Platform Byte Order          = LITTLE ENDIAN 

 EXPORT  RESET

 IMPORT  RESET

 LOGMECH                 = LDAP

 LOGON   dbc/userid

 MESSAGEOUT RESET

 REPEAT                  = 1

 RUN

 [SET] AUTOKEYRETRIEVE   = OFF

 [SET] BRANCHMSG         = VERBOSE

 [SET] DECIMALDIGITS     = 0 (SPB DEFAULT)

 [SET] ECHOREQ           = ON

 [SET] ENCRYPTION        = OFF

 [SET] ERRORLEVEL        = ON

 [SET] ERRORONDBSWARNING = OFF

 [SET] ERROROUT          = STDERR

 [SET] EXITONDELAY       = OFF

 [SET] FOLDLINE          = OFF ALL

 [SET] FOOTING           = NULL

 [SET] FORMAT            = OFF

 [SET] FORMCHAR          = OFF

 [SET] FULLYEAR          = OFF

 [SET] HEADING           = NULL

 [SET] INDICATORMODE (alias INDICDATA) = OFF

 [SET] LARGEDATAMODE     = OFF

 [SET] LOGONPROMPT       = ON

 [SET] MAXERROR          = OFF

 [SET] NOTIFY            = OFF

 [SET] NULL              = ?

 [SET] OMIT              = OFF ALL

 [SET] PACK              = 0

 [SET] PAGEBREAK         = OFF ALL

 [SET] PAGELENGTH        = 55

 [SET] PREPAREMODE       = OFF

 [SET] QUIET             = OFF

 [SET] RECORDLENGTH      = Import/Export: MAX64  Stdout: MAX1MB

 [SET] RECORDMODE        = OFF

 [SET] REPEATSTOP        = OFF

 [SET] REPORTALIGN       = COMPATIBLE

 [SET] RETCANCEL         = OFF

 [SET] RETLIMIT          = Rows: No Limit  Columns: 100

 [SET] RETRY             = ON

 [SET] RTITLE            = NULL

 [SET] SEPARATOR         = two spaces

 [SET] SESSION CHARSET        = ASCII

       import/export encoding = ASCII

       stdin/stdout encoding  = ASCII

 [SET] SESSION RESPBUFLEN  = 8192

 [SET] SESSION SQLFLAG   = NONE

 [SET] SESSION TRANSACTION = BTET

 [SET] SESSION TWORESPBUFS = ON

 [SET] SESSIONS          = 1

 [SET] SIDETITLES        = OFF for the normal report.

       And, it is   ON for results of WITH clause number: 1 2 3 4 5 6 7 8 9 10.

 [SET] SKIPDOUBLE        = OFF ALL

 [SET] SKIPLINE          = OFF ALL

 [SET] STATEMENTINDEPENDENCE = OFF

 [SET] SUPPRESS          = OFF ALL

 [SET] TDP               = dbc

 [SET] TIMEMSG           = DEFAULT

 [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 10.

 [SET] TMSMMSG           = OFF

 [SET] TRAILINGLINES     = DEFAULT

 [SET] TRANSLATECTRLSTOSPACES = ON

 [SET] TRIMTRAILINGSPACES = ON

 [SET] UNDERLINE         = OFF ALL

 [SET] WIDTH             = 75

Comments