A
&ABSOLUTE_VALUE
Used to calculate the absolute value of a number.
&ADDRESS
Used to returns the memory address of a variable.
Used to convert an alphanumeric variable to a DATE type variable.
Used to convert an alphanumeric variable to a numeric variable.
Used to convert an alphanumeric variable to a TIME type variable.
Used to convert an alphanumeric variable to a TIMESTAMP type variable.
&ALPHABETIC
Used to check whether the character string is alphabetic only.
&ALPHANUMERIC
Used to check whether the character string is completely alphanumeric.
&ARC_COSINE
Used to calculate the arc cosine of a number expressed in radians.
&ARC_SINE
Used to calculate the arc sine of a number expressed in radians.
&ARC_TANGENT
Used to calculate the arc tangent of a number expressed in radians.
&ARC_TANGENT_2
Used to calculate the arc tangent of two numbers expressed in radians.
&ARRAY_DIM
Used to return the size of an Adelia array, whether the latter is declared statically of size 1 or 2.
Also gives the size of an array type class attribute of dynamic size (0 if the array is not defined).
B
&BUILD_TIMESTP
Used to return a TIMESTAMP variable on the basis of a date, time and a number of microseconds.
C
&CALCULATE_DATE
Used to calculate a date by adding a number of days, months or years to a given date.
&CALCULATE_DATE6
Used to calculate a six-position date by adding a number of days to a beginning date.
&CALCULATE_DATE8
Used to calculate an eight-position date by adding a number of days to a beginning date.
&CALCULATE_TIME
Used to calculate a time by adding a number of hours, minutes or seconds to a given time.
&CALCULATE_TMS
Used to calculate a timestamp by adding a number of microseconds, seconds, hours, days, months or years to a given timestamp.
&CAPITAL
Used to calculate the value of regular monthly instalments for the depreciation of loan capital over a period.
&CENTER_ADJUST
Used to center a character string.
&CHAR_CONVERSION
Used to convert a hexadecimal value into character form.
&CHECK_OBJECT
Searches for the graphic object whose type and (partially- or fully-qualified) static name are set as parameters.
&CODE_LST
Used to return a return code matching the last operation performed on a given list.
&CONTAINS_SPACE
Used to check whether the character string contains at least one space.
&CONTROL_DATE6
Used to check the validity of the date specified as a parameter.
&CONTROL_DATE8
Used to check the validity of the date specified as a parameter.
&COSINE
Used to calculate the cosine of a number expressed in radians.
D
&DATE_INTERVAL
Used to calculate the number of days between two specific dates with the DATE type format.
&DATE_NUMBER
Used to calculate a date from its absolute number (compared with the year 1).
Used to convert a DATE type variable to an alphanumeric variable.
&DATE_TO_DAY
Used to extract the day from a given date.
&DATE_TO_MONTH
Used to extract the month from a given date.
&DATE_TO_NUM
Used to convert a date (DATE type) into a numeric type in the YYYYMMDD format.
&DATE_TO_YEAR
Used to extract the century and year (on four characters) from a given date.
&DATE6_FORMAT
Used to change the format of a six-position date.
&DATE8_FORMAT
Used to change the format of an eight-position date.
&DATES6_INTERVAL
Used to calculate the interval between two six-position dates.
&DATES8_INTERVAL
Used to calculate the interval between two eight-position dates.
&DAY_WEEK
Used to calculate the number representing the day of the week for a given date.
&DAY_WEEK6
Used to calculate the number representing the day of the week for a six-position date.
&DAY_WEEK8
Used to calculate the number representing the day of the week for an eight-position date.
&DEPRECIATION
Used to calculate the straight-line depreciation of an investment.
E
&EXPONENTIAL
Used to calculate the exponential value of a number.
G
&GET_INDICATOR
After an Adelia SQL read operation, this function retrieves the value of the indicator variable to find out whether or not, for a given column of a given entity, the value read is a NULL value.
&GET_OBJECT
Returns the graphic object variable whose static name is set as a parameter.
H
&HASH
Returns the result when the specified hashing algorithm is applied to the variable passed as a parameter.
&HASH_FILE
Returns the result when the specified hashing algorithm is applied to the content of the file the name of which is passed as a parameter.
&HEXA_CONVERSION
Used to convert a character into hexadecimal form.
&HYP_COSINE
Used to calculate the hyperbolic cosine of a number expressed in radians.
&HYP_SINE
Used to calculate the hyperbolic sine of a number expressed in radians.
&HYP_TANGENT
Used to calculate the hyperbolic tangent of a number expressed in radians.
J
&JULIAN6
Converts a six-position date into Julian calendar format.
&JULIAN8
Converts an eight-position date into Julian calendar format.
&JUSTIFICATION
Used to justify a character string by specifying a left margin, a right margin and the maximum number of blanks that can be inserted between each word.
L
&LEFT_ADJUST
Used to adjust a character string to the left.
&LOGARITHM_10
Used to calculate a number's logarithm (to base 10).
&LOGARITHM_N
Used to calculate a number's natural logarithm.
&LOWER_CASE
Used to convert upper case characters into lower case characters.
M
&MODULO
Used too calculate the modulo between a numerator and its divisor.
N
&NBR_ELT
Used to calculate the number of elements in a list.
Used to convert a numeric variable to an alphanumeric variable.
&NUM_TO_DATE
Used to convert a numeric field containing a date in the CCYYMMDD format into a DATE type variable.
&NUM_TO_TIME
Used to convert a numeric field containing a time in the HHMMSS format into a TIME type variable.
&NUMBER_DATE
Used to calculate the day number for a date compared with the year 1.
&NUMERIC
Used to check whether a character string is entirely numeric.
O
&OBJECT_NAME
Retrieves the static name - or parts of the static name - of the graphic object described by a GRAPHIC_OBJECT variable.
P
&POWER_OF
Used to raise a number to a power specified as a parameter.
R
&RANK_ELT
Used to calculate the rank of the current element in a list whose name is given as a parameter.
&RIGHT_ADJUST
Used to adjust a character string to the right.
S
&SEARCH
Used to search for a character string inside another character string.
&SINE
Used to calculate the sine of a number expressed in radians.
&SPACE_OUT_WORDS
Used to insert or delete a certain number of spaces between each word of a character string.
&SQL_SANITIZE
Used to sanitize the text of a "string"-type parameter used to build a SQL query with the aim of preventing SQL injection.
&STRING_LENGTH
Used to calculate the length of a character string.
&SUBSTRING
Used to extract 'n' bytes from a character string starting from a defined beginning position.
T
&TANGENT
Used to calculate the tangent of a number expressed in radians.
&TIME_INTERVAL
Used to calculate the number of seconds between two given times.
Used to convert a TIME type variable to an alphanumeric variable.
&TIME_TO_HOUR
Used to extract the hours (HH) information from a TIME variable.
&TIME_TO_MINUTE
Used to extract the minutes (MM) information from a TIME variable.
&TIME_TO_NUM
Used to convert a time with the TIME format into a numeric variable in the HHMMSS format.
&TIME_TO_SECOND
Used to extract the seconds (SS) information from a TIME variable.
&TIMESTP_TO_DATE
Used to extract the date information from a TIMESTAMP variable.
&TIMESTP_TO_MSEC
Used to extract the microseconds information from a TIMESTAMP variable.
&TIMESTP_TO_TIME
Used to extract the time information from a TIMESTAMP variable.
&TMS_INTERVAL
Used to calculate the number of units between two specific timestamps.
Used to convert a TIMESTAMP type variable to an alphanumeric variable.
&TRANSFORMATION
Used to transform a character string in accordance with two conversion strings (origin and target).
U
&UPPER_CASE
Used to convert lower case characters into upper case characters.