Special Variables
The global variable sybmsg is used by Sybtcl to
store information related to its operation. The variable is an array and
contains the keys described in the following list:
collengthsA list of the column lengths of the columns returned by sybcols.
coltypesA list of the types of the columns returned by sybcols.
dateformatControls formatting of dates. Can be set to a string containing substitution strings, described at the end of this section.
dberrError number generated by the last DB-Library routine.
dberrstrError text associated with
dberr.fixedcharNormally, trailing spaces are trimmed from character data. If set to
yes, trailing spaces are retained.floatprecNumber of decimal places to use for floating-point values. Default is 17.
handleThe handle of the last Sybtcl command.
lineLine number of the SQL command or stored procedure that generated the last message.
maxtextSets maximum amount of data returned by sybnext and sybreadtext commands. Default is 32,768 bytes.
msgnoMessage number from the last Sybase server message.
msgtextMessage text associated with
msgno.nextrowIndicates result of last SQL command. Possible values are described in the next list.
nullvalueString value to return for null results. The default value
defaultwill return 0 for numeric types and a null string for others.oserrOperating system error number associated with the last DB-Library error.
oserrstrError text associated with
oserr.procnameName of stored procedure that generated the last message.
retstatusReturn code of the last stored procedure that was executed.
SeveritySeverity level of the last Sybase server message.
svrnameName of the Sybase server that generated the last message.
The element $sybmsg(nextrow) can take the
following values (which are also returned by the
sybsql command):
FAILA server error has occurred.
NO_MORE_RESULTSThe final set of results has been processed.
NO_MORE_ROWSAll rows from the current result set have been processed, or the SQL command executed successfully but no rows are available.
PENDINGAsynchronous execution of command is still in progress.
REG_ROWAt least one row is available.
numThe last row retrieved was a compute row having compute ID number
num.
The $sybmsg(dateformat) variable, described
earlier, can contain the following format strings:
| Four-digit year (e.g., 1900) |
| Two-digit year (00–99) |
| Two-digit month (1–12) |
| Name of month ( January–December) |
| Abbreviated name of month ( Jan–Dec) |
| Two-digit day (1–31) |
| Two-digit hour (0–23) |
| Two-digit minute (0–59) |
| Two-digit second (0–59) |
| Three-digit millisecond (0–999) |
| Three-digit day of year (0–365) |
| One-digit day of week (1–7, for Monday–Sunday) |