InterSystems SQL Reference
Special Variables
|
|
$HOROLOG $JOB $NAMESPACE $TLEVEL $USERNAME $ZHOROLOG $ZJOB $ZPI $ZTIMESTAMP $ZTIMEZONE $ZVERSION
Variable Name | Abbreviation | Data Type Returned | Use |
---|---|---|---|
$HOROLOG | $H | %String/VARCHAR | Local date and time for the current process |
$JOB | $J | %String/VARCHAR | Job ID of the current process |
$NAMESPACE | none | %String/VARCHAR | Current namespace name |
$TLEVEL | $TL | %Integer/INTEGER | Current transaction nesting level |
$USERNAME | none | %String/VARCHAR | User name for the current process |
$ZHOROLOG | $ZH | %Numeric/NUMERIC(21,6) | Number of elapsed seconds since InterSystems IRIS startup |
$ZJOB | $ZJ | %Integer/INTEGER | Job status for the current process |
$ZPI | none | %Numeric/NUMERIC(21,18) | The numeric constant PI |
$ZTIMESTAMP | $ZTS | %String/VARCHAR | Current date and time in Coordinated Universal Time format |
$ZTIMEZONE | $ZTZ | %Integer/INTEGER | Local time zone offset from GMT |
$ZVERSION | $ZV | %String/VARCHAR | The current version of InterSystems IRIS |