CONCAT

String

Concatenates two character strings.

CONCATMIXED

String

Concatenates two text or mixed character strings.

CONCATDBCS

String

Concatenates two double-byte character strings.

CYYDATE

Numeric

Translates a date into a pre-4.0 CYYMMDD format. The input is a date.

CYYNUM

Numeric

Translates a number into a pre-4.0 CYYMMDD format. The input is a number in the format of YYYYMMDD.

DATEDAYS

Numeric

Translates a positive integer which represents the number of days since December 31, 0000 into an IEF date value.

DATEJUL

Numeric

Translates a valid Julian date (YYYYDDD) into an IEF date value.

DATENUM

String

Translates a number into an IEF date value. The input format is a number in the format of YYYYMMDD.

DATETEXT

String

Translates a valid character string date into an IEF date value. Input formats are YYYY-MM-DD6 MM/DD/YYYY, DD.MM.YYYY & YYYYNNN.

DATETIMESTAMP

Numeric

Translates the date part of an IEF timestamp value into an IEF date value."

DAY

Numeric

Extracts the day part of an IEF date value.

DAYOFWEEK

String

Calculates the day of the week from an IEF date value.

DAYS

Numeric

Translates an IEF date value to a positive integer which represents the number of days since December 31, 0000.

DAYSTIMESTAMP

Numeric

Translates an IEF timestamp value to a positive integer which represents the number of days since December 31, 0000.

DAYTIMESTAMP

Numeric

Extracts the day part of an IEF timestamp value.

FIND

Numeric

Returns the position of a substring within a given text or mixed string. If the substring is not contained within the string, 0 is returned.

FINDDBCS

Numeric

Returns the position of a substring within a given double-byte string. If the substring is not contained within the string, 0 is returned.

HOUR

Numeric

Extracts the hour part of an IEF time value.

HOURTIMESTAMP

Numeric

Extracts the hour part of an IEF timestamp value.

JULDATE

Numeric

Translates a valid IEF date value into a valid integer Julian date (YYYYDDD).

LENGTH

Numeric

Returns the length of a text or mixed character string.

LENGTHDBCS

Numeric

Returns the length of a double-byte character string.

MICROSECOND

Numeric

Extracts the microsecond part of an IEF timestamp value.

MINUTE

Numeric

Extracts the minute part of an IEF time value.

MINUTETIMESTAMP

Numeric

Extracts the minute part of an IEF timestamp value.

MONTH

Numeric

Extracts the month part of an IEF date value.

MONTHTIMESTAMP

Numeric

Extracts the month part of an IEF timestamp value.

NUMCYY

Numeric

Translates a number in the pre-4.0 CYYMMDD date format into a number in the format of YYYYMMDD.

NUMDATE

Numeric

Translates an IEF date value into a numeric integer which is the date in a numeric format of YYYYMMDD.

NUMTEXT

Numeric

Translates a character string representation of a number into the number.

NUMTIME

Numeric

Translates an IEF time value into a numeric integer which is the time in numeric form: HHMMSS.

SECOND

Numeric

Extracts the second part of an IEF time value.

SECONDTIMESTAMP

Numeric

Extracts the second part of an IEF timestamp value.

SUBSTR

String

Extracts a substring of a string starting at a specified position and containing a specified length.

SUBSTRMIXED

String

Extracts a substring of a text or mixed character string starting at a specified position and containing a specified length.

SUBSTRDBCS

String

Extracts a substring of a double-byte string starting at a specified position and containing a specified length.

TEXTNUM

String

Translates a number into a character string representation of the number.

TIMENUM

Numeric

Translates a number into an IEF time value. The input format is HHMMSS.

TIMESTAMP

Numeric

Translates a valid character string timestamp into an IEF timestamp value. Input formats are YYYY-MM-DD-HH.MM.SS.NNNNNN, YYYY-MM-DD-HH.MM.SS, and YYYY-MM-DD.

TIMETEXT

Numeric

Translates a valid character string time to a time value.

TIMETIMESTAMP

Numeric

Translates the time part of an IEF timestamp value into an IEF time value.

TRIM

String

Trims trailing blanks from a character string.

TRIMMIXED

String

Trims trailing blanks from a mixed character string.

TRIMDBCS

String

Trims trailing blanks from a double-byte character string.

UPPER

String

Returns the uppercase character string of the input character string.

UPPERMIXED

String

Returns the uppercase character string of the input mixed character string.

UPPERDBCS

String

Returns the uppercase character string of the input double-byte character string.

VERIFY

Numeric

Derives the location of a text or mixed character in the input string which is not in the validation string.

VERIFYDBCS

Numeric

Derives the location of a double-byte character in the input string which is not in the validation string.

YEAR

Numeric

Extracts the year part of an IEF date value.

YEARTIMESTAMP

Numeric

Extracts the year part of an IEF timestamp value.