Pathmaker Reference Manual

Server Constructs
Macro Language Construct Variables
C–4 067869 Tandem Computers Incorporated
#Column-Is-INTERVAL
The SQL data type of the current column is INTERVAL. (When the value of this
construct is "Y", the specific INTERVAL format can be obtained from the construct
#Column-Start-End-Date-Time.) There must be a current column.
Values: Y, N
#Column-Is-Nullable
The current column is a nullable item. There must be a current column.
Values: Y, N
#Column-Is-SYSKEY
The current column is the system-supplied SYSKEY column of the table. (Always "N"
for all data columns, and for all columns of view tables.) There must be a current
column.
Values: Y, N
#Column-Is-VarChar
The current column is a VarChar item. There must be a current column.
Values: Y, N
#Column-Length
Length (in characters) of current column When column is VarChar and/or nullable,
length is of the data part only; it is the maximum possible length for VarChar data.
Values: Integer
#Column-Name
The name of the current column (lowercase for C). There must be a current column.
Values: String, up to 19 characters
#Column-Start-End-Date-Time
The start and end date-time values for a column with DATETIME or INTERVAL type.
There must be a current column and either #Column-Is-DATETIME = "Y" or
#Column-Is-INTERVAL = "Y". .
Values: YEAR, MONTH, YEAR TO MONTH, and so on. (That is, all legal start and
end date-time values as they appear in SQL syntax).
#Compiler-Directive-Line
Text of the current compiler directive.
Values: String, up to 50 characters