• About Release 7708/82
  • Server New Features
    • Launch PDF file
    • Server Enhancements
      • New Dependencies Analysis Column
      • Specifying Connection for Formatted File Targets
      • Redesign of Connect to Data Page
      • Configuring Geographic Information
      • Linking to Your WebFOCUS Client Repository
      • Upload Support for JSON
      • Automatic Scrolling Of the Business View Pane When Dragging and Dropping
      • Adding Captions for Check List Values
      • Using a LIKE Relation With a Text Box Filter
      • Comparing Values to a Lookup File
      • Converting a Filter Value List to a Variable Expression
      • Storing Server Log Files in a User-Specified Location
      • Downloading a Deferred Jobs Report
      • Applications Page Redesign
      • Bubble Help for Guiding the User to the Next Step
      • Modern Design of Server Web Console
      • Left-Click Menu on the Web Console
      • edastart Command Option for Updating Connection Attributes
      • Turning a Configured Server Into a Docker Container
      • Setting the Maximum Width of a Trace Line
      • Reporting Server on z/OS 64-Bit Version
      • Debugging a Dialogue Manager Procedure
      • Kerberos Support for JDBC-Based Data Sources
      • Git Integration With the WebFOCUS Reporting Server
    • Adapter Enhancements
      • SQL Adapters
      • OLAP Adapters
      • ERP Adapters
      • Procedures Adapters
      • Sequential and Indexed Adapters
      • Statistics Adapters
      • XML Adapters
    • DataMigrator Enhancements
      • Adapters
      • Data Management Console
      • Data and Process Flows
      • Data Profiling
      • Reporting
    • Resource Analyzer and Resource Governor Enhancements
      • Monitoring at the Data Service Level
    • Reporting Language Enhancements
      • New Punctuation Option for Numbers Using SET CDN
      • Two-Part Names Support in ? DEFINE
      • Stacking Duplicate Columns in Multi-Verb Requests Based on AS Names
      • Enhancements to Error Messages
      • DTIME: Extracting Time Components From a Date-Time Value
      • EDAPRINT: Inserting a Custom Message in the EDAPRINT Log File
      • Using FORECAST in a COMPUTE Command
      • PATTERNS: Returning a Pattern That Represents the Structure of the Input String
      • Simplified Statistical Functions
      • Displaying a Caret Symbol (<) in Heading Objects
      • Displaying Syntax Components in Heading Objects
      • Representing a Null String
      • Enhancements to the BYDISPLAY Parameter
      • Enhancement to SET COUNTWIDTH
      • Change to Default Value for SET MISSINGTEST
      • Setting MISSING ON Behavior for DEFINE and COMPUTE
      • Enhancement to the SUMPREFIX Parameter
      • Enhancements to Sort Performance
      • STRING Data Type
      • Accordion By Row Enhanced Interface
      • OpenType Fonts Embedded in PDF Output Files
  • Server Release Notes Release 7708
    • Launch PDF file
    • Adapter Notes
    • Browser Support
    • Db2 Extender: Connects to First Client Node
    • Dropped Support: Adapter Releases
    • Dropped Support: Operating System Releases
    • HTML5 Charts: Displaying Multiple HTML5 Charts in One -HTMLFORM
    • MDI: Name Length Limit
    • NLS: Change NLSCTRL default from OFF to ON
    • Packed Fields: Decimal Precision
    • z/OS 64-bit: Transition to 64-bit Server
    • Further Information
• Server Installation
  • Launch PDF file
  • Introduction to Installation
    • Versions
    • What to Read After You Install
  • Installation for Windows
    • Information You Need Prior to Installation on Windows
    • Windows Installation Requirements
    • Installation and Configuration Directories on Windows
    • Installation Methods
    • Accessing the Software
    • Installing a Server
    • Verifying the Windows Server Installation
    • Starting and Using a Server or Data Management Console
    • Security Providers on Windows
    • Additional Installation Options
    • Generating a Trace on Windows
    • Third-Party Software and Licenses on Windows
    • General Information for a Windows Installation
    • Troubleshooting for Windows
  • Installation for UNIX
    • Information You Need Prior to Installation on UNIX
    • UNIX Installation Requirements
    • Installation and Configuration Directories on UNIX
    • Downloading the Server Installation Software for UNIX
    • Running Isetup to Install the Server Software
    • Installing Using rpm
    • Configuring an Additional Instance of the Server
    • Refreshing or Upgrading an Installation
    • Installing and Configuring Silently
    • Verifying the UNIX Server Installation
    • Security Providers on UNIX
    • Starting and Using a Server
    • Generating a Trace on UNIX
    • Third-Party Software and Licenses on UNIX
    • General Information for a UNIX Installation
    • Troubleshooting for UNIX
  • Installation for z/OS
    • Information You Need Prior to Installation on z/OS
    • zOS Installation Requirements
    • Installation for HFS and PDS
    • HFS Deployment
    • PDS Deployment
  • Installation for IBM i
    • Information You Need Prior to Installation on IBM i
    • IBM i Installation Requirements
    • Installation and Configuration Directories on IBM i
    • Creating User IDs on IBM i
    • Downloading the Server Installation Software for IBM i
    • Copying the Installation Library From DVD
    • Running ISETUP to Install the Server Software
    • Verifying the IBM i Server Installation
    • Security Providers on IBM i
    • Starting and Using the IBM i Server
    • CL and CMD Programs
    • General Information for an IBM i Installation
    • Generating a Trace on IBM i
    • Third-Party Software and Licenses on IBM i
    • Troubleshooting for IBM i
  • Installation for OpenVMS
    • Information You Need Prior to Installation on OpenVMS
    • OpenVMS Installation Requirements
    • Installation and Configuration Directories on OpenVMS
    • Creating User IDs on OpenVMS
    • Accessing the Installation Software
    • Running the ISETUP Procedure to Install the Server
    • Verifying the OpenVMS Server Installation
    • Security Providers on OpenVMS
    • Starting and Using the OpenVMS Server
    • Generating a Trace on OpenVMS
    • Third-Party Software and Licenses on OpenVMS
    • General Information for an OpenVMS Installation
    • Troubleshooting for OpenVMS
  • Information Builders and Third-Party Licenses
    • Information Builders License
    • OpenFlex SDK License
    • Zip Archiver License
