the current date in ddMmmyy or ddMmmyyyy format (depending on the value of the YEARDIGITS run-time configuration option)
|
||
the current date in ddMmmyy hh:mm:ss TZ or ddMmmyyyy
hh:mm:ss TZ format (depending on the value of
the YEARDIGITS run-time configuration option)
|
||
first
, middle
, and last
:{sql}select * from employee.names{/sql}Following are some example references and their resolved values:
{&sys.colname[1]} -----> first {&sys.colname[2..3]} -----> middle last {&sys.colname[*]} -----> first middle last
{eachrow} {&sys.qrow} {&lastname} {&firstname} {&middleinit} {/eachrow}Each row that is output contains the number of the row and the three values that correspond to the other three variable references. The output might look something like the following:
1 Doe John D. 2 Doe Jane R. 3 Doe Sam E.