In this section: |
You can access any of the following types of functions:
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. This function is available only for WebFOCUS.
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 manipulate alphanumeric fields or character strings. They are available only in the Maintain language. For details, see Maintain-specific Character Functions.
Translates an ASCII or EBCDIC character to the integer value it represents, depending on the operating system.
Translates an integer into the equivalent ASCII or EBCDIC character, depending on the operating system.
Converts the letters in a character string to mixed case.
Measures the length of a character string, including trailing blanks.
Left-justifies a character string within a field.
Converts a character string to lowercase.
Extracts characters from or adds characters to a character string.
Divides a character string into substrings, called tokens.
Converts a character from the native English code page to the running code page.
Overlays a base character string with a substring.
Finds the starting position of a substring within a larger string.
Right-justifies a character string.
Decodes a value from a stack.
Substitutes a substring for another substring in a character string.
Compares two alphanumeric strings using the ASCII or EBCDIC collating sequence.
Compares two alphanumeric strings using the ASCII or EBCDIC collating sequence, but ignoring case differences.
Compares a specified number of characters in two character strings starting at the beginning of the strings using the EBCDIC or ASCII collating sequence.
Extracts a substring based on where it begins and its length in the parent string.
Removes trailing occurrences of a pattern within a character string.
Determines the length of a character string excluding trailing spaces.
Converts a character string to uppercase.
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.
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, Maintain
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.
In this section: |
The following functions manipulate dates and times. They are available only in the Maintain language. For details, see Maintain-specific Date and Time Functions.
Retrieves the current time from the system.
Retrieves the time that the Maintain module was started.
Retrieves the date that the Maintain module was started.
Retrieves the current date from the system.
Retrieves the current date from the system.
Adds a given number of days to a date.
Extracts the day of the month from a date.
Determines the number of days that have elapsed so far in the year up to a given date.
Extracts the month from a date.
Determines the quarter of the year in which a date resides.
Sets a value to a date.
Subtracts a given number of days from a date.
Determines the day of the week for a date.
Extracts the year from a date.
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 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. 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 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
| Information Builders |