• Administration
  • Adapter Administration
    • Launch PDF file
    • Introduction to Adapters
      • Processing Requests
      • Functions of an Adapter
      • Data Management
      • Metadata Services With SQLENGINE SET
      • Additional Master File Attributes
      • Optimization Settings
    • Using the Adapter for 1010data
      • Configuring the Adapter for 1010data
      • Managing 1010data Metadata
      • Customizing the 1010data Environment
      • 1010data Optimization Settings
    • Using the Adapter for Adabas
      • Preparing the Adabas Environment
      • Configuring the Adapter for Adabas
      • Adabas Overview
      • Managing Adabas Metadata
      • Overview of Master and Access Files
      • Master Files for Adabas
      • Access Files for Adabas
      • Mapping Adabas Descriptors
      • Mapping Adabas Files With Variable-Length Records and Repeating Fields
      • Using the GROUP Attribute to Cross-Reference Files
      • Platform-Specific Functionality
      • Customizing the Adabas Environment
      • Adabas Reporting Considerations
      • Adabas Writing Considerations
      • Adapter Navigation
      • Entry Segment Retrieval of Adabas Records
      • Descendant Periodic Groups and Multi-Value Fields
      • Descendant Adabas Records
    • Using the Adapter for Adabas Stored Procedures
      • Preparing the Adabas Stored Procedures Environment
      • Configuring the Adapter for Adabas Stored Procedures
      • Managing Adabas Stored Procedure Metadata
      • Invoking an Adabas Stored Procedure
    • Using the Adapter for Alchemy Sentiment Analysis
      • Alchemy Sentiment Analysis Adapter Overview
      • Configuring the Alchemy Sentiment Analysis Adapter
      • Creating Metadata and Sample Reports for the Alchemy Adapter
      • Alchemy Sentiment Analysis Adapter Examples
    • Using the Adapter for Amazon Athena
      • Introducing the Adapter for Amazon Athena
      • Preparing the Amazon Athena Environment
      • Configuring the Adapter for Amazon Athena
      • Creating Synonyms With Amazon Athena
      • Limitations
    • Using the Adapter for Amazon Redshift
      • Introducing the Adapter for Amazon Redshift
      • Preparing the Amazon Redshift ODBC Environment
      • Configuring the Adapter for Amazon Redshift
      • Creating Synonyms With Amazon Redshift
      • Using Direct Pass-through With Amazon Redshift
    • Using the Adapter for Apache Drill
      • Preparing the Apache Drill Environment
      • Configuring the Adapter for Apache Drill
      • Creating Synonyms With Apache Drill
    • Using the Adapter for Apache Hive to Access Data Managed by Hadoop
      • Introducing the Adapter for Apache Hive
      • Preparing the Apache Hive Environment
      • Configuring the Adapter for Hadoop/Hive
      • Creating Synonyms With Apache Hive
      • Using Direct Pass-through With Apache Hive
      • Loading Data Using DataMigrator
    • Using the Adapter for Apache Phoenix to Access HBase
      • Preparing the Apache Phoenix Environment
      • Configuring the Adapter for Apache Phoenix
      • Creating Synonyms With Apache Phoenix
    • Using the Adapter for Apache Spark
      • Introducing the Adapter for Apache Spark
      • Preparing the Apache Spark Environment
      • Configuring the Adapter for Apache Spark
      • Creating Synonyms With Apache Spark
      • Using Direct Pass-through With Apache Spark
      • Loading Data into Apache Spark Using DataMigrator
    • Using the Adapter for Axiom EPM
      • Preparing the Axiom EPM Environment
      • Configuring the Adapter for Axiom EPM
      • Managing Axiom EPM Metadata
      • Managing Connections to Axiom EPM
      • Using Administrative Utilities
    • Using the Adapter for C9 INC
      • Preparing the C9 INC Environment
      • Configuring the Adapter for C9 INC
      • Managing C9 INC Metadata
      • Customizing the C9 INC Environment
    • Using the Adapter for Caché
      • Preparing the Caché Environment (ODBC)
      • Preparing the Caché Environment (JDBC)
      • Configuring the Adapter for Caché
      • Managing Caché Metadata
      • Customizing the Caché Environment
      • Caché Optimization Settings
    • Using the Adapter for CICS Transactions
      • Preparing the CICS Environment
      • CICS Transactions Adapter Supported Platforms and Release Information
      • CICS and VTAM Configuration
      • Configuring the Adapter for CICS Transactions
      • Managing CICS Transaction Metadata
      • Invoking a CICS Transaction
      • Running a TPG/SPG/AAS Transaction
    • Using the Adapter for Cloudera Impala to Access Data Managed by Hadoop
      • Introducing the Adapter for Cloudera Impala
      • Preparing the Cloudera Impala Environment
      • Configuring the Adapter for Cloudera Impala
      • Creating Synonyms With Cloudera Impala
      • Using Direct Pass-through With Cloudera Impala
      • Loading Data Using DataMigrator
    • Using the Adapters for C-ISAM and ISAM
      • Preparing the Informix C-ISAM Environment
      • Configuring the C-ISAM and ISAM Adapters
      • Managing C-ISAM Metadata
      • Maintaining C-ISAM Data Sources Using SQL Commands
      • Using a Secondary Index in C-ISAM and ISAM Files
    • Using the Adapter for DATACOM
      • Preparing the DATACOM Environment
      • Configuring the Adapter for DATACOM
      • DATACOM Overview and Mapping Considerations
      • Managing DATACOM Metadata
      • Master Files for DATACOM
      • Access Files for DATACOM
      • Describing Multi-File Structures for DATACOM
      • Data Retrieval Logic for DATACOM
    • Using the Adapter for Db2
      • Preparing the Db2 Environment
      • Configuring the Adapter for Db2
      • Managing Db2 Metadata
      • Reporting Against a Db2 Stored Procedure
      • Customizing the Db2 Environment
      • Db2 Optimization Settings
      • Using Db2 Cube Views
      • Calling a Db2 Stored Procedure Using SQL Passthru
    • Using the Adapter for DB Heritage Files
      • Preparing the DB Heritage Files Environment
      • Configuring the Adapter for DB Heritage Files
      • Managing DB Heritage Files Metadata
      • DB Heritage Standard Master File Attributes
      • Redefining a Field in a DB Heritage Files Data Source
      • Extra-Large Record Length Support With DB Heritage Files
      • Describing Multiple Record Types in DB Heritage Files
      • Combining Multiply-Occurring Fields and Multiple Record Types in DB Heritage Files
      • Multi-Format Logical Files
      • DB Heritage Files Record Selection Efficiencies
    • Using the Adapter for Esri ArcGIS
      • Creating an ESRI ArcGIS Online Application
      • Configuring the Adapter for ESRI ArcGIS
      • Creating Metadata and Sample Reports for the Adapter for ESRI ArcGIS Using Premium API Calls
      • Sample Metadata and Reports
    • Using the Adapter for Essbase
      • Preparing the Essbase Environment
      • Configuring the Adapter for Essbase
      • Managing Essbase Metadata
      • Customizing the Essbase Environment
      • Essbase Reporting With WebFOCUS
    • Using the Adapter for EXASol
      • Introducing the Adapter for EXASol
      • Preparing the EXASol ODBC Environment
      • Configuring the Adapter for EXASol
      • Creating Synonyms With EXASol
      • Using Direct Pass-through With EXASol
    • Using the Adapter for Excel
      • Configuring the Adapter for Excel
      • Managing Excel Metadata
      • Customizing the Excel Environment
      • Excel Optimization Settings
    • Using the Adapter for Excel (via Direct Retrieval)
      • Configuring the Adapter for Excel (via Direct Retrieval)
      • Managing Metadata for Excel (via Direct Retrieval)
      • Changing Adapter Settings
    • Using the Adapter for Facebook
      • Facebook Adapter Overview
      • Creating a Facebook Application
      • Configuring the Facebook Adapter
      • Creating Metadata and Sample Reports for the Facebook Adapter
      • Facebook Adapter Examples
    • Using the Adapters for Flat and Delimited Flat Files
      • Preparing the Flat and Delimited File Environment
      • Configuring the Adapters for Flat and Delimited Flat Files
      • Managing Metadata for Flat and Delimited Flat Files
    • Using the Adapter for Google Analytics
      • Google Analytics Adapter Overview
      • Creating a Google Project
      • Obtaining the Web Profile ID
      • Configuring the Google Analytics Adapter
      • Creating Metadata for the Google Analytics Adapter
    • Using the Adapter for Google BigQuery
      • Google BigQuery Adapter Overview
      • Creating a Google BigQuery Project
      • Configuring the Google BigQuery Adapter
      • Creating Metadata for the Google BigQuery Adapter
    • Using the Adapter for Greenplum
      • Configuring the Adapter for Greenplum
      • Managing Greenplum Metadata
    • Using the Adapter for HP Vertica
      • Preparing the HP Vertica Environment
      • Configuring the Adapter for HP Vertica
      • Managing HP Vertica Metadata
      • Customizing the HP Vertica Environment
      • HP Vertica Optimization Settings
    • Using the Adapter for Hyperledger Fabric
      • Preparing the Hyperledger Fabric Environment
      • Configuring the Adapter for Hyperledger Fabric
      • Managing Hyperledger Fabric Metadata
    • Using the Adapter for Hyperstage
      • Preparing the Hyperstage Environment
      • Configuring the Adapter for Hyperstage
      • Managing Hyperstage Metadata
      • Customizing the Adapter for the Hyperstage Environment
      • Hyperstage Optimization Settings
    • Using the Adapter for i Access
      • Preparing the i Access Environment (ODBC)
      • Preparing the i Access Environment (JDBC)
      • Configuring the Adapter for i Access
      • Managing i Access Metadata
      • Customizing the i Access Environment
      • i Access Optimization Settings
    • Using the Adapter for CA-IDMS/DB
      • Preparing the IDMS/DB Environment
      • Configuring the Adapter for IDMS/DB
      • IDMS/DB Overview and Mapping Considerations
      • Managing IDMS/DB Metadata
      • Master Files for IDMS/DB
      • Access Files for IDMS/DB
      • IDMS/DB Sample File Descriptions
      • File Retrieval
      • Record Retrieval
      • Customizing the IDMS/DB Environment
      • Tracing the Adapter for IDMS/DB
    • Using the Adapter for CA-IDMS/SQL
      • Preparing the IDMS/SQL Environment
      • Configuring the Adapter for IDMS/SQL
      • Managing IDMS/SQL Metadata
      • Customizing the IDMS/SQL Environment
      • IDMS/SQL Optimization Settings
    • Using the Adapter for IMS
      • IMS Environments: Overview
      • Preparing the IMS Environment
      • Configuring the Adapter for IMS
      • Managing IMS Metadata
      • Master File Attributes
      • Access File Attributes
      • WebFOCUS Reporting With IMS
      • Maintaining IMS Data Sources
    • Using the Adapter for IMS Transactions
      • Preparing the IMS Transactions Environment
      • IMS Transactions Adapter Supported Platforms and Release Information
      • Configuring the Adapter for IMS Transactions
      • Managing IMS Transactions Metadata
      • Invoking an IMS Transaction
      • Invoking an IMS Stored Procedure
    • Using the Adapter for Informix
      • Preparing the Informix Environment
      • Configuring the Adapter for Informix
      • Managing Informix Metadata
      • Customizing the Informix Environment
      • Informix Optimization Settings
      • Calling an Informix Stored Procedure Using SQL Passthru
    • Using the Adapter for Ingres
      • Preparing the Ingres Environment
      • Configuring the Adapter for Ingres
      • Managing Ingres Metadata
      • Customizing the Ingres Environment
      • Ingres Optimization Settings
    • Using the Adapter for Interplex
      • Preparing the Interplex Environment
      • Configuring the Adapter for Interplex
      • Managing Interplex Metadata
      • Customizing the Interplex Environment
      • Interplex Optimization Settings
    • Using the Adapter for iWay Adapter Framework (IWAF)
      • Preparing the IWAF Environment
      • Configuring the Adapter for IWAF
      • Creating Synonyms With iWay Adapter Framework (IWAF)
    • Using the Adapter for JBoss Application Server
      • Preparing the JBoss Application Server Environment
      • Configuring the Adapter for JBoss Application Server
      • Managing JBoss Application Server Metadata
      • Customizing the JBoss Application Server Environment
      • JBoss Application Server Optimization Settings
    • Using the Adapter for JDBC
      • Preparing the JDBC Environment
      • Configuring the Adapter for JDBC
      • Managing JDBC Metadata
      • Customizing the JDBC Environment
      • JDBC Optimization Settings
    • Using the Adapter for JD Edwards EnterpriseOne
      • Preparing the JD Edwards EnterpriseOne Environment
      • Overview of the Setup Process
      • Configuring the Adapter for JD Edwards EnterpriseOne
      • Creating Synonyms for JD Edwards EnterpriseOne
      • Refreshing the Metadata Repository
      • Refresh Security Extracts
      • Converting Synonyms for JD Edwards EnterpriseOne (Non IBM i Platforms Only)
      • Setting the UDCDIC Environment Variable (Windows only)
    • Using the Adapter for JD Edwards World
      • Installation Prerequisites
      • Configuring the Adapter for JD Edwards World
      • Managing JD Edwards World Metadata
      • Enabling JD Edwards World Security
      • Enabling Tracing
      • Frequently Asked Questions
    • Using the Adapter for Jethro
      • Obtaining the Jethro Drivers
      • Preparing the Environment for the JDBC Driver
      • Configuring the JDBC Adapter for Jethro
      • Creating Synonyms With Jethro
    • Using the Adapter for JSON
      • Preparing the JSON Environment
      • Configuring the Adapter for JSON
      • Managing JSON Metadata
    • Using the Adapter for Lawson
      • Adapter for Lawson: Overview
      • Configuring the Adapter for Lawson
      • Preparing the Lawson Environment
      • Managing Lawson Metadata
      • Updating Lawson Security Information
    • Using the Adapter for LinkedIn
      • LinkedIn Adapter Overview
      • Creating a LinkedIn Application
      • Configuring the LinkedIn Adapter
      • Creating Metadata and Sample Reports for the LinkedIn Adapter
      • LinkedIn Adapter Examples
    • Using the Adapter for Lotus Notes
      • Preparing the Lotus Notes Environment
      • Configuring the Adapter for Lotus Notes
      • Managing Lotus Notes Metadata
    • Using the Adapter for LDAP
      • Preparing the LDAP Environment
      • Configuring the Adapter for LDAP
      • Managing LDAP Metadata
    • Using the Adapter for MariaDB
      • Preparing the MariaDB Environment
      • Configuring the Adapter for MariaDB
      • Managing MariaDB Metadata
      • Customizing the Adapter for the MariaDB Environment
      • MariaDB Optimization Settings
    • Using the Adapter for Microsoft Access
      • Preparing the Microsoft Access Environment
      • Configuring the Adapter for Microsoft Access
      • Managing Microsoft Access Metadata
    • Using the Adapter for Microsoft Azure SQL Data Warehouse
      • Preparing the Microsoft Azure SQL Data Warehouse Environment
      • Configuring the Adapter for Microsoft Azure SQL Data Warehouse
      • Managing Microsoft Azure SQL Data Warehouse Metadata
      • Reporting Against a Microsoft Azure SQL Data Warehouse Stored Procedure
      • Customizing the Microsoft Azure SQL Data Warehouse Environment
      • Microsoft Azure SQL Data Warehouse Optimization Settings
      • Calling a Microsoft Azure SQL Data Warehouse Stored Procedure Using SQL Passthru
    • Using the Adapter for Microsoft Dynamics CRM
      • Creating an App in the Microsoft Azure Active Directory
      • Configuring the Adapter for Microsoft Dynamics CRM
      • Creating Metadata for the Adapter for Microsoft Dynamics CRM
    • Using the Adapter for Microsoft SQL Server
      • Preparing the Microsoft SQL Server Environment
      • Configuring the Adapter for Microsoft SQL Server
      • Managing Microsoft SQL Server Metadata
      • Reporting Against a Microsoft SQL Server Stored Procedure
      • Customizing the Microsoft SQL Server Environment
      • Microsoft SQL Server Optimization Settings
      • Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
      • Microsoft SQL Server Compatibility With ODBC
    • Using the Adapter for Microsoft SQL Server ODBC
      • Preparing the Microsoft SQL Server ODBC Environment
      • Configuring the Adapter for Microsoft SQL Server ODBC
      • Managing Microsoft SQL Server ODBC Metadata
      • Reporting Against a Microsoft SQL Server ODBC Stored Procedure
      • Customizing the Microsoft SQL Server ODBC Environment
      • Microsoft SQL Server ODBC Optimization Settings
      • Calling a Microsoft SQL Server ODBC Stored Procedure Using SQL Passthru
    • Using the Adapter for Millennium
      • Preparing the Server Environment for Millennium
      • Configuring the Adapter for Millennium
      • Preparing the Millennium Environment
      • Managing Millennium Metadata
      • Standard Master File Attributes for a Millennium Data Source
    • Using the Adapter for Model 204
      • Preparing the Model 204 Environment
      • Configuring the Adapter for Model 204
      • Model 204 Overview and Mapping Considerations
      • Managing Model 204 Metadata
      • Master Files for Model 204
      • Access Files for Model 204
      • Customizing the Model 204 Environment
      • Using Customized Security Exits
      • Adapter Tracing for Model 204
    • Using the Adapter for MongoDB With UnityJDBC
      • Introducing the Adapter for MongoDB
      • Preparing the MongoDB Environment
      • Configuring the Adapter for MongoDB
      • Creating Synonyms With MongoDB
      • Limitations
    • Using the Adapter for MySQL
      • Preparing the MySQL Environment
      • Configuring the Adapter for MySQL
      • Managing MySQL Metadata
      • Customizing the Adapter for the MySQL Environment
      • MySQL Optimization Settings
    • Using the Adapter for NATURAL
      • Preparing the NATURAL Environment
      • Configuring the Adapter for NATURAL
      • Managing Metadata for NATURAL
      • Invoking a NATURAL Program
    • Using the Adapter for NATURAL CICS Transactions
      • Preparing the NATURAL CICS Environment
      • NATURAL CICS Transactions Supported Platforms and Release Information
      • NATURAL CICS and VTAM Configuration
      • Installing NATURAL Support Programs
      • Configuring the Adapter for NATURAL CICS Transactions
      • Managing NATURAL CICS Transactions Metadata
      • NATURAL Data Buffer Processing API
      • Invoking a NATURAL CICS Transaction
    • Using the Adapter for Netezza
      • Preparing the Netezza Environment
      • Unicode Support in Netezza
      • Configuring the Adapter for Netezza
      • Managing Netezza Metadata
      • Customizing the Netezza Environment
      • Netezza Optimization Settings
    • Using the Adapter for Nucleus
      • Preparing the Nucleus Environment
      • Configuring the Adapter for Nucleus
      • Managing Nucleus Metadata
      • Customizing the Nucleus Environment
      • Nucleus Optimization Settings
    • Using the Adapter for ODBC
      • Preparing the ODBC Environment
      • Configuring the Adapter for ODBC
      • Managing ODBC Metadata
      • Customizing the ODBC Environment
      • ODBC Optimization Settings
    • Using the Adapter for Oracle
      • Preparing the Oracle Environment
      • Configuring the Adapter for Oracle
      • Managing Oracle Metadata
      • Reporting Against an Oracle Stored Procedure
      • Customizing the Oracle Environment
      • Oracle Optimization Settings
      • Calling an Oracle Stored Procedure Using SQL Passthru
    • Using the Adapter for Oracle E-Business Suite
      • Preparing the Oracle E-Business Suite Environment
      • Data Access and Security
      • Configuring the Adapter for Oracle E-Business Suite
      • Maintaining Security Rules
    • Using the Adapter for Oracle TimesTen
      • Preparing the Oracle TimesTen Environment
      • Configuring the Adapter for Oracle TimesTen
      • Managing Oracle TimesTen Metadata
      • Customizing the Oracle TimesTen Environment
      • Oracle TimesTen Optimization Settings
    • Using the Adapter for parAccel
      • Configuring the Adapter for parAccel
      • Managing parAccel Metadata
    • Using the Adapter for PeopleSoft
      • Preparing the PeopleSoft Environment
      • Configuring the Adapter for PeopleSoft
      • Managing PeopleSoft Metadata
      • Managing PeopleSoft Secured Data Access
      • Managing Connections to PeopleSoft
      • Using Administrative Utilities
      • Migrating from 7.1x and 7.6.x to 7.7
      • Moving the PeopleSoft Adapter from Server to Server
      • Changing the WebFOCUS Reporting Server Code Page to Unicode
      • Advanced Administrative Topics
    • Using the Adapter for PostgreSQL
      • Preparing the PostgreSQL Environment
      • Configuring the Adapter for PostgreSQL
      • Managing PostgreSQL Metadata
      • Customizing the PostgreSQL Environment
      • PostgreSQL Optimization Settings
    • Using the Adapter for Progress
      • Preparing the Progress Environment
      • Configuring the Adapter for Progress
      • Managing Progress Metadata
      • Customizing the Progress Environment
      • Progress Optimization Settings
    • Using the Adapter for PSQL
      • Preparing the PSQL Environment
      • Configuring the Adapter for PSQL
      • Managing PSQL Metadata
      • Customizing the PSQL Environment
      • PSQL Optimization Settings
    • Using the Adapter for Query/400
      • Preparing the Adapter for Query/400 Environment
      • Configuring the Adapter for Query/400
      • Managing Query/400 Metadata
    • Using the Adapter for Rdb
      • Preparing the Rdb Environment
      • Configuring the Adapter for Rdb
      • Managing Rdb Metadata
      • Using Multiple Rdb DBMS Files
      • Using Multischema Rdb DBMS Files
      • Rdb Database Driver Performance
    • Using the Adapter for Red Brick
      • Preparing the Red Brick Environment
      • Configuring the Adapter for Red Brick
      • Managing Red Brick Metadata
      • Customizing the Red Brick Environment
      • Redbrick Optimization Settings
    • Using the Adapter for Remote Servers
      • Configuring Remote Servers
      • Managing Metadata for Remote Servers
      • Executing Stored Procedures
    • Using the Adapter for REST
      • Configuring the Adapter for REST
      • Managing RESTful Web Services Metadata
    • Using the Adapter for RMS
      • Preparing the RMS Environment
      • Configuring the Adapter for RMS
      • Managing RMS Metadata
      • Manually Describing RMS Files
      • Describing Complex RMS Keyed Files
      • Associating an RMS Data Source to a Master File
      • Retrieving Data From RMS Files
      • Syntax for RMS Master File Attributes
      • RMS Attribute Summary
      • Read/Write Usage Limitations of the Adapter for RMS
    • Using the Adapter for Rserve
      • Introduction to the Adapter for Rserve
      • Configuring the Adapter for Rserve
      • Creating a Synonym for an R Script
    • Using the Adapter for Salesforce.com
      • Configuring the Adapter for Salesforce.com
      • Creating Synonyms With Salesforce.com
    • Using the Adapter for SAP Business Intelligence Warehouse (BW)
      • Preparing the SAP BW Environment
      • Configuring the Adapter for SAP BW
      • SAP BW Adapter Supporting Mixed Code Page Environments
      • Creating BEx Queries
      • SAP BW Reporting With WebFOCUS
      • Managing SAP BW Metadata
      • Customization Settings
      • Support for BEx Structures
      • Producing SAP BW Requests Using SQL
    • Using the Adapter for SAP ERP
      • Preparing the SAP Environment
      • Accessing Multiple SAP Systems
      • Configuring the Adapter for SAP
      • Post-Configuration Tasks in an SAP Environment
      • Managing SAP Metadata
      • SAP Table Class Support for an Individual Table
      • SAP Support for a Function Module
      • SAP Data Type Support
      • SAP Open/SQL Support
      • Advanced SAP Features
      • Setting Up the Report Processing Mode
      • SAP Adapter Supporting Mixed Code Page Environments
      • Producing SAP Requests
    • Using the Adapter for SAP Hana
      • Preparing the SAP Hana Environment
      • Configuring the Adapter for SAP Hana
      • Managing SAP Hana Metadata
      • Customizing the SAP Hana Environment
      • SAP Hana Optimization Settings
    • Using the Adapter for Siebel
      • Software Requirements for the Adapter for Siebel
      • Preparing the Siebel Environment
      • Preparing the Server Environment for Adapter Configuration
      • Configuring the Adapter for Siebel
      • Managing Siebel Metadata
      • Siebel Optimization Settings
    • Using the Adapter for SQLBase
      • Preparing the SQLBase Environment
      • Configuring the Adapter for SQLBase
      • Managing SQLBase Metadata
      • Customizing the SQLBase Environment
      • SQLBase Optimization Settings
    • Using the Adapter for Microsoft SQL Server Analysis Services (SSAS)
      • Preparing the SQL Server Analysis Services (SSAS) Environment
      • Configuring the Adapter for SQL Server Analysis Services
      • Configuring the Adapter for TM1
      • Managing SQL Server Analysis Services Metadata
      • Customizing the SQL Server Analysis Services Environment
      • SQL Server Analysis Services (SSAS) Reporting With WebFOCUS
    • Using the Adapter for Sybase
      • Preparing the Sybase Environment (OCS)
      • Configuring the Adapter for Sybase
      • Managing Sybase Metadata
      • Reporting Against a Sybase Stored Procedure
      • Customizing the Sybase Environment
      • Sybase Optimization Settings
      • Calling a Sybase Stored Procedure Using SQL Passthru
    • Using the Adapter for Teradata
      • Preparing the Teradata Environment
      • Configuring the Adapter for Teradata
      • Managing Teradata Metadata
      • Reporting Against a Teradata Stored Procedure
      • Customizing the Teradata Environment
      • Teradata Optimization Settings
      • Calling a Teradata Macro or Stored Procedure Using SQL Passthru
    • Using the Adapter for Transoft
      • Preparing the Transoft Environment
      • Configuring the Adapter for Transoft
      • Managing Transoft Metadata
      • Customizing the Transoft Environment
      • Transoft Optimization Settings
    • Using the Adapter for Twitter
      • Twitter Adapter Overview
      • Creating a Twitter Application
      • Configuring the Twitter Adapter
      • Creating Metadata and Sample Reports for the Twitter Adapter
      • Twitter Examples
    • Using the Adapter for UniData
      • Preparing the UniData Environment
      • Configuring the Adapter for UniData
      • Managing UniData Metadata
      • Customizing the UniData Environment
      • UniData Optimization Settings
    • Using the Adapter for UniVerse
      • Preparing the UniVerse Environment
      • Configuring the Adapter for UniVerse
      • Managing UniVerse Metadata
      • Customizing the UniVerse Environment
      • UniVerse Optimization Settings
    • Using the Adapter for VSAM
      • Preparing the Environment for VSAM
      • Configuring the Adapter for VSAM
      • Managing VSAM Metadata
      • Associating a VSAM Data Source With a Master File
      • Standard Master File Attributes for a VSAM Data Source
      • Redefining a Field in a VSAM Data Source
      • Extra-Large Record Length Support With VSAM
      • Describing Multiple Record Types in VSAM Data Sources
      • Combining Multiply-Occurring Fields and Multiple Record Types in VSAM
      • Establishing VSAM Data and Index Buffers
      • Using a VSAM Alternate Index
      • VSAM Record Selection Efficiencies
      • Maintaining VSAM KSDS Data Sources
      • Using VSAM Relative Record Data Set (RRDS) Files
      • Reviewing SQL Updates to VSAM Data Sources
    • Using the Adapter for WAND Sentiment Analysis
      • WAND Sentiment Analysis Adapter Overview
      • Installing, Configuring, and Updating the WAND Taxonomy Server
      • Installing and Using the WAND Taxonomy Editor
      • Configuring the WAND Sentiment Analysis Adapter
      • Creating Metadata and Sample Reports for the WAND Sentiment Analysis Adapter
      • WAND Sentiment Analysis Adapter Examples
    • Using the Adapter for Web Services
      • Configuring the Adapter for Web Services
      • Managing Web Services Metadata
      • Capturing a SOAP Request Using FILEDEF SOAPTSCQ in a Procedure
    • Using the Adapter for WebFOCUS Client REST
      • Configuring the Adapter for WebFOCUS Client REST
      • Creating Synonyms and Examples for the Adapter for WebFOCUS Client REST
    • Using the Adapter for Words Analysis
      • Words Analysis Adapter Overview
      • Configuring the Words Analysis Adapter
      • Creating Metadata and Sample Reports for the Words Analysis Adapter
      • Words Analysis Adapter Examples
    • Using the Adapter for XML
      • Preparing the XML Environment
      • Configuring the Adapter for XML
      • Managing XML Metadata
      • Associating a Master File With an XML Document
    • XA Support
      • XA Transaction Management
      • Supported Interfaces
      • Implementation
      • Vendor Specifics
    • Aggregate Awareness Support
      • Relational Adapters and Aggregated SQL Queries
      • Aggregate Awareness in an RDBMS
    • Cluster Join
      • Embedded Joins
      • Embedded Join Master Files
    • Translating COBOL File Descriptions
      • Creating Synonyms From COBOL File Descriptions
      • Controlling the Translation of a COBOL File Description
    • Data Set Compression Exit: ZCOMP
      • Invoking the ZCOMP Exit
      • What Happens When ZCOMP is LOADED?
    • Dynamic Private User Exit
      • FOCSAM and the GETPRV User Exit
      • Physical Implementation of the GETPRV Exit
      • Master File for Data Access With GETPRV
      • Access File for Data Access With GETPRV
      • Calling Parameters and Work Areas
    • Validation for Special Characters and Reserved Words
      • Validation for Special Characters
      • Validation for Reserved Words
  • Server Administration
    • Launch PDF file
    • Server Introduction
      • Using the Web Console
      • Menu Options
      • Configuration Overview
      • Server Profiles
      • Profile Commands
    • Server Security
      • Server Security Overview
      • Configuring Authentication
      • Configuring Privileges and Other Authorizations
      • Configuring Server Encryption
      • Access to Connection Information in WebFOCUS Procedures
      • Configuring the Server for Multi-Tenant Deployment
    • Managing Applications
      • What Is an Application?
      • Procedures and Metadata on the Application Tree
      • Managing Applications and Paths
      • Application Commands Overview
      • Search Path Management Commands
      • Application and File Management Commands
      • Output Redirection Commands
      • Application Metadata Commands and Catalog Metadata
      • APP HELP
      • Restricting the Use of APP Commands
      • Accessing Metadata and Procedures
      • Allocating Temporary Files
      • Temporary Space Usage and Location
      • Temporary Disk Space Usage for Non-PDS Deployment
      • Application Tools
    • Managing Adapters
      • Changing Common Adapter Settings
      • Configuring an Adapter
      • Changing the Adapter Configuration
      • Configuring a Remote Server
      • Complete Adapter List
      • SQL Automatic Passthru Status
      • Determining SQL Optimization
      • Data Type Support Report
      • Displaying License Counts
      • Social Media Adapters
    • Metadata
      • Creating Synonyms
      • Testing Synonyms
      • Managing Synonyms
      • LNGPREP Utility: Preparing Metadata Language Files
      • Introduction to Wizards
      • Connecting to Data
      • Uploading Files
      • Using Data Assist
    • Stored Procedures
      • Working With Stored Procedures
      • Creating a Stored Procedure
      • Using the Web Console Search
      • Using the Web Console Text Editor
      • Sending Stored Procedure Report Output to Server-Side Printers
      • Editing a Stored Procedure
      • Running a Stored Procedure
      • Debugging a Stored Procedure
      • Running a Procedure With Advanced Options
      • Scheduling a Procedure
      • Sending an E-mail Notification for a Procedure
      • Procedure Run-Time Processing Essentials
      • Platform-Specific Commands and Features
      • Stress Testing a Procedure
      • Running Impact Analysis Reports
    • Server Workspace Manager
      • Configuring Workspace Manager
      • Workspace Configuration Settings
      • Editing Configuration Files
      • Configuring Java Services
      • Cluster Manager
      • Monitoring Server Activity
    • Listeners and Special Services
      • Using the Listeners and Special Services Configuration Panes
      • Special Services
      • Listeners
    • Troubleshooting
      • Viewing Version Information
      • Analyzing Server Activity
      • Analyzing FOCUS Database Server Activity
      • Tracing Server Activity
      • z/OS-Specific Troubleshooting for the Unified Server
      • z/OS-Specific Troubleshooting for z/OS HFS Deployment
      • Recording and Reproducing User Actions
      • Troubleshooting the Console
      • Server Processes
      • Gathering Diagnostic Information for Customer Support Services
    • Unicode Support
      • Unicode and the WebFOCUS Reporting Server
      • Accessing Unicode Data
      • Selecting, Reformatting, and Manipulating Characters
      • Sort Order Under Unicode
      • Added Unicode Support for Master Files, Data Files, and Application Directory Names
      • Unicode PDF Output
    • Platform-Specific Methods for Specifying EDAEXTSEC
      • Platform-Specific Methods for Setting EDAEXTSEC
