.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