Products Downloads


French version


 

A

&ABSOLUTE_VALUE

Used to calculate the absolute value of a number.

 

&ADDRESS

Used to returns the memory address of a variable.

 

&ALPHA_TO_DATE

Used to convert an alphanumeric variable to a DATE type variable.

 

&ALPHA_TO_NUM

Used to convert an alphanumeric variable to a numeric variable.

 

&ALPHA_TO_TIME

Used to convert an alphanumeric variable to a TIME type variable.

 

&ALPHA_TO_TMSTP

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).

 

↑ Top of page

B

&BUILD_TIMESTP

Used to return a TIMESTAMP variable on the basis of a date, time and a number of microseconds.

 

↑ Top of page

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.

 

↑ Top of page

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).

 

&DATE_TO_ALPHA

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.

 

 

↑ Top of page

E

&EXPONENTIAL

Used to calculate the exponential value of a number.

 

↑ Top of page

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.

 

↑ Top of page

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.

 

↑ Top of page

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.

 

↑ Top of page

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.

 

 

↑ Top of page

M

&MODULO

Used too calculate the modulo between a numerator and its divisor.

 

 

↑ Top of page

N

&NBR_ELT

Used to calculate the number of elements in a list.

 

&NUM_TO_ALPHA

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.

 

↑ Top of page

O

&OBJECT_NAME

Retrieves the static name - or parts of the static name - of the graphic object described by a GRAPHIC_OBJECT variable.

 

↑ Top of page

P

&POWER_OF

Used to raise a number to a power specified as a parameter.

 

↑ Top of page

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.

 

↑ Top of page

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.

 

↑ Top of page

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.

 

&TIME_TO_ALPHA

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.

 

&TMSTP_TO_ALPHA

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).

 

↑ Top of page

U

&UPPER_CASE

Used to convert lower case characters into upper case characters.

 

↑ Top of page

  • Aucune étiquette