• DataMigrator
  • Launch PDF file
  • Introduction to DataMigrator
    • Data Management and Migration Overview
    • What Is DataMigrator?
    • DataMigrator Architecture
    • DataMigrator Server
    • DataMigrator Data Management Console
    • Server Web Console
    • Designing Data Flows and Process Flows
    • Revised Functionality
    • Getting Help
    • Information Builders and iWay Software on the Web
  • Setting Up DataMigrator
    • DataMigrator Setup At a Glance
    • Remote Server Setup At a Glance
    • DataMigrator Setup
    • Initiating Server Administration Tasks
    • Authorizing DataMigrator Server Usage and Administration
    • Managing Application Directories and Configuring the Application Path
    • Configuring Data Adapters
    • Creating Metadata
    • Testing Sample Data and a Process Flow
    • Performing Server Administration Tasks
    • Using Secure Shell FTP (SFTP)
    • Upgrading DataMigrator From Release 4.3 or 5.1
    • Upgrading DataMigrator from Release 5.2 and Higher
    • Upgrading DataMigrator to Release 7.7.07 or 8.2
  • Planning a DataMigrator Application
    • Designing Your Application
    • Using Synonyms for Data Sources and Data Targets
    • Reviewing Your Data Sources
    • Reviewing Your Data Targets
    • Establishing Security for DataMigrator
  • Working in the Data Management Console
    • Data Management Console Interface
    • Navigation Pane
    • DataMigrator Workspace
    • Text Editor
    • Aerial View
    • Ribbon Tabs
    • Metadata Tab
    • Text Editor Tab
    • Console Log
    • Setting Flow Properties
    • Viewing Properties
    • Setting User Preferences
    • User Privileges
    • License Code
    • Configuring National Language Support
    • Ending a Data Management Console Session
  • Designing a Data Flow
    • The Data Flow Interface
    • Simple Data Flow at a Glance
    • Complex Data Flow at a Glance
    • Creating a Data Flow
    • Specifying Data Sources
    • Creating a Source Transformation in a Data Source Object
    • Joining Data Sources
    • Adding a SELECT to a Data Flow
    • Adding a UNION to a Data Flow
    • Selecting Columns
    • Testing the SQL Statement
    • Specifying Filters in a Data Flow
    • Specifying Sorts
    • Selecting a Data Target
    • Specifying Data Target Options
    • Mapping Transformations
    • Using Variables in a Flow
    • Using Functions
    • Column Formats and Mapping
    • Setting Properties of a Flow
    • Running a Data Flow
    • Creating a Direct Load Flow
    • Creating a DBMS SQL Flow
    • Creating a Quick Copy
  • Designing a Process Flow
    • Process Flow Methodology
    • Process Flow Interface
    • Simple Process Flow At a Glance
    • Complex Process Flow at a Glance
    • Creating a Process Flow
    • Adding a Saved Procedure to a Process Flow
    • Assigning and Using Variables in a Process Flow
    • Maintaining Continuous Processing in a Single Agent
    • Executing a Process Flow That Contains Only Procedures
    • Adding Email Messages to a Process Flow
    • Setting Connection Logic
    • Grouping and Controlling Simultaneous Execution of Flows
    • Running a Process Flow
    • Scheduling a Process Flow
  • Tutorial: Creating Data and Process Flows With DataMigrator
    • What You Are Going To Do
    • Startup and Setup Tasks
    • Exercise 1: Creating the Data Flow
    • Selecting and Joining Data Sources
    • Selecting and Managing Columns
    • Adding Data Targets
    • Submitting the Data Flow
    • Data Flow Review
    • Exercise 2: Creating the Process Flow
    • Starting the Process Flow
    • Adding a Data Flow Object to the Process Flow
    • Branching in the Process Flow
    • Submitting the Process Flow
  • Generating Reports, Viewing the Log File, and Printing Flows
    • DataMigrator Log, Statistics, and Summary Flow Reports
    • Scheduler Reports
    • Impact Analysis Reports on Synonyms, Procedures and Columns
    • Working With a Report
    • Viewing a Detailed Flow Report and Log File
    • Printing a Graphical Representation of a Data or Process Flow
  • Optimizing Performance
    • Improving Data Extraction Performance
    • Using Automatic Passthru
    • Improving Data Loading Performance
    • Improving Lookup Performance
  • Working With Synonyms
    • Synonym Editor Layout
    • Viewing and Editing Synonym Attributes
    • Using Variables in a Synonym
    • Variables Attribute Summary
    • How to Use a Variable in a Synonym
    • Creating and Enhancing Synonyms Using Modeling View
    • Adding Indexes to a Synonym
    • Adding Virtual Columns (DEFINE) in a Synonym
    • Viewing Data Profiling Characteristics
    • Viewing Data Lineage for a Column
  • Advanced DataMigrator Tips and Techniques
    • Overview of Examples
    • Creating Sample Data and Metadata
    • Horizontal Partitioning with Multi-Table Load
    • Using the Decode Function
    • Generating a Surrogate Key
    • Generating a Surrogate Key Using Slowly Changing Dimensions
    • Mapping to a Sequential File of a Specific Format
    • Creating and Using Reusable Transformations
    • Using Multiple Targets to Create a Single File With Multiple Records Types
    • Creating a Target File With Multiple RECTYPEs
    • Combining Multiple Sources Rows in a Single Target Row
    • Using Lookups to Create Multi-Table Flows Without Joins
    • Record Logging
    • Using Variables in Data Flows
    • Creating a Data Flow Using a Target Based on a Predefined XML Schema
    • Loading a Target Table Using the File Listener
    • Sending a Target File to an FTP or SFTP Server
    • Loading a Star Schema
    • Iterating Through Multiple Tables
    • Using Subqueries
    • Loading Images Into a Database Table
    • Updating Values in a Table
  • Change Data Capture
    • Enabling the Database for Logging in Relational Databases
    • Properties of a Table Log Record Synonym
    • Tutorial: Using Change Data Capture with Relational Databases
  • DataMigrator Log Statistics and Tables
    • Log and Statistics Tables
    • FOCUS Logs and Statistics
    • CSV Logs and Statistics
    • Managing Log and Statistics
    • Custom Procedures for Managing FOCUS Logs and Statistics
    • Description of the Log Files
    • Description of the Statistics Files
    • List of Essential ETL LOG Message Codes
  • Event-Based Scheduling
    • Starting Flows With CMRUN
    • Starting Flows With CMASAP
    • Starting Flows From FOCUS
    • Determining the Status of an Event-Based Flow
  • Problems, Errors, and Troubleshooting
    • DataMigrator Status Codes and Server Messages
    • Server Run-Time Error Codes
    • DataMigrator Management Problem Resolution
    • Including Run-Time Messages in the ETL Log
    • Performing a Trace to Diagnose Server Problems
  • Customizing Your Environment
    • DataMigrator Parameters
  • Source Management
    • Overview of Source Management
    • Source Control Security Server and Client Setup
    • Configuring Source Management and Setting Up Source Control That Uses SCC API
    • Using a Source Control System to Manage Procedures and Synonyms
