You can access any of the following types of functions:
The following functions perform calculations based on multiple rows in the internal matrix. For details, see Simplified Analytic Functions.
Calculates a simple moving average column.
Calculates a single exponential smoothing column.
Calculates a double exponential smoothing column.
Calculates a triple exponential smoothing column.
Calculates a linear regression column.
Creates rolling calculations.
Retrieves prior or subsequent fields.
Calculates the difference between a value in the current row and a prior row within a partition.
Calculates the percent difference between a value in the current row and a prior row within a partition.
Retrieves a prior value within a partition.
Calculate the average over a group of rows within a partition.
Calculate the minimum over a group of rows within a partition.
Calculate the maximum over a group of rows within a partition.
Calculate the sum over a group of rows within a partition.
The following functions manipulate alphanumeric fields or character strings and have simplified parameter lists. For details, see Simplified Character Functions.
Returns the length, in characters, of a string.
Converts a number to a character string of the specified length.
Extracts a token (substring) based on a token number and a string listing acceptable delimiter characters.
Capitalizes the first letter of every word in a string and makes all other letters lowercase, where a word starts at the beginning of the string, after a blank space, or after a special character.
retrieves the last field value that is neither blank nor missing. If all previous values are either blank or missing, returns a missing value.
Translates a string to lowercase.
Left-pads a string with a given character.
Removes all blanks from the left end of a string.
Returns a pattern that represents the structure of the source string.
Returns the first position (in characters) of a substring in a source string.
Matches a string to a regular expression and returns true (1) or false (0).
Right-pads a string with a given character.
Removes all blanks from the right end of a string.
Extracts a substring from a source string.
Extracts a token (substring) based on a token number and a delimiter string.
Removes all occurrences of a single character from either the beginning or end of a string, or both.
Translates a string to uppercase.
The following functions manipulate alphanumeric fields or character strings. For details, see Character Functions.
Measures the length of a character string within a field, excluding trailing blanks.
Distinguishes between a blank and a zero in Dialogue Manager.
Evaluates an individual bit within a character string to determine whether it is on or off.
Evaluates a string of bits within a character string and returns its value.
Translates a character to its corresponding ASCII or EBCDIC decimal value.
Checks a character string for incorrect characters or character types.
Translates a character within a character string to another character based on its decimal value.
Centers a character string within a field.
Extracts characters from or adds characters to a character string.
Divides a character string into substrings, called tokens, where a specific character, called a delimiter, occurs in the string.
Converts the letters in a character string to mixed case.
Converts the letters in a character string to mixed case.
Converts the letters in a character string to mixed case.
Left-justifies a character string within a field.
Converts alphanumeric text to lowercase.
Overlays a base character string with a substring.
Divides a line of text into smaller lines by marking them with a delimiter.
Finds the starting position of a substring within a larger string.
Reverses the characters in a character string.
Right-justifies a character string.
Searches for a character string phonetically without regard to spelling.
Takes an alphanumeric string or a numeric value with two decimal places and spells it out with dollars and cents.
Reduces multiple contiguous spaces within a character string to a single space.
Removes all occurrences of a specific character from a string.
Replaces all occurrences of a specific character string.
Extracts a substring based on where it begins and its length in the parent string.
Removes leading and/or trailing occurrences of a pattern within a character string.
Converts a character string to uppercase.
The following functions manipulate variable length alphanumeric fields or character strings. For details, see Variable Length Character Functions.
Returns the actual length of an AnV field or the size of an An field.
Converts alphanumeric text to lowercase in an AnV field.
Finds the starting position of a substring in an AnV field.
Extracts a substring based on where it begins and its length in the parent string in an AnV field.
Removes leading and/or trailing occurrences of a pattern within a character string in an AnV field.
Converts a character string to uppercase in an AnV field.
The following functions manipulate character strings for DBCS code pages. For details, see Character Functions for DBCS Code Pages.
Translates a single-byte or double-byte character to another character.
Extracts characters from or adds characters to a string.
Removes a single-byte or double-byte character from a string.
Extracts a substring based on its length and position in the source string.
Converts Japanese specific characters.
The following functions search for data source records, retrieve data source records or values, and assign values. For details, see Data Source and Decoding Functions.
Returns the value of the first non-missing argument.
Inserts an SQL expression into the SQL generated for a request against a relational data source.
Compares values in a source file to values in a target file, or if the source file is a relational data source, to values retrieved by a subquery.
Computes an MD5 hash check value of its input parameter.
Computes hash sum of its input parameter.
Retrieves a data value from a lookup data source.
Assigns values based on the coded value of an input field.
Determines if an incoming data value is in an indexed FOCUS data source field.
Retrieves the preceding value for a field.
Retrieves a data value from a cross-referenced FOCUS data source in a MODIFY request.
Available Languages: MODIFY
Returns a missing value when its parameters have equal values.
The following functions manipulate date and date- time values. For details see Simplified Date and Date-Time Functions.
Returns the current date.
Returns the current date and time.
Returns the current time.
Returns a new date after adding the specified number of a supported component
Returns the number of given component boundaries between the two dates.
Extracts time components from a date-time value.
Returns a component value in integer format.
Returns the first date within a period
In this section: |
The following functions manipulate dates. For details see Date Functions.
Adds a unit to or subtracts a unit from a date format.
Converts date formats.
Returns the difference between two dates in units.
Moves a date to a significant point on the calendar.
Formats dates in international formats.
Extracts a component from a date field and returns it in numeric format.
Returns the financial year, also known as the fiscal year, corresponding to a given calendar date based on the financial year starting date and the financial year numbering convention.
Returns the financial quarter corresponding to a given calendar date based on the financial year starting date and the financial year numbering convention.
Returns a financial date containing both the financial year and quarter that corresponds to a given calendar date.
Extracts components from a date-time value and moves them to a target date-time field with all other components of the target field preserved.
Retrieves the current date from the system.
Adds or subtracts months from dates that are in year-month format.
Adds or subtracts days from dates that are in year-month-day format.
Rearranges the year, month, and day portions of alphanumeric dates, and converts dates between long and short date formats.
Convert dates to the corresponding number of days elapsed since December 31, 1899.
DADMY converts dates in day-month-year format.
DADYM converts dates in day-year-month format.
DAMDY converts dates in month-day-year format.
DAMYD converts dates in month-year-day format.
DAYDM converts dates in year-day-month format.
DAYMD converts dates in year-month-day format.
Calculate the difference between two dates.
Find the day of the week that corresponds to a date.
Converts the number of days elapsed since December 31, 1899 to the corresponding date.
DTDMY converts numbers to day-month-year dates.
DTDYM converts numbers to day-year-month dates.
DTMDY converts numbers to month-day-year dates.
DTMYD converts numbers to month-year-day dates.
DTYDM converts numbers to year-day-month dates.
DTYMD converts numbers to year-month-day dates.
Converts dates in Julian format to year-month-day format.
Converts dates from year-month-day format to Julian (year-day format).
Calculates the number of months that elapse between two dates. The dates must be in year-month format.
The following functions manipulate date-time values. For details see Date-Time Functions.
Increments a date-time field by a given number of units.
Converts a date-time field to a character string.
Extracts the date portion of a date-time field, converts it to a date format, and returns the result in the format YYMD.
Calculates the number of units between two date-time values.
Converts a date field to a date-time field. The time portion is set to midnight.
Extracts components from a date-time value and moves them to a target date-time field with all other components set to zero.
Stores the current date and time in a date-time field.
Extracts components from a date-time value and moves them to a target date-time field with all other components of the target field preserved.
Retrieves the current time from the system.
Converts an alphanumeric string to a date-time value.
Changes the time portion of a date-time field to midnight (all zeros).
Extracts a specified component from a date-time field and returns it in alphanumeric format.
Extracts a specified component from a date-time field and returns it in numeric format.
Inserts the numeric value of a specified component into a date-time field.
Converts the time portion of a date-time field to the number of milliseconds or microseconds.
Converts a time to a timestamp.
Accepts a date and time in one of five formats and converts the value to native OpenVMS 64-bit DEC Date/Time format.
The following functions convert fields from one format to another, using streamlined parameter lists. For details, see Simplified Conversion Functions.
Returns a character based on a numeric code.
Converts a numeric value to an alphanumeric value that represents the number in an abbreviated format, using the characters K, M, B, and T to represent the abbreviation.
Returns a non-printable control character.
Converts a numeric, date, or date-time value to a character string.
Returns the hexadecimal view of an input value.
Returns a phonetic key.
The following functions convert fields from one format to another. For details, see Format Conversion Functions.
Converts a number in alphanumeric format to double-precision format.
Converts an alphanumeric field that contains numeric characters to numeric format or converts a numeric field to alphanumeric format.
Converts a field to alphanumeric format.
Converts a number in a numeric format to alphanumeric format.
Obtains the ASCII or EBCDIC character equivalent of a decimal integer value.
Converts a large binary integer in a non-FOCUS data source to double-precision format.
Converts a large binary integer in a non-FOCUS data source to packed-decimal format.
Converts a number in numeric format to zoned format.
Writes a packed number of variable length to an extract file.
Converts a packed decimal number from numeric format to alphanumeric format.
Converts a Microsoft SQL Server or Sybase TIMESTAMP column (which contains an incremented counter) to packed decimal.
Converts characters in alphanumeric field values to hexadecimal representation.
Stores a packed number with up to 31 significant digits in an alphanumeric field, retaining decimal data.
The following functions perform calculations on numeric constants or fields, using streamlined parameter lists. For details, see Simplified Numeric Functions
Returns the smallest integer value greater than or equal to a value.
Raises e to a power.
Returns the largest integer value less than or equal to a value.
Calculates the remainder from a division.
Raises a value to a power.
The following functions perform calculations on numeric constants or fields. For details, see Numeric Functions
Returns the absolute value of a number.
Distinguishes between a blank and a zero in Dialogue Manager.
Produces a horizontal bar chart.
Validates the data in a field described as packed format.
Calculate the remainder from a division.
Raises the number "e" to a specified power.
Is an operator that evaluates a number expressed in scientific notation. For information, see Using Expressions in the Creating Reports manual.
Returns the FOR value associated with each row in an FML report.
Returns a string containing the complete tag list for each row in an FML request.
Retrieves the tag value associated with each row in an FML request.
Returns the caption value for each row in an FML hierarchy request.
Returns the integer component of a number.
Returns the natural logarithm of a number.
Return the maximum or minimum value, respectively, from a list of values.
Calculates the modified internal rate of return for a series of periodic cash flows.
Perform calculations on a standard normal distribution curve.
Generate reproducible random numbers.
Generate random numbers.
Calculates the square root of a number.
Calculates the internal rate of return for a series of cash flows that can be periodic or non-periodic.
The following functions perform statistical functions. For details, see Simplified Statistical Functions.
Calculates the degree of correlation between two independent sets of data.
Partitions observations into clusters based on the nearest mean value.
Calculates a linear regression column based on multiple fields.
Calculates the standard deviation in a set of data values.
The following functions call the operating system to obtain information about the operating environment or to use a system service, using streamlined parameter lists. For details, see Simplified System Functions
Inserts a custom message in the EDAPRINT log file.
The following functions call the operating system to obtain information about the operating environment or to use a system service. For details, see System Functions
Closes a file and frees the memory used to store information about open files.
Retrieves an Information Builders error message.
Determines if a specific member of a partitioned data set (PDS) exists in batch processing.
Available Operating Systems: z/OS
Determines if a specific member of a partitioned data set (PDS) exists, and if it does, returns the PDS name.
Available Operating Systems: z/OS
Retrieves the ID of the connected user.
Transfers a FOCUS DYNAM command to the DYNAM command processor.
Available Operating Systems: z/OS
Writes a character string as a record in a sequential file. Opens the file if it is closed.
Suspends execution for a specified number of seconds.
Retrieves the value of a z/OS system variable.
Available Operating Systems: z/OS
Available Languages: reporting