Using Functions


Copyright © 2015 Information Builders

This documentation describes how to use Information Builders-supplied functions to perform complex calculations and manipulate data in procedures. It is intended for application developers and end users.

How This Manual Is Organized

This manual includes the following chapters:




How to Use This Manual

Describes how to use the information in the WebFOCUS Using Functions manual.


Introducing Functions

Introduces functions and explains the different types of available functions.


Accessing and Calling a Function

Describes the considerations for supplying arguments in a function, and explains how to use a function in a command and access functions stored externally.


Character Functions

Describes character functions that manipulate alphanumeric fields and character strings.


Variable Length Character Functions

Describes variable-length character functions which manipulate alphanumeric fields and character strings.


Simplified Character Functions

Describes character functions that have streamlined parameter lists, similar to those used by SQL functions.


Character Functions for DBCS Code Pages

Describes functions that manipulate strings of DBCS and SBCS characters when the configuration uses a DBCS code page.


Maintain-specific Character Functions

Describes Maintain-specific character functions that manipulate alphanumeric fields and character strings.


Data Source and Decoding Functions

Describes data source and decoding functions that search for data source records, retrieve data source records or values, and assign values based on the value of an input field.


Date Functions

Describes date functions that manipulate date values.


Date-Time Functions

Describes date-time functions that manipulate date-time values.


Simplified Date and Date-Time Functions

Describes date and date-time functions that have streamlined parameter lists, similar to those used by SQL functions.


Maintain-specific Date and Time Functions

Describes Maintain-specific date and time functions that manipulate date and time values.


Format Conversion Functions

Describes format conversion functions that convert fields from one format to another.


Maintain-specific Light Update Support Functions

Describes light update support functions that retrieve WebFOCUS parameter or variable data implicitly from within a Maintain procedure.


Numeric Functions

Describes numeric functions that perform calculations on numeric constants and fields.


Maintain-specific Script Functions

Describes script functions that enable you to integrate JavaScript and VBScripts into your WebFOCUS Maintain applications and to perform client-side execution without returning to the WebFOCUS Server.


System Functions

Describes system functions that call the operating system to obtain information about the operating environment or to use a system service.


Creating a Subroutine

Describes how to create custom subroutines in addition to the functions provided by Information Builders.

Documentation Conventions

The following table describes the documentation conventions that are used in this manual.





this typeface

Denotes syntax that you must enter exactly as shown.

this typeface

Represents a placeholder (or variable) in syntax for a value that you or the system must supply.


Indicates a default setting.

this typeface

Represents a placeholder (or variable), a cross-reference, or an important term. It may also indicate a button, menu item, or dialog box option that you can click or select.

Key + Key

Indicates keys that you must press simultaneously.

{  }

Indicates two or three choices. Type one of them, not the braces.

[  ]

Indicates a group of optional parameters. None are required, but you may select one of them. Type only the parameter in the brackets, not the brackets.


Separates mutually exclusive choices in syntax. Type one of them, not the symbol.


Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...).


Indicates that there are (or could be) intervening or additional commands.

Related Publications

Visit our Technical Content Library at You can also contact the Publications Order Department at (800) 969-4636.

Customer Support

Do you have questions about this product?

Join the Focal Point community. Focal Point is our online developer center and more than a message board. It is an interactive network of more than 3,000 developers from almost every profession and industry, collaborating on solutions and sharing tips and techniques. Access Focal Point at

You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our website, It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of also provides usage techniques, diagnostic tips, and answers to frequently asked questions.

Call Information Builders Customer Support Services (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your questions. Information Builders consultants can also give you general guidance regarding product capabilities. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.

To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.

Information You Should Have

To help our consultants answer your questions effectively, be prepared to provide the following information when you call:

User Feedback

In an effort to produce effective documentation, the Technical Content Management staff welcomes your opinions regarding this document. You can contact us through our website

Thank you, in advance, for your comments.

Information Builders Consulting and Training

Interested in training? Information Builders Education Department offers a wide variety of training courses for this and other Information Builders products.

For information on course descriptions, locations, and dates, or to register for classes, visit our website ( or call (800) 969-INFO to speak to an Education Representative.