• Reference
  • Functions Reference
    • Launch PDF file
    • Functions Overview
      • Function Arguments
      • Function Categories
      • Character Chart for ASCII and EBCDIC
    • Simplified Analytic Functions
      • FORECAST_MOVAVE: Using a Simple Moving Average
      • FORECAST_EXPAVE: Using Single Exponential Smoothing
      • FORECAST_DOUBLEXP: Using Double Exponential Smoothing
      • FORECAST_SEASONAL: Using Triple Exponential Smoothing
      • FORECAST_LINEAR: Using a Linear Regression Equation
      • PARTITION_AGGR: Creating Rolling Calculations
      • PARTITION_REF: Using Prior Field Values in Calculations
    • Simplified Character Functions
      • CHAR_LENGTH: Returning the Length in Characters of a String
      • CONCAT: Concatenating Strings After Removing Trailing Blanks From the First
      • DIGITS: Converting a Number to a Character String
      • LAST_NONBLANK: Retrieving the Last Field Value That is Neither Blank nor Missing
      • LOWER: Returning a String With All Letters Lowercase
      • LPAD: Left-Padding a Character String
      • LTRIM: Removing Blanks From the Left End of a String
      • PATTERNS: Returning a Pattern That Represents the Structure of the Input String
      • POSITION: Returning the First Position of a Substring in a Source String
      • REGEX: Matching a String to a Regular Expression
      • REPLACE: Replacing a String
      • RPAD: Right-Padding a Character String
      • RTRIM: Removing Blanks From the Right End of a String
      • SPLIT: Extracting an Element From a String
      • SUBSTRING: Extracting a Substring From a Source String
      • TOKEN: Extracting a Token From a String
      • TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
      • UPPER: Returning a String With All Letters Uppercase
    • Character Functions
      • ARGLEN: Measuring the Length of a String
      • ASIS: Distinguishing Between Space and Zero
      • BITSON: Determining If a Bit Is On or Off
      • BITVAL: Evaluating a Bit String as an Integer
      • BYTVAL: Translating a Character to Decimal
      • CHKFMT: Checking the Format of a String
      • CHKNUM: Checking a String for Numeric Format
      • CTRAN: Translating One Character to Another
      • CTRFLD: Centering a Character String
      • EDIT: Extracting or Adding Characters
      • GETTOK: Extracting a Substring (Token)
      • LCWORD: Converting a String to Mixed-Case
      • LCWORD2: Converting a String to Mixed-Case
      • LCWORD3: Converting a String to Mixed-Case
      • LJUST: Left-Justifying a String
      • LOCASE: Converting Text to Lowercase
      • OVRLAY: Overlaying a Character String
      • PARAG: Dividing Text Into Smaller Lines
      • PATTERN: Generating a Pattern From a String
      • POSIT: Finding the Beginning of a Substring
      • REVERSE: Reversing the Characters in a String
      • RJUST: Right-Justifying a Character String
      • SOUNDEX: Comparing Character Strings Phonetically
      • SPELLNM: Spelling Out a Dollar Amount
      • SQUEEZ: Reducing Multiple Spaces to a Single Space
      • STRIP: Removing a Character From a String
      • STRREP: Replacing Character Strings
      • SUBSTR: Extracting a Substring
      • TRIM: Removing Leading and Trailing Occurrences
      • UPCASE: Converting Text to Uppercase
      • XMLDECOD: Decoding XML-Encoded Characters
      • XMLENCOD: XML-Encoding Characters
    • Variable Length Character Functions
      • Overview
      • LENV: Returning the Length of an Alphanumeric Field
      • LOCASV: Creating a Variable Length Lowercase String
      • POSITV: Finding the Beginning of a Variable Length Substring
      • SUBSTV: Extracting a Variable Length Substring
      • TRIMV: Removing Characters From a String
      • UPCASV: Creating a Variable Length Uppercase String
    • Character Functions for DBCS Code Pages
      • DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
      • DEDIT: Extracting or Adding Characters
      • DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
      • DSUBSTR: Extracting a Substring
      • JPTRANS: Converting Japanese Specific Characters
      • KKFCUT: Truncating a String
      • SFTDEL: Deleting the Shift Code From DBCS Data
      • SFTINS: Inserting the Shift Code Into DBCS Data
    • Data Source and Decoding Functions
      • DB_EXPR: Inserting an SQL Expression Into a Request
      • DB_INFILE: Testing Values Against a File or an SQL Subquery
      • DB_LOOKUP: Retrieving Data Source Values
      • DECODE: Decoding Values
      • FIND: Verifying the Existence of a Value in a Data Source
      • LAST: Retrieving the Preceding Value
      • LOOKUP: Retrieving a Value From a Cross-referenced Data Source
    • Simplified Date and Date-Time Functions
      • DT_CURRENT_DATE: Returning the Current Date
      • DT_CURRENT_DATETIME: Returning the Current Date and Time
      • DT_CURRENT_TIME: Returning the Current Time
      • DTADD: Incrementing a Date or Date-Time Component
      • DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
      • DTIME: Extracting Time Components From a Date-Time Value
      • DTPART: Returning a Date or Date-Time Component in Integer Format
      • DTRUNC: Returning the Start of a Date Period for a Given Date
    • Date Functions
      • Overview of Date Functions
      • Using Standard Date Functions
      • DATEADD: Adding or Subtracting a Date Unit to or From a Date
      • DATECVT: Converting the Format of a Date
      • DATEDIF: Finding the Difference Between Two Dates
      • DATEMOV: Moving a Date to a Significant Point
      • DATETRAN: Formatting Dates in International Formats
      • FIYR: Obtaining the Financial Year
      • FIQTR: Obtaining the Financial Quarter
      • FIYYQ: Converting a Calendar Date to a Financial Date
      • TODAY: Returning the Current Date
      • Using Legacy Date Functions
      • AYM: Adding or Subtracting Months
      • AYMD: Adding or Subtracting Days
      • CHGDAT: Changing How a Date String Displays
      • DA Functions: Converting a Legacy Date to an Integer
      • DMY, MDY, YMD: Calculating the Difference Between Two Dates
      • DOWK and DOWKL: Finding the Day of the Week
      • DT Functions: Converting an Integer to a Date
      • GREGDT: Converting From Julian to Gregorian Format
      • JULDAT: Converting From Gregorian to Julian Format
      • YM: Calculating Elapsed Months
    • Date-Time Functions
      • Using Date-Time Functions
      • HADD: Incrementing a Date-Time Value
      • HCNVRT: Converting a Date-Time Value to Alphanumeric Format
      • HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
      • HDIFF: Finding the Number of Units Between Two Date-Time Values
      • HDTTM: Converting a Date Value to a Date-Time Value
      • HGETC: Storing the Current Local Date and Time in a Date-Time Field
      • HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
      • HHMMSS: Retrieving the Current Time
      • HHMS: Converting a Date-Time Value to a Time Value
      • HINPUT: Converting an Alphanumeric String to a Date-Time Value
      • HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
      • HNAME: Retrieving a Date-Time Component in Alphanumeric Format
      • HPART: Retrieving a Date-Time Component as a Numeric Value
      • HSETPT: Inserting a Component Into a Date-Time Value
      • HTIME: Converting the Time Portion of a Date-Time Value to a Number
      • HTMTOTS: Converting a Time to a Timestamp
      • HYYWD: Returning the Year and Week Number From a Date-Time Value
    • Simplified Conversion Functions
      • CHAR: Returning a Character Based on a Numeric Code
      • CTRLCHAR: Returning a Non-Printable Control Character
      • EDIT2: Converting a Numeric, Date, or Date-Time Value to a Character String
      • HEXTYPE: Returning the Hexadecimal View of an Input Value
      • PHONETIC: Returning a Phonetic Key for a String
      • TO_INTEGER: Converting a Character String to an Integer Value
      • TO_NUMBER: Converting a Character String to a Numeric Value
    • Format Conversion Functions
      • ATODBL: Converting an Alphanumeric String to Double-Precision Format
      • EDIT: Converting the Format of a Field
      • FPRINT: Converting Fields to Alphanumeric Format
      • FTOA: Converting a Number to Alphanumeric Format
      • HEXBYT: Converting a Decimal Integer to a Character
      • ITONUM: Converting a Large Number to Double-Precision Format
      • ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
      • ITOZ: Converting a Number to Zoned Format
      • PCKOUT: Writing a Packed Number of Variable Length
      • PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
      • TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
      • UFMT: Converting an Alphanumeric String to Hexadecimal
      • XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
    • Simplified Numeric Functions
      • CEILING: Returning the Smallest Integer Value Greater Than or Equal to a Value
      • EXPONENT: Raising e to a Power
      • FLOOR: Returning the Largest Integer Less Than or Equal to a Value
      • MOD: Calculating the Remainder From a Division
      • POWER: Raising a Value to a Power
    • Numeric Functions
      • ABS: Calculating Absolute Value
      • CHKPCK: Validating a Packed Field
      • DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
      • EXP: Raising e to the Nth Power
      • EXPN: Evaluating a Number in Scientific Notation
      • INT: Finding the Greatest Integer
      • LOG: Calculating the Natural Logarithm
      • MAX and MIN: Finding the Maximum or Minimum Value
      • NORMSDST and NORMSINV: Calculating Normal Distributions
      • PRDNOR and PRDUNI: Generating Reproducible Random Numbers
      • RDNORM and RDUNIF: Generating Random Numbers
      • SQRT: Calculating the Square Root
    • Simplified Statistical Functions
      • Specify the Partition Size for Simplified Statistical Functions
      • CORRELATION: Calculating the Degree of Correlation Between Two Sets of Data
      • KMEANS_CLUSTER: Partitioning Observations Into Clusters Based on the Nearest Mean Value
      • MULTIREGRESS: Creating a Multivariate Linear Regression Column
      • RSERVE: Running an R Script
      • STDDEV: Calculating the Standard Deviation for a Set of Data Values
    • Simplified System Functions
      • EDAPRINT: Inserting a Custom Message in the EDAPRINT Log File
      • ENCRYPT: Encrypting a Password
      • GETENV: Retrieving the Value of an Environment Variable
      • PUTENV: Assigning a Value to an Environment Variable
    • System Functions
      • CLSDDREC: Closing All Files Opened by the PUTDDREC Function
      • FEXERR: Retrieving an Error Message
      • FGETENV: Retrieving the Value of an Environment Variable
      • FPUTENV: Assigning a Value to an Environment Variable
      • GETUSER: Retrieving a User ID
      • JOBNAME: Retrieving the Current Process Identification String
      • PUTDDREC: Writing a Character String as a Record in a Sequential File
      • SLEEP: Suspending Execution for a Given Number of Seconds
      • SYSVAR: Retrieving the Value of a z/OS System Variable
    • Simplified Geography Functions
      • Sample Geography Files
      • GIS_DISTANCE: Calculating the Distance Between Geometry Points
      • GIS_DRIVE_ROUTE: Calculating the Driving Directions Between Geometry Points
      • GIS_POINT: Building a Geometry Point
      • GIS_GEOCODE_ADDR: Geocoding a Complete Address
      • GIS_GEOCODE_ADDR_CITY: Geocoding an Address Line, City, and State
      • GIS_GEOCODE_ADDR_POSTAL: Geocoding an Address Line and Postal Code
      • GIS_GEOMETRY: Building a JSON Geometry Object
      • GIS_IN_POLYGON: Determining if a Point is in a Complex Polygon
      • GIS_LINE: Building a JSON Line
      • GIS_SERVICE_AREA: Calculating a Geometry Area Around a Given Point
      • GIS_SERV_AREA_XY: Calculating a Service Area Around a Given Coordinate
    • SQL Character Functions
      • CHAR_LENGTH: Finding the Length of a Character String
      • CONCAT: Concatenating Two Character Strings
      • DIGITS: Converting a Numeric Value to a Character String
      • EDIT: Editing a Value According to a Format (SQL)
      • LCASE: Converting a Character String to Lowercase
      • LTRIM: Removing Leading Spaces
      • POSITION: Finding the Position of a Substring
      • RTRIM: Removing Trailing Spaces
      • SUBSTR: Extracting a Substring From a String Value (SQL)
      • TRIM: Removing Leading or Trailing Characters (SQL)
      • UCASE: Converting a Character String to Uppercase
      • VARGRAPHIC: Converting to Double-byte Character Data
    • SQL Date and Time Functions
      • CURRENT_DATE: Obtaining the Date
      • CURRENT_TIME: Obtaining the Time
      • CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
      • DAY: Obtaining the Day of the Month From a Date/Timestamp
      • DAYS: Obtaining the Number of Days Since January 1, 0001
      • EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
      • HOUR: Obtaining the Hour From Time/Timestamp
      • MICROSECOND: Obtaining Microseconds From Time/Timestamp
      • MILLISECOND: Obtaining Milliseconds From Time/Timestamp
      • MINUTE: Obtaining the Minute From Time/Timestamp
      • MONTH: Obtaining the Month From Date/Timestamp
      • SECOND: Obtaining the Second Field From Time/Timestamp
      • QUARTER: Returning the Quarter of the Year
      • WEEKDAY: Returning the Day of the Week
      • YEAR: Obtaining the Year From a Date or Timestamp
    • SQL Data Type Conversion Functions
      • CAST: Converting to a Specific Data Type
      • CHAR: Converting to a Character String
      • CHAR: Converting to a Standard Date-Time Format
      • DATE: Converting to a Date
      • DECIMAL: Converting to Decimal Format
      • FLOAT: Converting to Floating Point Format
      • INT: Converting to an Integer
      • SMALLINT: Converting to a Small Integer
      • TIME: Converting to a Time
      • TIMESTAMP: Converting to a Timestamp
    • SQL Numeric Functions
      • ABS: Returning an Absolute Value (SQL)
      • CEIL: Returning the Smallest Integer Greater Than or Equal to a Value
      • FLOOR: Returning the Largest Integer Less Than or Equal to a Value (SQL)
      • GREATEST: Returning the Largest Value
      • LEAST: Returning the Smallest Value
      • LOG: Returning a Logarithm (SQL)
      • EXP: Returning e Raised to a Power
      • MOD: Returning the Remainder of a Division
      • POWER: Raising a Value to a Power (SQL)
      • SQRT: Returning a Square Root (SQL)
    • SQL Miscellaneous Functions
      • COUNTBY: Incrementing Column Values Row by Row
      • DB_EXPR: Inserting an SQL Expression Into a Request (SQL)
      • HEX: Converting to Hexadecimal
      • IF: Testing a Condition
      • LENGTH: Obtaining the Physical Length of a Data Item
      • VALUE: Coalescing Data Values
    • SQL Operators
      • CASE: SQL Case Operator
      • COALESCE: Coalescing Data Values
      • NULLIF: NULLIF Operator
  • IWAF Adapter for Salesforce
    • Launch PDF file
    • Introducing the IWAF Adapter for Salesforce
      • Features of the IWAF Adapter for Salesforce
      • Component Information for the IWAF Adapter for Salesforce
    • Getting Started With Salesforce
      • Prerequisites
    • Creating Metadata for Salesforce
      • Configuring the Salesforce Service Adapter
      • Adding an Adapter and Connection to a Salesforce Service
      • Adding an Adapter and Connection to a Salesforce Event
      • Creating a Synonym for a Salesforce Service
      • Sample Data From a Salesforce Service
      • Creating a Synonym for a Salesforce Event
    • Joining Salesforce Business Objects
      • Joining Salesforce Business Objects
    • Using DataMigrator to Copy Data from Salesforce
      • Retrieving Data From Salesforce
      • Capturing a Salesforce Event
    • Using WebFOCUS to Report on Data From Salesforce
      • Using InfoAssist to Report From Salesforce
      • Reporting from Salesforce
    • Using DataMigrator to Load Data to Salesforce
      • Creating Procedures to Set All On
      • Load Data Using a Filter
      • Load Data Using a JOIN
      • Viewing What was Loaded
      • Using Upsert
    • Using the Salesforce Bulk API
      • Using the Salesforce Bulk API
      • Creating a Source Data File
      • Creating a Job and Adding a Batch
      • Creating a Flow to Close a Job
      • Creating a Flow to Check Job Status
      • Running a Flow to Load Data
      • Running a Flow to Check Results
      • Getting Results for a Batch
      • Creating a Process Flow
      • Using Upsert
      • Adding Additional Batches to a Job
      • Parameters for Creating a Job
    • Certificate Management
      • Prerequisites
      • Key Store Management
      • Generating the Certificate Signing Request
      • Purchasing the Commercial Certificate From Symantec or a Similar Certificate Authority
      • Importing the Root Certificate and Intermediate Certificate
      • Importing the Signed Certificate
      • Trust Store Management
    • Creating Workflow Rules and Outbound Messages in Salesforce
      • Real Time Event Capture
      • Creating a Workflow Rule
      • Creating Outbound Messages
      • Activate the Rule for the Outbound Message
  • Stored Procedure and Subroutine Reference for 3GL Procedures
    • Launch PDF file
    • Introducing Stored Procedures and Subroutines
      • Using a Stored Procedure
      • Calling a Stored Procedure
      • Stored Procedure Libraries
      • Setting the Execution Order
      • Using a Subroutine
    • Calling a Program as a Stored Procedure
      • Calling a Compiled Program
      • Calling a Program With CALLPGM or EXEC
      • Calling a Program With SQL EX
      • Passing Parameters
      • Program Communication
    • Calling a JAVA Class as a Stored Procedure
      • Execute Using CALLJAVA
      • Execute Using EX
      • Execute Using SQL EX and SQL CPJAVA EX
      • Passing Parameters
      • Writing a JAVA Class
      • JAVA Class Communication
      • Compiling and Running a JAVA Program
    • Writing a 3GL Compiled Stored Procedure Program
      • Program Requirements
      • Setting Up the Control Block
      • Storing Program Values
      • Error Handling
      • Issuing the CREATE TABLE Command
    • User Written Routines
      • Calling a User Written Routine
    • Using the GENCPGM Build Tool
      • Using GENCPGM
    • Additional 3GL Reference Examples
      • Subroutine Source Examples and Runtime Testing
      • MTHNAME C Implementation
      • MTHNAME C++ Implementation
      • MTHNAME Fortran Implementation
      • MTHNAME COBOL Implementation
      • MTHNAME z/OS BAL Assembler Implementation
      • MTHNAME Basic Implementation (Based on HP OpenVMS Basic 1.4)
      • MTHNAME RPG IBM i ILE Implementation
      • MTHNAME PL/1 Implementation
      • MTHNAME Pascal Implementation (Based on HP OpenVMS Pascal 5.8)
      • UREVERSE C Implementation