Progress Function Support

Table 2–2 lists the Progress functions that are supported in ESQL. Any other Progress functions permitted in Progress/SQL are not permitted in ESQL. However, ANSI standard SQL aggregate functions (such as AVG and COUNT) are permitted in Progress/ESQL.

When you reference Progress identifiers (for example, table fields (or columns) or function names) that contain hyphens in Progress/ESQL, precede the hyphen with a backslash (\) to escape the hyphen. If you do not insert a backslash before the hyphen, the SQL preprocessor interprets the hyphen (-) as a minus sign because hyphens are not permitted in ANSI standard SQL identifiers.

Table 2–2: Progress Function Support in ESQL
_SERIAL-NUM
GET-CODEPAGES
PROMSGS
ABSOLUTE
GET-COLLATIONS
PROPATH
ALIAS
IF-THEN-ELSE
PROVERSION
ASC
INDEX
R-INDEX
CAN-DO
INTEGER
RANDOM
CAN-FIND
KEYWORD
RECID
CAPS
KEYWORD-ALL
REPLACE
CHR
LC
RIGHT-TRIM
CONNECTED
LDBNAME
ROUND
CONTAINS
LEFT-TRIM
ROWID
CURRENT-LANGUAGE
LENGTH
SDBNAME
CURRENT-VALUE
LIBRARY
SQRT
DATE
LOG
STRING
DAY
LOOKUP
SUBSTITUTE
DBCODEPAGE
MACHINE-CLASS
SUBSTRING
DBCOLLATION
MATCHES
TIME
DBNAME
MEMBER
TODAY
DBRESTRICTIONS
MONTH
TRIM
DBTYPE
NEXT-VALUE
TRUNCATE
DBVERSION
NUM-ALIASES
WEEKDAY
DECIMAL
NUM-DBS
YEAR
ENCODE
NUM-ENTRIES
ENTRY
OPSYS
ETIME
OS-DRIVES
EXP
OS-GETENV
FILL
PDBNAME


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095