11. Report-Writer Expressions and Formats : Reserved Words
 
Share this page                  
Reserved Words
The identifiers in the following table are reserved for use as keywords by Report-Writer. If delimited identifiers have been turned on, you can use reserved words as delimited identifiers for table, view, column, schema, or user names by enclosing them within double quotes ("). Using reserved words in QUEL is not allowed. Follow all rules for using delimited identifiers, as described in the section, Delimited Identifiers. Using reserved words in any other way is likely to produce incorrect results when Report-Writer prints the report.
abs
and
ascii
atan
average
averageu
avg
avgu
break
cnt
cntu
concat
cos
count
countu
cum
cumulative
current_date
current_day
current_time
date
decimal
detail
dow
exp
float
float4
float8
int4
integer
integer1
integer4
interval
left
left_margin
length
line_number
locate
log
lowercase
max
maximum
maximumu
maxu
min
minimum
minimumu
minu
mod
not
null
or
page
page_length
page_number
page_width
position_
numberreport
right
right_margin
run
shift
sin
smallint
sqrt
squeeze
sum
sumu
table
trim
uppercase
w_column
w_name
If you use one of the reserved words in the preceding table as a column name without delimiting it, Report-Writer issues a warning message. It also supersedes the definition of the built‑in function with the column name you specify. All further references to the reserved word relate to the column, not to the Report-Writer function, which could produce unexpected results.
All SQL keywords are also reserved words in Report-Writer. For a complete list of these keywords, see the SQL Reference Guide.