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