In this section: |
|
You can access any of the following types of functions:
Most Information Builders-supplied functions are available in both WebFOCUS and FOCUS. However, some functions are available only in WebFOCUS. They are:
For details on these functions, see the individual topics.
The following functions manipulate alphanumeric fields or character strings. For details, see Character Functions.
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
The following functions manipulate variable length alphanumeric fields or character strings. For details, see Variable Length Character Functions.
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
The following functions manipulate character strings for DBCS code pages. For details, see Character Functions for DBCS Code Pages.
The following functions manipulate alphanumeric fields or character strings. They are available only in the Maintain language. For details, see Maintain-specific Character Functions.
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.
Available Languages: reporting, MODIFY
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting
Available Languages: MODIFY, Maintain
In this section: |
The following functions manipulate dates. For details see Date Functions.
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
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.
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
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.
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
The following functions manipulate date- time values. For details see Date-Time Functions.
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
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.
The following functions convert fields from one format to another. For details, see Format Conversion Functions.
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
The following functions retrieve WebFOCUS variable or parameter data implicitly from within a Maintain procedure. These functions are available only in WebFOCUS Maintain. For details, see Maintain-specific Light Update Support Functions.
The following functions perform calculations on numeric constants or fields. For details, see Numeric Functions.
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Is an operator that evaluates a number expressed in scientific notation. For information, see Using Expressions in the Creating Reports With WebFOCUS Language manual.
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Languages: reporting
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Script functions integrate JavaScript and VBScripts into your WebFOCUS Maintain applications and perform client-side execution without returning to the WebFOCUS Server. These functions are available only in WebFOCUS Maintain. For details, see Maintain-specific Script Functions.
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.
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Operating Systems: z/OS
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Operating Systems: z/OS
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Operating Systems: z/OS
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting, Maintain
Available Languages: reporting
Available Operating Systems: UNIX
Available Languages: reporting
Available Operating Systems: Windows
Available Languages: reporting
WebFOCUS |