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