DataMigrator Server/WebFOCUS Reporting Server Technical Library
  Technical Support
  Technical Support
Release 7706/81
  WebFOCUS Reporting Server
    Server New Features
      Server Enhancements
        Applications
        Configuration and Monitoring
        Core Server and Clients
        Diagnostics
        Metadata
        National Language Support
        Security
        Web Console
      Adapter Enhancements
        All Adapters
        SQL Adapters
        ERP Adapters
        OLAP Adapters
        DBMS Adapters
        Procedures Adapters
        Sequential and Indexed Adapters
        Social Media Adapters
        XML-Based Adapters
      DataMigrator Enhancements
        Check File
        Dependencies Analysis Report
        Updating Synonyms
        Quick ETL Copy
        Copying Selected Columns Using Quick ETL Copy
        Copy Server Node
        Noncontiguous Keys
        Global Variables Editor
        Updates for Type I Fields
        Annotations in Flows
        Finding Text in SQL Object
        Extended Load Bulk Enhancements
        Loading Images From Files
        JSON Document Target
        WHERE Calculator Support for ANY and ALL
        Impact Analysis Enhancements
        Slowly Changing Dimensions
        Extended Bulk Load Utility for MS SQL ODBC Adapter
        Transformation Calculator Enhancements
        New SQL Functions
        Data Profiling Drill-Down Reports for Patterns
        Managing Object Groups In A Flow
        Using Source Control on Multiple Files
        Find Available for Data and Process Flows
        Undo and Redo Capability
        Segment Qualifications in Synonym Editor
        Email File Types for a Process Flow
        Non-Zero Return Code Lines in DataMigrator Log
        ETLLOG Enhancements
        Using SFTP as a Data Source
        Option to Continue Processing on Partial Answer Set
        Allowing Iterator for Non-DataMigrator Jobs
        Support Change Data Capture for MS SQL 2012
        Reading a Field With Delimited Values as Individual Rows
        SCD Type I Flow Updates
        File Types on EDAMAIL or on a Flow
        Display of Long Procedure Names
        Calculate Format for Expression In Transformation Grid
        Specifying USAGE Attributes for Datetime Fields
        Balloon Tips to Show Error or Information Messages
        Batch Command for Data Profiling and Key Analysis
        Source Control File Types
      Resource Analyzer and Resource Governor Enhancements
        New Errors and Messages Report
        Monitoring Commands Enhancements
        Sybase ASA Supported
        Maximum Memory Used for Log File Records
        Enhanced Administration for Thresholds and Business Rules
        Enhanced Governor Business Rules Menu
        Monitored Generated SQL Statements and Aggregation Messages
        New Report to Display All Governor Rule File Properties
      Reporting Language Enhancements
        Controlling Column Title Underlining Using a StyleSheet Attribute
        Rolling Up Calculations on Summary Rows
        Simplified Character Functions
        Simplified Date and Date-Time Functions
        CHECKPRIVS: Retrieving the Privilege State for the Connected User
        Adding a Value Test to RESTRICT=NOPRINT
        Using ACCEPT=SYNONYM in a Master File
        Using Multiple Prefix Operators on the Same Measure in SUBTOTAL
        Validating Parameter Values Without Data File Access: REGEX
        Storing Localized Metadata in Language Files
        Adding DBA Restrictions to the Join Condition
      Launch PDF
    Server Release Notes
      Disabling the CSRF Token When Connecting From a Release 8.0.x Client
      General Information
      Adapter for ESSBASE
      Adapter for Netezza
      Adapter for MQSeries
      Adapter for Red Brick
      Adapter for JBoss
      Adapter for Oracle
      Adapter for Informix
      Adapter for DB2 on IBM i
      Adapter for JDBC
      Adapter for PeopleSoft
      Adapter for SQL Server Analysis Services (SSAS)
      Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
      JVM Requirements for Java Services
      Connector for OLE DB
      Resource Analyzer
      Run With Options Changed to Submit With E-Mail
      Running or Sharing 7.7.x and 7.6.x on the Same Machine
      New CMRUN Executable
      Platform Support
      Active Technologies
      Reporting Language
      Server Security
      Launch PDF
    Adapter Administration
      Introduction to Adapters
        Processing Requests
        Functions of an Adapter
        Data Management
        Metadata Services With SQLENGINE SET
        Additional Master File Attributes
      Using the Adapter for 1010data
        Configuring the Adapter for 1010data
        Managing 1010data Metadata
        Customizing the 1010data Environment
        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
        Overview
        Configuring the Alchemy Sentiment Analysis Adapter
        Creating Metadata and Sample Reports for the Alchemy Adapter
        Examples
      Using the Adapter for Axiom EPM
        Preparing the 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
        Configuring the Adapter for Caché
        Managing Caché Metadata
        Customizing the Caché Environment
        Optimization Settings
      Using the Adapter for CICS Transactions
        Preparing the CICS Environment
        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 Adapters for C-ISAM and ISAM
        Preparing the Environment
        Configuring the Adapter
        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
        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
        Standard Master File Attributes for a DB Heritage Files Data Source
        Redefining a Field in a DB Heritage Files Data Source
        Extra-Large Record Length Support
        Describing Multiple Record Types
        Combining Multiply-Occurring Fields and Multiple Record Types
        Multi-Format Logical Files
        DB Heritage Files Record Selection Efficiencies
      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 Excel
        Configuring the Adapter for Excel
        Managing Excel Metadata
        Customizing the Excel Environment
        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
        Overview
        Creating a Facebook Application
        Configuring the Facebook Adapter
        Creating Metadata and Sample Reports for the Facebook Adapter
        Examples
      Using the Adapters for Flat and Delimited Flat Files
        Preparing the Environment
        Configuring the Adapters for Flat and Delimited Flat Files
        Managing Metadata for Flat and Delimited Flat Files
      Using the Adapter for Google Analytics
        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 Greenplum
        Configuring the Adapter for Greenplum
        Managing Greenplum Metadata
      Using the Adapter for Hadoop with Apache Hive and Cloudera Impala
        Introducing the Adapter for Apache Hive and Cloudera Impala
        Preparing the Environment
        Configuring the Adapter for Hadoop/Hive/Impala
        Creating Synonyms
        Using Direct Pass-through
        Loading Data Using DataMigrator
      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
        Optimization Settings
      Using the Adapter for Hyperstage
        Preparing the Hyperstage Environment
        Configuring the Adapter for Hyperstage
        Managing Hyperstage Metadata
        Customizing the Adapter for the Hyperstage Environment
        Optimization Settings
      Using the Adapter for i Access
        Preparing the i Access Environment
        Configuring the Adapter for i Access
        Managing i Access Metadata
        Customizing the i Access Environment
        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
        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 (DBCTL)
        Migrating From an Existing MVS Server (DBCTL)
        WebFOCUS Reporting With IMS
        Maintaining IMS Data Sources (DBCTL)
      Using the Adapter for IMS Transactions
        Preparing the IMS Transactions Environment
        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
        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
        Optimization Settings
      Using the Adapter for Interplex
        Preparing the Interplex Environment
        Configuring the Adapter for Interplex
        Managing Interplex Metadata
        Customizing the Interplex Environment
        Optimization Settings
      Using the Adapter for iWay Adapter Framework (IWAF)
        Preparing the IWAF Environment
        Configuring the Adapter for IWAF
        Creating Synonyms
      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
        Optimization Settings
      Using the Adapter for JDBC
        Preparing the JDBC Environment
        Configuring the Adapter for JDBC
        Managing JDBC Metadata
        Customizing the JDBC Environment
        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 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
        Overview
        Creating a LinkedIn Application
        Configuring the LinkedIn Adapter
        Creating Metadata and Sample Reports for the 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 Microsoft Access
        Preparing the Microsoft Access Environment
        Configuring the Adapter for Microsoft Access
        Managing Microsoft Access Metadata
        Customizing the Microsoft Access Environment
        Optimization Settings
      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
        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 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
        Optimization Settings
        Calling a Microsoft SQL Server 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
        Introducing the Adapter for MongoDB
        Preparing the Environment
        Configuring the Adapter for MongoDB
        Creating Synonyms
        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
        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 CICS Environment
        Supported Platforms and Release Information
        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
        Configuring the Adapter for Netezza
        Managing Netezza Metadata
        Customizing the Netezza Environment
        Optimization Settings
      Using the Adapter for Nucleus
        Preparing the Nucleus Environment
        Configuring the Adapter for Nucleus
        Managing Nucleus Metadata
        Customizing the Nucleus Environment
        Optimization Settings
      Using the Adapter for ODBC
        Preparing the ODBC Environment
        Configuring the Adapter for ODBC
        Managing ODBC Metadata
        Customizing the ODBC Environment
        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
        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
        Optimization Settings
      Using the Adapter for parAccel
        Configuring the Adapter for parAccel
        Managing parAccel Metadata
      Using the Adapter for PeopleSoft
        Preparing the 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
        Advanced Administrative Topics
      Using the Adapter for PostgreSQL
        Preparing the PostgreSQL Environment
        Configuring the Adapter for PostgreSQL
        Managing PostgreSQL Metadata
        Customizing the PostgreSQL Environment
        Optimization Settings
      Using the Adapter for Progress
        Preparing the Progress Environment
        Configuring the Adapter for Progress
        Managing Progress Metadata
        Customizing the Progress Environment
        Optimization Settings
      Using the Adapter for PSQL
        Preparing the PSQL Environment
        Configuring the Adapter for PSQL
        Managing PSQL Metadata
        Customizing the PSQL Environment
        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
        Optimization Settings
      Using the Adapter for REST
        Configuring the Adapter for REST
        Managing RESTful Web Services Metadata
      Using the Adapter for Remote Servers
        Configuring Remote Servers
        Managing Metadata for Remote Servers
        Executing Stored Procedures
      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
        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 Salesforce.com
        Configuring the Adapter for Salesforce.com
        Creating Synonyms
      Using the Adapter for SAP Business Intelligence Warehouse (BW)
        Preparing the SAP BW Environment
        Configuring the Adapter for SAP BW
        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
        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
        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
        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
        Optimization Settings
      Using the Adapter for SQLBase
        Preparing the SQLBase Environment
        Configuring the Adapter for SQLBase
        Managing SQLBase Metadata
        Customizing the SQLBase Environment
        Optimization Settings
      Using the Adapter for SQL Server Analysis Services (SSAS)
        Preparing the SQL Server Analysis Services (SSAS) Environment
        Configuring the Adapter for SQL Server Analysis Services
        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
        Configuring the Adapter for Sybase
        Managing Sybase Metadata
        Reporting Against a Sybase Stored Procedure
        Customizing the Sybase Environment
        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
        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
        Optimization Settings
      Using the Adapter for Twitter
        Overview
        Creating a Twitter Application
        Configuring the Twitter Adapter
        Creating Metadata and Sample Reports for the Twitter Adapter
        Examples
      Using the Adapter for UniData
        Preparing the UniData Environment
        Configuring the Adapter for UniData
        Managing UniData Metadata
        Customizing the UniData Environment
        Optimization Settings
      Using the Adapter for UniVerse
        Preparing the UniVerse Environment
        Configuring the Adapter for UniVerse
        Managing UniVerse Metadata
        Customizing the UniVerse Environment
        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
        Describing Multiple Record Types
        Combining Multiply-Occurring Fields and Multiple Record Types
        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
        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
        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 Words Analysis
        Overview
        Configuring the Words Analysis Adapter
        Creating Metadata and Sample Reports for the Words Analysis Adapter
        Examples
      Using the Adapter for XML
        Preparing the XML Environment
        Configuring the Adapter for XML
        Managing XML Metadata
      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
      Launch PDF
    Server Administration
      Server Introduction
        Using the Web Console
        Console Options
        Other Icon Options
        Configuration Overview
        Running and Configuring the FOCUS Database and FOCUS Database Server
        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
        Help Information: 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
      Data Adapters
        Changing Common Adapter Settings
        Configuring an Adapter
        Changing the Adapter Configuration
        Configuring a Remote Server
        SQL Automatic Passthru Status
        Determining SQL Optimization
        Determining Function Parameters
        Data Type Support Report
        Social Media Adapters
      Metadata
        Creating Synonyms
        Testing Synonyms
        Managing Synonyms
        Using the Wizards
      Stored Procedures
        Working With Stored Procedures
        Creating a Stored Procedure
        Sending Stored Procedure Report Output to Server-Side Printers
        Editing a Stored Procedure
        Running a Stored Procedure
        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
      Launch PDF
    Server Installation
      Introduction to Installation
        Versions
        What to Read After You Install
      Installation for Windows
        Installation Requirements
        Accessing the Software
        Installing
        Installation and Configuration Directories
        Verifying Installation
        Starting and Using a Server or Data Management Console
        Security Providers
        Additional Installation Options
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a Windows Installation
        Troubleshooting for Windows
      Installation for UNIX
        Installation Requirements
        Installation and Configuration Directories
        Installing
        Verifying Installation
        Security Providers
        Starting and Using a Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a UNIX Installation
        Troubleshooting for UNIX
      Installation for z/OS
        Installation for HFS and PDS
        HFS Deployment
        PDS Deployment
      Installation for IBM i
        Step 1. Reviewing System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Installation Program
        Step 5. Verifying the Server Installation
        Step 6. Security Providers
        Starting and Using the Server
        CL and CMD Programs
        General Information for an IBM i Installation
        Generating a Trace
        Third-Party Software and Licenses
        Troubleshooting for IBM i
      Installation for OpenVMS
        Step 1. Reviewing System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Setup Procedure
        Step 5. Verifying the Installation
        Step 6. Security Providers
        Starting and Using the Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for an OpenVMS Installation
        Troubleshooting for OpenVMS
      Information Builders and Third-Party Licenses
        Information Builders License
        OpenFlex SDK License
        Zip Archiver License
      Launch PDF
    Stored Procedure Reference for 3GL Procedures
      Introducing Stored Procedures
        Using a Stored Procedure
        Calling a Stored Procedure
        Stored Procedure Libraries
        Setting the Execution Order
      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
      Launch PDF
  Reporting Language
    Creating Reports With WebFOCUS Language
      Creating Reports Overview
        Requirements for Creating a Report
        Report Types
        Reporting Tools
        Developing Your Report Request
        Customizing a Report
        Selecting a Report Output Destination
      Displaying Report Data
        Using Display Commands in a Request
        Displaying Individual Values
        Adding Values
        Counting Values
        Expanding Byte Precision for COUNT and LIST
        Maximum Number of Display Fields Supported in a Request
        Manipulating Display Fields With Prefix Operators
        Displaying Pop-up Field Descriptions for Column Titles
      Sorting Tabular Reports
        Sorting Tabular Reports Overview
        Sorting Rows
        Sorting Columns
        Reformatting Sort Fields
        Manipulating Display Field Values in a Sort Group
        Creating a Matrix Report
        Controlling Collation Sequence
        Specifying the Sort Order
        Ranking Sort Field Values
        Grouping Numeric Data Into Ranges
        Restricting Sort Field Values by Highest/Lowest Rank
        Sorting and Aggregating Report Columns
        Hiding Sort Values
        Sorting With Multiple Display Commands
        Improving Efficiency With External Sorts
        Hierarchical Reporting: BY HIERARCHY
      Selecting Records for Your Report
        Selecting Records Overview
        Choosing a Filtering Method
        Selections Based on Individual Values
        Selection Based on Aggregate Values
        Using Compound Expressions for Record Selection
        Using Operators in Record Selection Tests
        Types of Record Selection Tests
        Selections Based on Group Key Values
        Setting Limits on the Number of Records Read
        Selecting Records Using IF Phrases
        Reading Selection Values From a File
        Assigning Screening Conditions to a File
        VSAM Record Selection Efficiencies
      Creating Temporary Fields
        What Is a Temporary Field?
        Defining a Virtual Field
        Creating a Calculated Value
        Assigning Column Reference Numbers
        Calculating Trends and Predicting Values With FORECAST
        Calculating Trends and Predicting Values With Multivariate REGRESS
        Using Text Fields in DEFINE and COMPUTE
        Creating Temporary Fields Independent of a Master File
      Including Totals and Subtotals
        Calculating Row and Column Totals
        Including Section Totals and a Grand Total
        Including Subtotals
        Recalculating Values for Subtotal Rows
        Summarizing Alphanumeric Columns
        Manipulating Summary Values With Prefix Operators
        Combinations of Summary Commands
        Producing Summary Columns for Horizontal Sort Fields
        Performing Calculations at Sort Field Breaks
        Suppressing Grand Totals
        Conditionally Displaying Summary Lines and Text
      Using Expressions
        Using Expressions in Commands and Phrases
        Types of Expressions
        Creating a Numeric Expression
        Creating a Date Expression
        Creating a Date-Time Expression
        Creating a Character Expression
        Creating a Variable Length Character Expression
        Creating a Logical Expression
        Creating a Conditional Expression
      Saving and Reusing Your Report Output
        Saving Your Report Output
        Creating a HOLD File
        Holding Report Output in FOCUS Format
        Controlling Attributes in HOLD Master Files
        Keyed Retrieval From HOLD Files
        Saving and Retrieving HOLD Files
        Using DBMS Temporary Tables as HOLD Files
        Creating SAVE and SAVB Files
        Creating a PCHOLD File
        Choosing Output File Formats
        Using Text Fields in Output Files
        Creating a Delimited Sequential File
        Saving Report Output in INTERNAL Format
        Creating A Subquery or Sequential File With HOLD FORMAT SQL_SCRIPT
        Creating a Structured HOLD File
        Specifying MIME Types for WebFOCUS Reports
      Choosing a Display Format
        Report Display Formats
        Preserving Leading and Internal Blanks in Report Output
        Using Web Display Format: HTML
        Using Print Display Formats: PDF, PS
        Using Word Processing Display Formats: DOC, WP
        Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL
        Using PowerPoint PPT Display Format
        Using PowerPoint PPTX Display Format
      Linking a Report to Other Resources
        Linking Using StyleSheets
        Linking to Another Report
        Linking to a URL
        Linking to a JavaScript Function
        Linking to a WebFOCUS Maintain Procedure
        Creating Multiple Drill-Down Links
        Creating Parameters
        Linking With Conditions
        Linking From a Graphic Image
        Specifying a Base URL
        Specifying a Target Frame
        Creating a Compound Report
        Creating a PDF Compound Report With Drill Through Links
      Navigating Within an HTML Report
        Navigating Sort Groups From a Table of Contents
        Adding the HTML Table of Contents Tree Control to Reports
        Controlling the Display of Sorted Data With Accordion Reports
        Navigating a Multi-Page Report With the WebFOCUS Viewer
        Linking Report Pages
      Bursting Reports Into Multiple HTML Files
        Bursting Reports Overview
      Handling Records With Missing Field Values
        Irrelevant Report Data
        Missing Field Values
        Handling a Missing Segment Instance
        Setting the NODATA Character String
      Joining Data Sources
        Types of Joins
        How the JOIN Command Works
        Creating an Equijoin
        Using a Conditional Join
        Full Outer Joins for Relational Data Sources
        Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT
        Joining From a Multi-Fact Synonym
        Invoking Context Analysis for a Star Schema With a Fan Trap
        Adding DBA Restrictions to the Join Condition: SET DBAJOIN
        Preserving Virtual Fields During Join Parsing
        Displaying Joined Structures
        Clearing Joined Structures
      Merging Data Sources
        Merging Data
        MATCH Processing
        MATCH Processing With Common High-Order Sort Fields
        Fine-Tuning MATCH Processing
        Universal Concatenation
        Merging Concatenated Data Sources
        Cartesian Product
      Formatting Reports: An Overview
        What Kinds of Formatting Can I Do?
        How to Specify Formatting in a Report
        Standard and Legacy Formatting
        Techniques for Quick and Easy Formatting
        Navigating From a Report to Other Resources
      Creating and Managing a WebFOCUS StyleSheet
        Creating a WebFOCUS StyleSheet
        General WebFOCUS StyleSheet Syntax
        Reusing WebFOCUS StyleSheet Declarations With Macros
        WebFOCUS StyleSheet Attribute Inheritance
      Controlling Report Formatting
        Generating an Internal Cascading Style Sheet for HTML Reports
        Selecting a Unit of Measurement
        Conditionally Formatting, Displaying, and Linking in a StyleSheet
        Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
        Conditionally Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
        Controlling the Display of Empty Reports
        Formatting a Report Using Only StyleSheet Defaults
      Identifying a Report Component in a WebFOCUS StyleSheet
        Identifying an Entire Report, Column, or Row
        Identifying Tags for SUBTOTAL and GRANDTOTAL Lines
        Identifying Data
        Identifying a Heading, Footing, Title, or FML Free Text
        Identifying a Page Number, Underline, or Skipped Line
      Using an External Cascading Style Sheet
        What Is a Cascading Style Sheet?
        Why Use an External Cascading Style Sheet?
        Formatting a Report With an External Cascading Style Sheet
        Working With an External Cascading Style Sheet
        Applying External Cascading Style Sheet Formatting
        Combining an External CSS With Other Formatting Methods
        Linking to an External Cascading Style Sheet
        Inheritance and External Cascading Style Sheets
        Using External Cascading Style Sheets With Non-HTML Reports
        Requirements for Using an External Cascading Style Sheet
        FAQ About Using External Cascading Style Sheets
        Troubleshooting External Cascading Style Sheets
      Laying Out the Report Page
        Selecting Page Size, Orientation, and Color
        Setting Page Margins
        Positioning a Report Component
        Arranging Columns on a Page
        Suppressing Column Display
        Inserting a Page Break
        Inserting Page Numbers
        Adding Grids and Borders
        Defining Borders Around Boxes With PPTX and PDF Formats
        Displaying Superscripts On Data, Heading, and Footing Lines
        Adding Underlines and Skipped Lines
        Removing Blank Lines From a Report
        Adding an Image to a Report
        Associating Bar Graphs With Report Data
        Working With Mailing Labels and Multi-Pane Pages
      Using Headings, Footings, Titles, and Labels
        Creating Headings and Footings
        Including an Element in a Heading or Footing
        Repeating Headings and Footings on Panels in PDF Report Output
        Customizing a Column Title
        Controlling Column Title Underlining Using a SET Command
        Controlling Column Title Underlining Using a StyleSheet Attribute
        Creating Labels to Identify Data
        Formatting a Heading, Footing, Title, or Label
        Applying Font Attributes to a Heading, Footing, Title, or Label
        Adding Borders and Grid Lines
        Justifying a Heading, Footing, Title, or Label
        Choosing an Alignment Method for Heading and Footing Elements
        Aligning a Heading or Footing Element in an HTML, XLSX, EXL2K, or PDF Report
        Aligning a Heading or Footing Element Across Columns in an HTML or PDF Report
        Aligning Content in a Multi-Line Heading or Footing
        Positioning Headings, Footings, or Items Within Them
        Controlling the Vertical Positioning of a Heading or Footing
        Placing a Report Heading or Footing on Its Own Page
      Formatting Report Data
        Specifying Font Format in a Report
        Specifying Background Color in a Report
        Specifying Data Format in a Report
        Positioning Data in a Report
      Creating a Graph
        Content Analysis: Determining Graphing Objectives
        The GRAPH Command
        Creating an HTML5 Graph
        Selecting a Graph Type
        Selecting Values for the X and Y Axes
        Creating Multiple Graphs
        Plotting Dates in Graphs
        Refining the Data Set For Your Graph
        Displaying Missing Data Values in a Graph
        Applying Conditional Styling to a Graph
        Linking Graphs to Other Resources
        Adding Labels to a Graph
        Applying Custom Styling to a Graph
        Saving a Graph as an Image File
        Printing a Graph
      Creating Financial Reports With Financial Modeling Language (FML)
        Reporting With FML
        Creating Rows From Data
        Supplying Data Directly in a Request
        Performing Inter-Row Calculations
        Referring to Rows in Calculations
        Referring to Columns in Calculations
        Referring to Rows and Columns in Calculations
        Referring to Cells in Calculations
        Using Functions in RECAP Calculations
        Inserting Rows of Free Text
        Adding a Column to an FML Report
        Creating a Recursive Model
        Reporting Dynamically From a Hierarchy
        Customizing a Row Title
        Formatting an FML Report
        Suppressing the Display of Rows
        Saving and Retrieving Intermediate Report Results
        Creating HOLD Files From FML Reports
      Creating a Free-Form Report
        Creating a Free-Form Report
        Designing a Free-Form Report
      Using SQL to Create Reports
        Supported and Unsupported SQL Statements
        Using SQL Translator Commands
        SQL Translator Support for Date, Time, and Timestamp Fields
        Index Optimized Retrieval
        TABLEF Optimization
        SQL INSERT, UPDATE, and DELETE Commands
      Improving Report Processing
        Rotating a Data Structure for Enhanced Retrieval
        Optimizing Retrieval Speed for FOCUS Data Sources
        Automatic Indexed Retrieval
        Data Retrieval Using TABLEF
        Preserving the Internal Matrix of Your Last Report
        Compiling Expressions
      Master Files and Diagrams
        EMPLOYEE Data Source
        JOBFILE Data Source
        EDUCFILE Data Source
        SALES Data Source
        CAR Data Source
        LEDGER Data Source
        FINANCE Data Source
        REGION Data Source
        EMPDATA Data Source
        TRAINING Data Source
        COURSE Data Source
        JOBHIST Data Source
        JOBLIST Data Source
        LOCATOR Data Source
        PERSINFO Data Source
        SALHIST Data Source
        VIDEOTRK, MOVIES, and ITEMS Data Sources
        VIDEOTR2 Data Source
        Gotham Grinds Data Sources
        Century Corp Data Sources
      Error Messages
        Displaying Messages
      Table Syntax Summary and Limits
        TABLE Syntax Summary
        TABLEF Syntax Summary
        MATCH Syntax Summary
        FOR Syntax Summary
        TABLE Limits
      Referring to Fields in a Report Request
        Referring to an Individual Field
        Referring to Fields Using Qualified Field Names
        Referring to All of the Fields in a Segment
        Displaying a List of Field Names
      Launch PDF
    Describing Data With WebFOCUS Language
      Understanding a Data Source Description
        A Note About Data Source Terminology
        What Is a Data Source Description?
        How an Application Uses a Data Source Description
        What Does a Master File Describe?
        Creating a Data Source Description
        Naming a Master File
        What Is in a Master File?
      Identifying a Data Source
        Identifying a Data Source Overview
        Specifying a Data Source Name: FILENAME
        Identifying a Data Source Type: SUFFIX
        Specifying Byte Order
        Specifying Data Type: IOTYPE
        Providing Descriptive Information for a Data Source: REMARKS
        Specifying a Physical File Name: DATASET
        Creating and Using a Master File Profile
      Describing a Group of Fields
        Defining a Single Group of Fields
        Identifying a Logical View: Redefining a Segment
        Relating Multiple Groups of Fields
        Logical Dependence: The Parent-Child Relationship
        Logical Independence: Multiple Paths
        Cardinal Relationships Between Segments
        One-to-One Relationship
        One-to-Many Relationship
        Many-to-Many Relationship
        Recursive Relationships
        Relating Segments From Different Types of Data Sources
        Rotating a Data Source: An Alternate View
      Describing an Individual Field
        Field Characteristics
        The Field Name: FIELDNAME
        The Field Synonym: ALIAS
        The Displayed Data Type: USAGE
        The Stored Data Type: ACTUAL
        Null or MISSING Values: MISSING
        Describing an FML Hierarchy
        Defining a Dimension: WITHIN
        Validating Data: ACCEPT
        Specifying Acceptable Values for a Dimension
        Alternative Report Column Titles: TITLE
        Documenting the Field: DESCRIPTION
        Multilingual Metadata
        Describing a Virtual Field: DEFINE
        Describing a Calculated Value: COMPUTE
        Describing a Filter: FILTER
        Describing a Sort Object: SORTOBJ
        Calling a DEFINE FUNCTION in a Master File
        Using Date System Amper Variables in Master File DEFINEs
        Parameterizing Master and Access File Values Using Variables
        Converting Alphanumeric Dates to WebFOCUS Dates
      Describing a Sequential, VSAM, or ISAM Data Source
        Sequential Data Source Formats
        Standard Master File Attributes for a Sequential Data Source
        Standard Master File Attributes for a VSAM or ISAM Data Source
        Describing a Multiply Occurring Field in a Free-Format Data Source
        Describing a Multiply Occurring Field in a Fixed-Format, VSAM, or ISAM Data Source
        Redefining a Field in a Non-FOCUS Data Source
        Extra-Large Record Length Support
        Describing Multiple Record Types
        Combining Multiply Occurring Fields and Multiple Record Types
        Establishing VSAM Data and Index Buffers
        Using a VSAM Alternate Index
        Describing a Token-Delimited Data Source
      Describing a FOCUS Data Source
        Types of FOCUS Data Sources
        Designing a FOCUS Data Source
        Describing a Single Segment
        GROUP Attribute
        ACCEPT Attribute
        INDEX Attribute
        Describing a Partitioned FOCUS Data Source
        Multi-Dimensional Index (MDI)
      Defining a Join in a Master File
        Join Types
        Static Joins Defined in the Master File: SEGTYPE = KU and KM
        Using Cross-Referenced Descendant Segments: SEGTYPE = KL and KLU
        Dynamic Joins Defined in the Master File: SEGTYPE = DKU and DKM
        Conditional Joins in the Master File
        Comparing Static and Dynamic Joins
        Joining to One Cross-Referenced Segment From Several Host Segments
        Creating a Cluster Master File
      Creating a Business View of a Master File
        Grouping Business Logic In a Business View
      Checking and Changing a Master File: CHECK
        Checking a Data Source Description
        CHECK Command Display
        PICTURE Option
        HOLD Option
      Providing Data Source Security: DBA
        Introduction to Data Source Security
        Implementing Data Source Security
        Specifying an Access Type: The ACCESS Attribute
        Limiting Data Source Access: The RESTRICT Attribute
        Controlling the Source of Access Restrictions in a Multi-file Structure
        Adding DBA Restrictions to the Join Condition
        Placing Security Information in a Central Master File
        Summary of Security Attributes
        Hiding Restriction Rules: The ENCRYPT Command
        FOCEXEC Security
      Creating and Rebuilding a Data Source
        Creating a New Data Source: The CREATE Command
        Rebuilding a Data Source: The REBUILD Command
        Optimizing File Size: The REBUILD Subcommand
        Changing Data Source Structure: The REORG Subcommand
        Indexing Fields: The INDEX Subcommand
        Creating an External Index: The EXTERNAL INDEX Subcommand
        Checking Data Source Integrity: The CHECK Subcommand
        Changing the Data Source Creation Date and Time: The TIMESTAMP Subcommand
        Converting Legacy Dates: The DATE NEW Subcommand
        Creating a Multi-Dimensional Index: The MDINDEX Subcommand
      Master Files and Diagrams
        EMPLOYEE Data Source
        JOBFILE Data Source
        EDUCFILE Data Source
        SALES Data Source
        CAR Data Source
        LEDGER Data Source
        FINANCE Data Source
        REGION Data Source
        EMPDATA Data Source
        TRAINING Data Source
        COURSE Data Source
        JOBHIST Data Source
        JOBLIST Data Source
        LOCATOR Data Source
        PERSINFO Data Source
        SALHIST Data Source
        VIDEOTRK, MOVIES, and ITEMS Data Sources
        VIDEOTR2 Data Source
        Gotham Grinds Data Sources
        Century Corp Data Sources
      Error Messages
        Displaying Messages
      Launch PDF
    Developing Reporting Applications
      WebFOCUS Application Logic
        Three-Tier Application Logic
        Deploying a Partitioned Project
        WebFOCUS Components
        Storing and Searching for Application Files
        Section 508 Accessibility in WebFOCUS
      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
        Help Information: 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
      Coding a User Interface
        Which Tools Can You Use?
        The WebFOCUS Client
        Using the Servlet
        Using a Dynamic Multiselect Drop-Down List
        Enabling Ad Hoc Reporting
        Validating a Form With JavaScript
        Amper Auto-Prompting
        Displaying a Report on the Default WebFOCUS Page
        Designing an HTML Page for Report Display
      Enhancing a User Interface
        Displaying a Report in a Helper Application
        Controlling Multiple Reports
        Adding JavaScript for Drill-Down Reporting
        Facilitating Report Manipulation
        Using a Cascading Style Sheet to Standardize Display
        Displaying a Previously Run Report
        Passing a User ID From HTML for a Custom Menu
      Managing Flow of Control in an Application
        Uses for Dialogue Manager
        Dialogue Manager Processing
        Creating a Dialogue Manager Procedure
        Customizing a Procedure With Variables
        Creating a Standard Quote-Delimited String
        Creating and Working With Variables
        Using Numeric Amper Variables in Functions
        Controlling the Execution of a Procedure
        Navigating a Procedure
        Enhancing an HTML Webpage With a Procedure
        Issuing Operating System Commands
        Controlling Passwords With Dialogue Manager
        Sending a Message to the Application
        Testing and Debugging a Dialogue Manager Procedure
        Dialogue Manager Process Flow in the Procedure Viewer
        Dialogue Manager Syntax Reference
      Testing and Debugging a Procedure
        Debugging Your Application With Query Commands
        Displaying Combined Structures
        Displaying Virtual Fields
        Displaying the Currency Data Source in Effect
        Displaying Available Fields
        Displaying the File Directory Table
        Displaying Field Information for a Master File
        Displaying Data Source Statistics
        Displaying Current ddnames Assigned With FILEDEF
        Displaying Defined Functions
        Displaying HOLD Fields
        Displaying JOIN Structures
        Displaying National Language Support
        Displaying Explanations of Error Messages
        Displaying the Current Search Path
        Displaying the Release Number
        Displaying the Values of a Remote Server
        Displaying Parameter Settings
        Displaying Parameters That Cannot Be Set in an Area
        Displaying Graph Parameters
        Displaying the Site Code of the Connected Server
        Displaying Command Statistics
        Displaying StyleSheet Parameter Settings
        Displaying Information About the SU Machine
        Displaying Data Sources Specified With USE
        Displaying Global Variable Values
        Identifying the Files Being Used
      Managing the WebFOCUS Environment
        Setting Up a WebFOCUS Environment
        Refreshing or Removing an Environment
      Accessing a FOCUS Data Source
        The USE Command
        The Developer Studio Use Tool
        Identifying a FOCUS Data Source
        Using Alternative File Specifications
        Identifying a New Data Source
        Protecting a Data Source
        Concatenating Data Sources
        Displaying the Current USE Options
        Clearing the USE Options
      Customizing Your Environment
        When Do You Use the SET Command?
        Ways to Issue a SET Command
        Issuing a SET Command With the Set Tool
        Coding a SET Command
        Types of SET Parameters
        SET Parameter Syntax
      Defining and Allocating WebFOCUS Files
        Allocating WebFOCUS Files
        Application Files Under Windows
        Extract Files Under Windows
        Work Files Under Windows
        Determining If A File Exists Under Windows
        WebFOCUS Files Under MVS
        Application Files Under MVS
        Extract Files Under MVS
        Work Files Under MVS
        Reviewing Attributes of Allocated Files Under MVS
        Application Files Under UNIX
        Extract Files Under UNIX
        Work Files Under UNIX
        Determining If A File Exists Under UNIX
      Using the Command Console
        Command Console Window
        Working in the Command Console
      Euro Currency Support
        Integrating the Euro Currency
        Converting Currencies
        Creating the Currency Data Source
        Identifying Fields That Contain Currency Data
        Activating the Currency Data Source
        Processing Currency Data
        Querying the Currency Data Source in Effect
        Punctuating Numbers
        Selecting an Extended Currency Symbol
      Launch PDF
    Using Functions
      How to Use This Manual
        Available Languages
        Operating Systems
      Introducing Functions
        Using Functions
        Types of Functions
        Character Chart for ASCII and EBCDIC
      Accessing and Calling a Function
        Calling a Function
        Supplying an Argument in a Function
        Calling a Function From a DEFINE, COMPUTE, or VALIDATE Command
        Calling a Function From a Dialogue Manager Command
        Calling a Function From Another Function
        Calling a Function in WHERE or IF Criteria
        Calling a Function in WHEN Criteria
        Calling a Function From a RECAP Command
        Storing and Accessing an External Function
      Character Functions
        Character Function Notes
        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
      Simplified Character Functions
        CHAR_LENGTH: Returning the Length in Characters of a String
        DIGITS: Converting a Number to a Character String
        LOWER: Returning a String With All Letters Lowercase
        LPAD: Left-Padding a Character String
        LTRIM: Removing Blanks From the Left End of a String
        POSITION: Returning the First Position of a Substring in a Source String
        RPAD: Right-Padding a Character String
        RTRIM: Removing Blanks From the Right End of 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 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
      Maintain-specific Character Functions
        CHAR2INT: Translating a Character Into an Integer Value
        INT2CHAR: Translating an Integer Value Into a Character
        LCWORD and LCWORD2: Converting a Character String to Mixed-Case
        LENGTH: Determining the Length of a Character String
        LJUST: Left-Justifying a Character String (Maintain)
        LOWER: Converting a Character String to Lowercase
        MASK: Extracting or Adding Characters
        MNTGETTOK: Extracting Tokens From a String Function
        NLSCHR: Converting Characters From the Native English Code Page
        OVRLAY: Overlaying a Character String (Maintain)
        POSIT: Finding the Beginning of a Substring (Maintain)
        RJUST: Right-Justifying a Character String (Maintain)
        SELECTS: Decoding a Value From a Stack
        STRAN: Substituting One Substring for Another
        STRCMP: Comparing Character Strings
        STRICMP: Comparing Character Strings and Ignoring Case
        STRNCMP: Comparing Character Substrings
        STRTOKEN: Extracting a Substring Based on Delimiters
        SUBSTR: Extracting a Substring (Maintain)
        TRIM: Removing Trailing Occurrences (Maintain)
        TRIMLEN: Determining the Length of a String Excluding Trailing Spaces
        UPCASE: Converting Text to Uppercase (Maintain)
      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
      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
        DPART: Extracting a Component From a Date
        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
        CVTSTIME: Converting the System Date and Time (OpenVMS Only)
        GETSTIME: Extracting the System Date and Time (OpenVMS Only)
        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
        HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
        HGETC: Storing the Current 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
        HMASK: Extracting Date-Time Components and Preserving Remaining Components
        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 or TIMETOTS: Converting a Time to a Timestamp
        HYYWD: Returning the Year and Week Number From a Date-Time Value
        WRTSTIME: Converting Dates to 64-Bit DEC Date/Time Format (OpenVMS Only)
      Simplified Date and Date-Time Functions
        DTADD: Incrementing a Date or Date-Time Component
        DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
        DTPART: Returning a Date or Date-Time Component in Integer Format
        DTRUNC: Returning the Start of a Date Period for a Given Date
      Maintain-specific Date and Time Functions
        Maintain-specific Standard Date and Time Functions
      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 Binary Integer 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
      Maintain-specific Light Update Support Functions
        IWC.FindAppCGIValue: Retrieving a WebFOCUS Parameter or Variable Value
        IWC.GetAppCGIValue: Importing a WebFOCUS Parameter or Variable
      Numeric Functions
        ABS: Calculating Absolute Value
        ASIS: Distinguishing Blank From Zero
        BAR: Producing a Bar Chart
        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
        FMLINFO: Returning FOR Values
        FMLLIST: Returning an FML Tag List
        FMLFOR: Retrieving FML Tag Values
        FMLCAP: Retrieving FML Hierarchy Captions
        INT: Finding the Greatest Integer
        LOG: Calculating the Natural Logarithm
        MAX and MIN: Finding the Maximum or Minimum Value
        MIRR: Calculating the Modified Internal Return Rate
        NORMSDST and NORMSINV: Calculating Normal Distributions
        PRDNOR and PRDUNI: Generating Reproducible Random Numbers
        RDNORM and RDUNIF: Generating Random Numbers
        SQRT: Calculating the Square Root
        XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
      Maintain-specific Script Functions
        IWCLink: Displaying a URL in a Browser or Frame
        IWCSwitchToSecure and IWCSwitchToUnsecure: Turning the Secure Sockets Layer On and Off
        IWCTrigger: Calling a Maintain Function From a Script Handler
        IWC.FindAppCGIValue: Finding a WebFOCUS Parameter or Variable Value
        IWC.GetAppCGIValue: Retrieving a WebFOCUS Parameter or Variable
      System Functions
        CHECKPRIVS: Retrieving the Privilege State for the Connected User
        CLSDDREC: Closing All Files Opened by the PUTDDREC Function
        FEXERR: Retrieving an Error Message
        FGETENV: Retrieving the Value of an Environment Variable
        FINDMEM: Finding a Member of a Partitioned Data Set
        FPUTENV: Assigning a Value to an Environment Variable
        GETCOOKI: Retrieving a Browser Cookie Value
        GETHEADR: Retrieving an HTTP Header Variable
        GETPDS: Determining If a Member of a Partitioned Data Set Exists
        GETUSER: Retrieving a User ID
        GRPLIST: Retrieving the Group List of the Connected User
        JOBNAME: Retrieving the Current Process Identification String
        MVSDYNAM: Passing a DYNAM Command to the Command Processor
        PUTCOOKI: Submitting a Value to a Browser Cookie
        PUTDDREC: Writing a Character String as a Record in a Sequential File
        SLEEP: Suspending Execution for a Given Number of Seconds
        SPAWN: Creating a Subprocess From a Procedure
        SYSTEM: Calling a System Program
        SYSVAR: Retrieving the Value of a z/OS System Variable
      Creating a Subroutine
        Writing a Subroutine
        Compiling and Storing a Subroutine
        Testing the Subroutine
        Using a Custom Subroutine: The MTHNAM Subroutine
        Subroutines Written in REXX
      Launch PDF
  DataMigrator Functions
  DataMigrator User's Guide
    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, 5.3, 7.1, or 7.6
    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 ETL 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, Enhancing, and Editing 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
    Change Data Capture
      Enabling the Database for Logging in Relational Databases
      Enabling the Database for Logging in VSAM
      Properties of a Table Log Record Synonym
      Tutorial: Using Change Data Capture with Relational Databases
      Tutorial: Using Change Data Capture With VSAM
    DataMigrator Log Statistics and Tables
      Log and Statistics Tables
    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
      Using a Source Control System to Manage Procedures and Synonyms
    Launch PDF
  Resource Analyzer Administrator's and User's Manual
    What Is Resource Analyzer?
      Resource Analyzer Overview
      Resource Analyzer for Decision Support Analysis
      Uses for Resource Analyzer: Performance Analysis
      Introduction to Data Access and Performance Analysis With Resource Analyzer
      Sample Data Access Questions
      How Resource Analyzer Works
      Software Prerequisites
      Overview of the Web Console
      Overview of Reporting With Resource Analyzer
      Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
    Configuring and Administering Resource Management
      Resource Management Interface
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Resource Analyzer Report Options
      Reports Overview
      Resource Analyzer Reporting
      Resource Analyzer Report Options
      General Reports
      Resource Analyzer Reports
    Getting Help
      Resource Management Administration Help
      Reporting Application Context-Sensitive Help From Reports
    Administrative Usage Monitoring Tables Column Descriptions
      Administrative Tables (RMLSYS.MAS)
      Usage Monitoring Table (RMLDB.MAS)
      Usage Monitoring RDBMS Table Sizing
      Renamed or Moved Columns
    Using DDL Statements to Create the Internal Tables
      Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
    Launch PDF
  Resource Governor Administrator's and User's Manual
     What Is Resource Governor?
      Resource Governor Overview
      Resource Governor Features
      Resource Governor Operations
      How Resource Governor Works
      Resource Governor Usage Monitoring
    Configuring and Administering Resource Management
      Resource Management Interface
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Rules Files and Knowledge Bases
      Overview
      Working With Business Rules
      Working with Resource Thresholds
      Working with Knowledge Bases
      Maintaining Knowledge Bases
    Resource Governor Report Options
      Reports Overview
      Resource Governor Reporting
      Resource Governor Report Options
      General Reports
      Resource Governor Reports
    Getting Help
      Resource Management Administration Help
      Reporting Application Context-Sensitive Help From Reports
    Administrative Usage Monitoring Tables Column Descriptions
      Administrative Tables (RMLSYS.MAS)
      Usage Monitoring Table (RMLDB.MAS)
      Usage Monitoring RDBMS Table Sizing
      Renamed or Moved Columns
    Using DDL Statements to Create the Internal Tables
      Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
    Business Rule Language (BRL)
      Using Business Rule Language (BRL)
      BRL Factual Information
      BRL Keywords
      Pre-defined Variables
      Internal Functions
      Customized Rule Examples
    Launch PDF
  WebFOCUS Reporting Server
    Server New Features
      Server Enhancements
        Applications
        Configuration and Monitoring
        Core Server and Clients
        Diagnostics
        Metadata
        National Language Support
        Security
        Web Console
      Adapter Enhancements
        All Adapters
        SQL Adapters
        ERP Adapters
        OLAP Adapters
        DBMS Adapters
        Procedures Adapters
        Sequential and Indexed Adapters
        Social Media Adapters
        XML-Based Adapters
      DataMigrator Enhancements
        Check File
        Dependencies Analysis Report
        Updating Synonyms
        Quick ETL Copy
        Copying Selected Columns Using Quick ETL Copy
        Copy Server Node
        Noncontiguous Keys
        Global Variables Editor
        Updates for Type I Fields
        Annotations in Flows
        Finding Text in SQL Object
        Extended Load Bulk Enhancements
        Loading Images From Files
        JSON Document Target
        WHERE Calculator Support for ANY and ALL
        Impact Analysis Enhancements
        Slowly Changing Dimensions
        Extended Bulk Load Utility for MS SQL ODBC Adapter
        Transformation Calculator Enhancements
        New SQL Functions
        Data Profiling Drill-Down Reports for Patterns
        Managing Object Groups In A Flow
        Using Source Control on Multiple Files
        Find Available for Data and Process Flows
        Undo and Redo Capability
        Segment Qualifications in Synonym Editor
        Email File Types for a Process Flow
        Non-Zero Return Code Lines in DataMigrator Log
        ETLLOG Enhancements
        Using SFTP as a Data Source
        Option to Continue Processing on Partial Answer Set
        Allowing Iterator for Non-DataMigrator Jobs
        Support Change Data Capture for MS SQL 2012
        Reading a Field With Delimited Values as Individual Rows
        SCD Type I Flow Updates
        File Types on EDAMAIL or on a Flow
        Display of Long Procedure Names
        Calculate Format for Expression In Transformation Grid
        Specifying USAGE Attributes for Datetime Fields
        Balloon Tips to Show Error or Information Messages
        Batch Command for Data Profiling and Key Analysis
        Source Control File Types
      Resource Analyzer and Resource Governor Enhancements
        New Errors and Messages Report
        Monitoring Commands Enhancements
        Sybase ASA Supported
        Maximum Memory Used for Log File Records
        Enhanced Administration for Thresholds and Business Rules
        Enhanced Governor Business Rules Menu
        Monitored Generated SQL Statements and Aggregation Messages
        New Report to Display All Governor Rule File Properties
      Reporting Language Enhancements
        Controlling Column Title Underlining Using a StyleSheet Attribute
        Rolling Up Calculations on Summary Rows
        Simplified Character Functions
        Simplified Date and Date-Time Functions
        CHECKPRIVS: Retrieving the Privilege State for the Connected User
        Adding a Value Test to RESTRICT=NOPRINT
        Using ACCEPT=SYNONYM in a Master File
        Using Multiple Prefix Operators on the Same Measure in SUBTOTAL
        Validating Parameter Values Without Data File Access: REGEX
        Storing Localized Metadata in Language Files
        Adding DBA Restrictions to the Join Condition
      Launch PDF
    Server Release Notes
      Disabling the CSRF Token When Connecting From a Release 8.0.x Client
      General Information
      Adapter for ESSBASE
      Adapter for Netezza
      Adapter for MQSeries
      Adapter for Red Brick
      Adapter for JBoss
      Adapter for Oracle
      Adapter for Informix
      Adapter for DB2 on IBM i
      Adapter for JDBC
      Adapter for PeopleSoft
      Adapter for SQL Server Analysis Services (SSAS)
      Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
      JVM Requirements for Java Services
      Connector for OLE DB
      Resource Analyzer
      Run With Options Changed to Submit With E-Mail
      Running or Sharing 7.7.x and 7.6.x on the Same Machine
      New CMRUN Executable
      Platform Support
      Active Technologies
      Reporting Language
      Server Security
      Launch PDF
    Adapter Administration
      Introduction to Adapters
        Processing Requests
        Functions of an Adapter
        Data Management
        Metadata Services With SQLENGINE SET
        Additional Master File Attributes
      Using the Adapter for 1010data
        Configuring the Adapter for 1010data
        Managing 1010data Metadata
        Customizing the 1010data Environment
        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
        Overview
        Configuring the Alchemy Sentiment Analysis Adapter
        Creating Metadata and Sample Reports for the Alchemy Adapter
        Examples
      Using the Adapter for Axiom EPM
        Preparing the 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
        Configuring the Adapter for Caché
        Managing Caché Metadata
        Customizing the Caché Environment
        Optimization Settings
      Using the Adapter for CICS Transactions
        Preparing the CICS Environment
        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 Adapters for C-ISAM and ISAM
        Preparing the Environment
        Configuring the Adapter
        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
        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
        Standard Master File Attributes for a DB Heritage Files Data Source
        Redefining a Field in a DB Heritage Files Data Source
        Extra-Large Record Length Support
        Describing Multiple Record Types
        Combining Multiply-Occurring Fields and Multiple Record Types
        Multi-Format Logical Files
        DB Heritage Files Record Selection Efficiencies
      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 Excel
        Configuring the Adapter for Excel
        Managing Excel Metadata
        Customizing the Excel Environment
        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
        Overview
        Creating a Facebook Application
        Configuring the Facebook Adapter
        Creating Metadata and Sample Reports for the Facebook Adapter
        Examples
      Using the Adapters for Flat and Delimited Flat Files
        Preparing the Environment
        Configuring the Adapters for Flat and Delimited Flat Files
        Managing Metadata for Flat and Delimited Flat Files
      Using the Adapter for Google Analytics
        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 Greenplum
        Configuring the Adapter for Greenplum
        Managing Greenplum Metadata
      Using the Adapter for Hadoop with Apache Hive and Cloudera Impala
        Introducing the Adapter for Apache Hive and Cloudera Impala
        Preparing the Environment
        Configuring the Adapter for Hadoop/Hive/Impala
        Creating Synonyms
        Using Direct Pass-through
        Loading Data Using DataMigrator
      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
        Optimization Settings
      Using the Adapter for Hyperstage
        Preparing the Hyperstage Environment
        Configuring the Adapter for Hyperstage
        Managing Hyperstage Metadata
        Customizing the Adapter for the Hyperstage Environment
        Optimization Settings
      Using the Adapter for i Access
        Preparing the i Access Environment
        Configuring the Adapter for i Access
        Managing i Access Metadata
        Customizing the i Access Environment
        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
        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 (DBCTL)
        Migrating From an Existing MVS Server (DBCTL)
        WebFOCUS Reporting With IMS
        Maintaining IMS Data Sources (DBCTL)
      Using the Adapter for IMS Transactions
        Preparing the IMS Transactions Environment
        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
        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
        Optimization Settings
      Using the Adapter for Interplex
        Preparing the Interplex Environment
        Configuring the Adapter for Interplex
        Managing Interplex Metadata
        Customizing the Interplex Environment
        Optimization Settings
      Using the Adapter for iWay Adapter Framework (IWAF)
        Preparing the IWAF Environment
        Configuring the Adapter for IWAF
        Creating Synonyms
      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
        Optimization Settings
      Using the Adapter for JDBC
        Preparing the JDBC Environment
        Configuring the Adapter for JDBC
        Managing JDBC Metadata
        Customizing the JDBC Environment
        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 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
        Overview
        Creating a LinkedIn Application
        Configuring the LinkedIn Adapter
        Creating Metadata and Sample Reports for the 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 Microsoft Access
        Preparing the Microsoft Access Environment
        Configuring the Adapter for Microsoft Access
        Managing Microsoft Access Metadata
        Customizing the Microsoft Access Environment
        Optimization Settings
      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
        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 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
        Optimization Settings
        Calling a Microsoft SQL Server 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
        Introducing the Adapter for MongoDB
        Preparing the Environment
        Configuring the Adapter for MongoDB
        Creating Synonyms
        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
        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 CICS Environment
        Supported Platforms and Release Information
        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
        Configuring the Adapter for Netezza
        Managing Netezza Metadata
        Customizing the Netezza Environment
        Optimization Settings
      Using the Adapter for Nucleus
        Preparing the Nucleus Environment
        Configuring the Adapter for Nucleus
        Managing Nucleus Metadata
        Customizing the Nucleus Environment
        Optimization Settings
      Using the Adapter for ODBC
        Preparing the ODBC Environment
        Configuring the Adapter for ODBC
        Managing ODBC Metadata
        Customizing the ODBC Environment
        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
        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
        Optimization Settings
      Using the Adapter for parAccel
        Configuring the Adapter for parAccel
        Managing parAccel Metadata
      Using the Adapter for PeopleSoft
        Preparing the 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
        Advanced Administrative Topics
      Using the Adapter for PostgreSQL
        Preparing the PostgreSQL Environment
        Configuring the Adapter for PostgreSQL
        Managing PostgreSQL Metadata
        Customizing the PostgreSQL Environment
        Optimization Settings
      Using the Adapter for Progress
        Preparing the Progress Environment
        Configuring the Adapter for Progress
        Managing Progress Metadata
        Customizing the Progress Environment
        Optimization Settings
      Using the Adapter for PSQL
        Preparing the PSQL Environment
        Configuring the Adapter for PSQL
        Managing PSQL Metadata
        Customizing the PSQL Environment
        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
        Optimization Settings
      Using the Adapter for REST
        Configuring the Adapter for REST
        Managing RESTful Web Services Metadata
      Using the Adapter for Remote Servers
        Configuring Remote Servers
        Managing Metadata for Remote Servers
        Executing Stored Procedures
      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
        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 Salesforce.com
        Configuring the Adapter for Salesforce.com
        Creating Synonyms
      Using the Adapter for SAP Business Intelligence Warehouse (BW)
        Preparing the SAP BW Environment
        Configuring the Adapter for SAP BW
        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
        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
        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
        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
        Optimization Settings
      Using the Adapter for SQLBase
        Preparing the SQLBase Environment
        Configuring the Adapter for SQLBase
        Managing SQLBase Metadata
        Customizing the SQLBase Environment
        Optimization Settings
      Using the Adapter for SQL Server Analysis Services (SSAS)
        Preparing the SQL Server Analysis Services (SSAS) Environment
        Configuring the Adapter for SQL Server Analysis Services
        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
        Configuring the Adapter for Sybase
        Managing Sybase Metadata
        Reporting Against a Sybase Stored Procedure
        Customizing the Sybase Environment
        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
        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
        Optimization Settings
      Using the Adapter for Twitter
        Overview
        Creating a Twitter Application
        Configuring the Twitter Adapter
        Creating Metadata and Sample Reports for the Twitter Adapter
        Examples
      Using the Adapter for UniData
        Preparing the UniData Environment
        Configuring the Adapter for UniData
        Managing UniData Metadata
        Customizing the UniData Environment
        Optimization Settings
      Using the Adapter for UniVerse
        Preparing the UniVerse Environment
        Configuring the Adapter for UniVerse
        Managing UniVerse Metadata
        Customizing the UniVerse Environment
        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
        Describing Multiple Record Types
        Combining Multiply-Occurring Fields and Multiple Record Types
        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
        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
        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 Words Analysis
        Overview
        Configuring the Words Analysis Adapter
        Creating Metadata and Sample Reports for the Words Analysis Adapter
        Examples
      Using the Adapter for XML
        Preparing the XML Environment
        Configuring the Adapter for XML
        Managing XML Metadata
      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
      Launch PDF
    Server Administration
      Server Introduction
        Using the Web Console
        Console Options
        Other Icon Options
        Configuration Overview
        Running and Configuring the FOCUS Database and FOCUS Database Server
        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
        Help Information: 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
      Data Adapters
        Changing Common Adapter Settings
        Configuring an Adapter
        Changing the Adapter Configuration
        Configuring a Remote Server
        SQL Automatic Passthru Status
        Determining SQL Optimization
        Determining Function Parameters
        Data Type Support Report
        Social Media Adapters
      Metadata
        Creating Synonyms
        Testing Synonyms
        Managing Synonyms
        Using the Wizards
      Stored Procedures
        Working With Stored Procedures
        Creating a Stored Procedure
        Sending Stored Procedure Report Output to Server-Side Printers
        Editing a Stored Procedure
        Running a Stored Procedure
        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
      Launch PDF
    Server Installation
      Introduction to Installation
        Versions
        What to Read After You Install
      Installation for Windows
        Installation Requirements
        Accessing the Software
        Installing
        Installation and Configuration Directories
        Verifying Installation
        Starting and Using a Server or Data Management Console
        Security Providers
        Additional Installation Options
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a Windows Installation
        Troubleshooting for Windows
      Installation for UNIX
        Installation Requirements
        Installation and Configuration Directories
        Installing
        Verifying Installation
        Security Providers
        Starting and Using a Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a UNIX Installation
        Troubleshooting for UNIX
      Installation for z/OS
        Installation for HFS and PDS
        HFS Deployment
        PDS Deployment
      Installation for IBM i
        Step 1. Reviewing System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Installation Program
        Step 5. Verifying the Server Installation
        Step 6. Security Providers
        Starting and Using the Server
        CL and CMD Programs
        General Information for an IBM i Installation
        Generating a Trace
        Third-Party Software and Licenses
        Troubleshooting for IBM i
      Installation for OpenVMS
        Step 1. Reviewing System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Setup Procedure
        Step 5. Verifying the Installation
        Step 6. Security Providers
        Starting and Using the Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for an OpenVMS Installation
        Troubleshooting for OpenVMS
      Information Builders and Third-Party Licenses
        Information Builders License
        OpenFlex SDK License
        Zip Archiver License
      Launch PDF
    Stored Procedure Reference for 3GL Procedures
      Introducing Stored Procedures
        Using a Stored Procedure
        Calling a Stored Procedure
        Stored Procedure Libraries
        Setting the Execution Order
      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
      Launch PDF
  Reporting Language
    Creating Reports With WebFOCUS Language
      Creating Reports Overview
        Requirements for Creating a Report
        Report Types
        Reporting Tools
        Developing Your Report Request
        Customizing a Report
        Selecting a Report Output Destination
      Displaying Report Data
        Using Display Commands in a Request
        Displaying Individual Values
        Adding Values
        Counting Values
        Expanding Byte Precision for COUNT and LIST
        Maximum Number of Display Fields Supported in a Request
        Manipulating Display Fields With Prefix Operators
        Displaying Pop-up Field Descriptions for Column Titles
      Sorting Tabular Reports
        Sorting Tabular Reports Overview
        Sorting Rows
        Sorting Columns
        Reformatting Sort Fields
        Manipulating Display Field Values in a Sort Group
        Creating a Matrix Report
        Controlling Collation Sequence
        Specifying the Sort Order
        Ranking Sort Field Values
        Grouping Numeric Data Into Ranges
        Restricting Sort Field Values by Highest/Lowest Rank
        Sorting and Aggregating Report Columns
        Hiding Sort Values
        Sorting With Multiple Display Commands
        Improving Efficiency With External Sorts
        Hierarchical Reporting: BY HIERARCHY
      Selecting Records for Your Report
        Selecting Records Overview
        Choosing a Filtering Method
        Selections Based on Individual Values
        Selection Based on Aggregate Values
        Using Compound Expressions for Record Selection
        Using Operators in Record Selection Tests
        Types of Record Selection Tests
        Selections Based on Group Key Values
        Setting Limits on the Number of Records Read
        Selecting Records Using IF Phrases
        Reading Selection Values From a File
        Assigning Screening Conditions to a File
        VSAM Record Selection Efficiencies
      Creating Temporary Fields
        What Is a Temporary Field?
        Defining a Virtual Field
        Creating a Calculated Value
        Assigning Column Reference Numbers
        Calculating Trends and Predicting Values With FORECAST
        Calculating Trends and Predicting Values With Multivariate REGRESS
        Using Text Fields in DEFINE and COMPUTE
        Creating Temporary Fields Independent of a Master File
      Including Totals and Subtotals
        Calculating Row and Column Totals
        Including Section Totals and a Grand Total
        Including Subtotals
        Recalculating Values for Subtotal Rows
        Summarizing Alphanumeric Columns
        Manipulating Summary Values With Prefix Operators
        Combinations of Summary Commands
        Producing Summary Columns for Horizontal Sort Fields
        Performing Calculations at Sort Field Breaks
        Suppressing Grand Totals
        Conditionally Displaying Summary Lines and Text
      Using Expressions
        Using Expressions in Commands and Phrases
        Types of Expressions
        Creating a Numeric Expression
        Creating a Date Expression
        Creating a Date-Time Expression
        Creating a Character Expression
        Creating a Variable Length Character Expression
        Creating a Logical Expression
        Creating a Conditional Expression
      Saving and Reusing Your Report Output
        Saving Your Report Output
        Creating a HOLD File
        Holding Report Output in FOCUS Format
        Controlling Attributes in HOLD Master Files
        Keyed Retrieval From HOLD Files
        Saving and Retrieving HOLD Files
        Using DBMS Temporary Tables as HOLD Files
        Creating SAVE and SAVB Files
        Creating a PCHOLD File
        Choosing Output File Formats
        Using Text Fields in Output Files
        Creating a Delimited Sequential File
        Saving Report Output in INTERNAL Format
        Creating A Subquery or Sequential File With HOLD FORMAT SQL_SCRIPT
        Creating a Structured HOLD File
        Specifying MIME Types for WebFOCUS Reports
      Choosing a Display Format
        Report Display Formats
        Preserving Leading and Internal Blanks in Report Output
        Using Web Display Format: HTML
        Using Print Display Formats: PDF, PS
        Using Word Processing Display Formats: DOC, WP
        Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL
        Using PowerPoint PPT Display Format
        Using PowerPoint PPTX Display Format
      Linking a Report to Other Resources
        Linking Using StyleSheets
        Linking to Another Report
        Linking to a URL
        Linking to a JavaScript Function
        Linking to a WebFOCUS Maintain Procedure
        Creating Multiple Drill-Down Links
        Creating Parameters
        Linking With Conditions
        Linking From a Graphic Image
        Specifying a Base URL
        Specifying a Target Frame
        Creating a Compound Report
        Creating a PDF Compound Report With Drill Through Links
      Navigating Within an HTML Report
        Navigating Sort Groups From a Table of Contents
        Adding the HTML Table of Contents Tree Control to Reports
        Controlling the Display of Sorted Data With Accordion Reports
        Navigating a Multi-Page Report With the WebFOCUS Viewer
        Linking Report Pages
      Bursting Reports Into Multiple HTML Files
        Bursting Reports Overview
      Handling Records With Missing Field Values
        Irrelevant Report Data
        Missing Field Values
        Handling a Missing Segment Instance
        Setting the NODATA Character String
      Joining Data Sources
        Types of Joins
        How the JOIN Command Works
        Creating an Equijoin
        Using a Conditional Join
        Full Outer Joins for Relational Data Sources
        Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT
        Joining From a Multi-Fact Synonym
        Invoking Context Analysis for a Star Schema With a Fan Trap
        Adding DBA Restrictions to the Join Condition: SET DBAJOIN
        Preserving Virtual Fields During Join Parsing
        Displaying Joined Structures
        Clearing Joined Structures
      Merging Data Sources
        Merging Data
        MATCH Processing
        MATCH Processing With Common High-Order Sort Fields
        Fine-Tuning MATCH Processing
        Universal Concatenation
        Merging Concatenated Data Sources
        Cartesian Product
      Formatting Reports: An Overview
        What Kinds of Formatting Can I Do?
        How to Specify Formatting in a Report
        Standard and Legacy Formatting
        Techniques for Quick and Easy Formatting
        Navigating From a Report to Other Resources
      Creating and Managing a WebFOCUS StyleSheet
        Creating a WebFOCUS StyleSheet
        General WebFOCUS StyleSheet Syntax
        Reusing WebFOCUS StyleSheet Declarations With Macros
        WebFOCUS StyleSheet Attribute Inheritance
      Controlling Report Formatting
        Generating an Internal Cascading Style Sheet for HTML Reports
        Selecting a Unit of Measurement
        Conditionally Formatting, Displaying, and Linking in a StyleSheet
        Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
        Conditionally Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
        Controlling the Display of Empty Reports
        Formatting a Report Using Only StyleSheet Defaults
      Identifying a Report Component in a WebFOCUS StyleSheet
        Identifying an Entire Report, Column, or Row
        Identifying Tags for SUBTOTAL and GRANDTOTAL Lines
        Identifying Data
        Identifying a Heading, Footing, Title, or FML Free Text
        Identifying a Page Number, Underline, or Skipped Line
      Using an External Cascading Style Sheet
        What Is a Cascading Style Sheet?
        Why Use an External Cascading Style Sheet?
        Formatting a Report With an External Cascading Style Sheet
        Working With an External Cascading Style Sheet
        Applying External Cascading Style Sheet Formatting
        Combining an External CSS With Other Formatting Methods
        Linking to an External Cascading Style Sheet
        Inheritance and External Cascading Style Sheets
        Using External Cascading Style Sheets With Non-HTML Reports
        Requirements for Using an External Cascading Style Sheet
        FAQ About Using External Cascading Style Sheets
        Troubleshooting External Cascading Style Sheets
      Laying Out the Report Page
        Selecting Page Size, Orientation, and Color
        Setting Page Margins
        Positioning a Report Component
        Arranging Columns on a Page
        Suppressing Column Display
        Inserting a Page Break
        Inserting Page Numbers
        Adding Grids and Borders
        Defining Borders Around Boxes With PPTX and PDF Formats
        Displaying Superscripts On Data, Heading, and Footing Lines
        Adding Underlines and Skipped Lines
        Removing Blank Lines From a Report
        Adding an Image to a Report
        Associating Bar Graphs With Report Data
        Working With Mailing Labels and Multi-Pane Pages
      Using Headings, Footings, Titles, and Labels
        Creating Headings and Footings
        Including an Element in a Heading or Footing
        Repeating Headings and Footings on Panels in PDF Report Output
        Customizing a Column Title
        Controlling Column Title Underlining Using a SET Command
        Controlling Column Title Underlining Using a StyleSheet Attribute
        Creating Labels to Identify Data
        Formatting a Heading, Footing, Title, or Label
        Applying Font Attributes to a Heading, Footing, Title, or Label
        Adding Borders and Grid Lines
        Justifying a Heading, Footing, Title, or Label
        Choosing an Alignment Method for Heading and Footing Elements
        Aligning a Heading or Footing Element in an HTML, XLSX, EXL2K, or PDF Report
        Aligning a Heading or Footing Element Across Columns in an HTML or PDF Report
        Aligning Content in a Multi-Line Heading or Footing
        Positioning Headings, Footings, or Items Within Them
        Controlling the Vertical Positioning of a Heading or Footing
        Placing a Report Heading or Footing on Its Own Page
      Formatting Report Data
        Specifying Font Format in a Report
        Specifying Background Color in a Report
        Specifying Data Format in a Report
        Positioning Data in a Report
      Creating a Graph
        Content Analysis: Determining Graphing Objectives
        The GRAPH Command
        Creating an HTML5 Graph
        Selecting a Graph Type
        Selecting Values for the X and Y Axes
        Creating Multiple Graphs
        Plotting Dates in Graphs
        Refining the Data Set For Your Graph
        Displaying Missing Data Values in a Graph
        Applying Conditional Styling to a Graph
        Linking Graphs to Other Resources
        Adding Labels to a Graph
        Applying Custom Styling to a Graph
        Saving a Graph as an Image File
        Printing a Graph
      Creating Financial Reports With Financial Modeling Language (FML)
        Reporting With FML
        Creating Rows From Data
        Supplying Data Directly in a Request
        Performing Inter-Row Calculations
        Referring to Rows in Calculations
        Referring to Columns in Calculations
        Referring to Rows and Columns in Calculations
        Referring to Cells in Calculations
        Using Functions in RECAP Calculations
        Inserting Rows of Free Text
        Adding a Column to an FML Report
        Creating a Recursive Model
        Reporting Dynamically From a Hierarchy
        Customizing a Row Title
        Formatting an FML Report
        Suppressing the Display of Rows
        Saving and Retrieving Intermediate Report Results
        Creating HOLD Files From FML Reports
      Creating a Free-Form Report
        Creating a Free-Form Report
        Designing a Free-Form Report
      Using SQL to Create Reports
        Supported and Unsupported SQL Statements
        Using SQL Translator Commands
        SQL Translator Support for Date, Time, and Timestamp Fields
        Index Optimized Retrieval
        TABLEF Optimization
        SQL INSERT, UPDATE, and DELETE Commands
      Improving Report Processing
        Rotating a Data Structure for Enhanced Retrieval
        Optimizing Retrieval Speed for FOCUS Data Sources
        Automatic Indexed Retrieval
        Data Retrieval Using TABLEF
        Preserving the Internal Matrix of Your Last Report
        Compiling Expressions
      Master Files and Diagrams
        EMPLOYEE Data Source
        JOBFILE Data Source
        EDUCFILE Data Source
        SALES Data Source
        CAR Data Source
        LEDGER Data Source
        FINANCE Data Source
        REGION Data Source
        EMPDATA Data Source
        TRAINING Data Source
        COURSE Data Source
        JOBHIST Data Source
        JOBLIST Data Source
        LOCATOR Data Source
        PERSINFO Data Source
        SALHIST Data Source
        VIDEOTRK, MOVIES, and ITEMS Data Sources
        VIDEOTR2 Data Source
        Gotham Grinds Data Sources
        Century Corp Data Sources
      Error Messages
        Displaying Messages
      Table Syntax Summary and Limits
        TABLE Syntax Summary
        TABLEF Syntax Summary
        MATCH Syntax Summary
        FOR Syntax Summary
        TABLE Limits
      Referring to Fields in a Report Request
        Referring to an Individual Field
        Referring to Fields Using Qualified Field Names
        Referring to All of the Fields in a Segment
        Displaying a List of Field Names
      Launch PDF
    Describing Data With WebFOCUS Language
      Understanding a Data Source Description
        A Note About Data Source Terminology
        What Is a Data Source Description?
        How an Application Uses a Data Source Description
        What Does a Master File Describe?
        Creating a Data Source Description
        Naming a Master File
        What Is in a Master File?
      Identifying a Data Source
        Identifying a Data Source Overview
        Specifying a Data Source Name: FILENAME
        Identifying a Data Source Type: SUFFIX
        Specifying Byte Order
        Specifying Data Type: IOTYPE
        Providing Descriptive Information for a Data Source: REMARKS
        Specifying a Physical File Name: DATASET
        Creating and Using a Master File Profile
      Describing a Group of Fields
        Defining a Single Group of Fields
        Identifying a Logical View: Redefining a Segment
        Relating Multiple Groups of Fields
        Logical Dependence: The Parent-Child Relationship
        Logical Independence: Multiple Paths
        Cardinal Relationships Between Segments
        One-to-One Relationship
        One-to-Many Relationship
        Many-to-Many Relationship
        Recursive Relationships
        Relating Segments From Different Types of Data Sources
        Rotating a Data Source: An Alternate View
      Describing an Individual Field
        Field Characteristics
        The Field Name: FIELDNAME
        The Field Synonym: ALIAS
        The Displayed Data Type: USAGE
        The Stored Data Type: ACTUAL
        Null or MISSING Values: MISSING
        Describing an FML Hierarchy
        Defining a Dimension: WITHIN
        Validating Data: ACCEPT
        Specifying Acceptable Values for a Dimension
        Alternative Report Column Titles: TITLE
        Documenting the Field: DESCRIPTION
        Multilingual Metadata
        Describing a Virtual Field: DEFINE
        Describing a Calculated Value: COMPUTE
        Describing a Filter: FILTER
        Describing a Sort Object: SORTOBJ
        Calling a DEFINE FUNCTION in a Master File
        Using Date System Amper Variables in Master File DEFINEs
        Parameterizing Master and Access File Values Using Variables
        Converting Alphanumeric Dates to WebFOCUS Dates
      Describing a Sequential, VSAM, or ISAM Data Source
        Sequential Data Source Formats
        Standard Master File Attributes for a Sequential Data Source
        Standard Master File Attributes for a VSAM or ISAM Data Source
        Describing a Multiply Occurring Field in a Free-Format Data Source
        Describing a Multiply Occurring Field in a Fixed-Format, VSAM, or ISAM Data Source
        Redefining a Field in a Non-FOCUS Data Source
        Extra-Large Record Length Support
        Describing Multiple Record Types
        Combining Multiply Occurring Fields and Multiple Record Types
        Establishing VSAM Data and Index Buffers
        Using a VSAM Alternate Index
        Describing a Token-Delimited Data Source
      Describing a FOCUS Data Source
        Types of FOCUS Data Sources
        Designing a FOCUS Data Source
        Describing a Single Segment
        GROUP Attribute
        ACCEPT Attribute
        INDEX Attribute
        Describing a Partitioned FOCUS Data Source
        Multi-Dimensional Index (MDI)
      Defining a Join in a Master File
        Join Types
        Static Joins Defined in the Master File: SEGTYPE = KU and KM
        Using Cross-Referenced Descendant Segments: SEGTYPE = KL and KLU
        Dynamic Joins Defined in the Master File: SEGTYPE = DKU and DKM
        Conditional Joins in the Master File
        Comparing Static and Dynamic Joins
        Joining to One Cross-Referenced Segment From Several Host Segments
        Creating a Cluster Master File
      Creating a Business View of a Master File
        Grouping Business Logic In a Business View
      Checking and Changing a Master File: CHECK
        Checking a Data Source Description
        CHECK Command Display
        PICTURE Option
        HOLD Option
      Providing Data Source Security: DBA
        Introduction to Data Source Security
        Implementing Data Source Security
        Specifying an Access Type: The ACCESS Attribute
        Limiting Data Source Access: The RESTRICT Attribute
        Controlling the Source of Access Restrictions in a Multi-file Structure
        Adding DBA Restrictions to the Join Condition
        Placing Security Information in a Central Master File
        Summary of Security Attributes
        Hiding Restriction Rules: The ENCRYPT Command
        FOCEXEC Security
      Creating and Rebuilding a Data Source
        Creating a New Data Source: The CREATE Command
        Rebuilding a Data Source: The REBUILD Command
        Optimizing File Size: The REBUILD Subcommand
        Changing Data Source Structure: The REORG Subcommand
        Indexing Fields: The INDEX Subcommand
        Creating an External Index: The EXTERNAL INDEX Subcommand
        Checking Data Source Integrity: The CHECK Subcommand
        Changing the Data Source Creation Date and Time: The TIMESTAMP Subcommand
        Converting Legacy Dates: The DATE NEW Subcommand
        Creating a Multi-Dimensional Index: The MDINDEX Subcommand
      Master Files and Diagrams
        EMPLOYEE Data Source
        JOBFILE Data Source
        EDUCFILE Data Source
        SALES Data Source
        CAR Data Source
        LEDGER Data Source
        FINANCE Data Source
        REGION Data Source
        EMPDATA Data Source
        TRAINING Data Source
        COURSE Data Source
        JOBHIST Data Source
        JOBLIST Data Source
        LOCATOR Data Source
        PERSINFO Data Source
        SALHIST Data Source
        VIDEOTRK, MOVIES, and ITEMS Data Sources
        VIDEOTR2 Data Source
        Gotham Grinds Data Sources
        Century Corp Data Sources
      Error Messages
        Displaying Messages
      Launch PDF
    Developing Reporting Applications
      WebFOCUS Application Logic
        Three-Tier Application Logic
        Deploying a Partitioned Project
        WebFOCUS Components
        Storing and Searching for Application Files
        Section 508 Accessibility in WebFOCUS
      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
        Help Information: 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
      Coding a User Interface
        Which Tools Can You Use?
        The WebFOCUS Client
        Using the Servlet
        Using a Dynamic Multiselect Drop-Down List
        Enabling Ad Hoc Reporting
        Validating a Form With JavaScript
        Amper Auto-Prompting
        Displaying a Report on the Default WebFOCUS Page
        Designing an HTML Page for Report Display
      Enhancing a User Interface
        Displaying a Report in a Helper Application
        Controlling Multiple Reports
        Adding JavaScript for Drill-Down Reporting
        Facilitating Report Manipulation
        Using a Cascading Style Sheet to Standardize Display
        Displaying a Previously Run Report
        Passing a User ID From HTML for a Custom Menu
      Managing Flow of Control in an Application
        Uses for Dialogue Manager
        Dialogue Manager Processing
        Creating a Dialogue Manager Procedure
        Customizing a Procedure With Variables
        Creating a Standard Quote-Delimited String
        Creating and Working With Variables
        Using Numeric Amper Variables in Functions
        Controlling the Execution of a Procedure
        Navigating a Procedure
        Enhancing an HTML Webpage With a Procedure
        Issuing Operating System Commands
        Controlling Passwords With Dialogue Manager
        Sending a Message to the Application
        Testing and Debugging a Dialogue Manager Procedure
        Dialogue Manager Process Flow in the Procedure Viewer
        Dialogue Manager Syntax Reference
      Testing and Debugging a Procedure
        Debugging Your Application With Query Commands
        Displaying Combined Structures
        Displaying Virtual Fields
        Displaying the Currency Data Source in Effect
        Displaying Available Fields
        Displaying the File Directory Table
        Displaying Field Information for a Master File
        Displaying Data Source Statistics
        Displaying Current ddnames Assigned With FILEDEF
        Displaying Defined Functions
        Displaying HOLD Fields
        Displaying JOIN Structures
        Displaying National Language Support
        Displaying Explanations of Error Messages
        Displaying the Current Search Path
        Displaying the Release Number
        Displaying the Values of a Remote Server
        Displaying Parameter Settings
        Displaying Parameters That Cannot Be Set in an Area
        Displaying Graph Parameters
        Displaying the Site Code of the Connected Server
        Displaying Command Statistics
        Displaying StyleSheet Parameter Settings
        Displaying Information About the SU Machine
        Displaying Data Sources Specified With USE
        Displaying Global Variable Values
        Identifying the Files Being Used
      Managing the WebFOCUS Environment
        Setting Up a WebFOCUS Environment
        Refreshing or Removing an Environment
      Accessing a FOCUS Data Source
        The USE Command
        The Developer Studio Use Tool
        Identifying a FOCUS Data Source
        Using Alternative File Specifications
        Identifying a New Data Source
        Protecting a Data Source
        Concatenating Data Sources
        Displaying the Current USE Options
        Clearing the USE Options
      Customizing Your Environment
        When Do You Use the SET Command?
        Ways to Issue a SET Command
        Issuing a SET Command With the Set Tool
        Coding a SET Command
        Types of SET Parameters
        SET Parameter Syntax
      Defining and Allocating WebFOCUS Files
        Allocating WebFOCUS Files
        Application Files Under Windows
        Extract Files Under Windows
        Work Files Under Windows
        Determining If A File Exists Under Windows
        WebFOCUS Files Under MVS
        Application Files Under MVS
        Extract Files Under MVS
        Work Files Under MVS
        Reviewing Attributes of Allocated Files Under MVS
        Application Files Under UNIX
        Extract Files Under UNIX
        Work Files Under UNIX
        Determining If A File Exists Under UNIX
      Using the Command Console
        Command Console Window
        Working in the Command Console
      Euro Currency Support
        Integrating the Euro Currency
        Converting Currencies
        Creating the Currency Data Source
        Identifying Fields That Contain Currency Data
        Activating the Currency Data Source
        Processing Currency Data
        Querying the Currency Data Source in Effect
        Punctuating Numbers
        Selecting an Extended Currency Symbol
      Launch PDF
    Using Functions
      How to Use This Manual
        Available Languages
        Operating Systems
      Introducing Functions
        Using Functions
        Types of Functions
        Character Chart for ASCII and EBCDIC
      Accessing and Calling a Function
        Calling a Function
        Supplying an Argument in a Function
        Calling a Function From a DEFINE, COMPUTE, or VALIDATE Command
        Calling a Function From a Dialogue Manager Command
        Calling a Function From Another Function
        Calling a Function in WHERE or IF Criteria
        Calling a Function in WHEN Criteria
        Calling a Function From a RECAP Command
        Storing and Accessing an External Function
      Character Functions
        Character Function Notes
        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
      Simplified Character Functions
        CHAR_LENGTH: Returning the Length in Characters of a String
        DIGITS: Converting a Number to a Character String
        LOWER: Returning a String With All Letters Lowercase
        LPAD: Left-Padding a Character String
        LTRIM: Removing Blanks From the Left End of a String
        POSITION: Returning the First Position of a Substring in a Source String
        RPAD: Right-Padding a Character String
        RTRIM: Removing Blanks From the Right End of 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 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
      Maintain-specific Character Functions
        CHAR2INT: Translating a Character Into an Integer Value
        INT2CHAR: Translating an Integer Value Into a Character
        LCWORD and LCWORD2: Converting a Character String to Mixed-Case
        LENGTH: Determining the Length of a Character String
        LJUST: Left-Justifying a Character String (Maintain)
        LOWER: Converting a Character String to Lowercase
        MASK: Extracting or Adding Characters
        MNTGETTOK: Extracting Tokens From a String Function
        NLSCHR: Converting Characters From the Native English Code Page
        OVRLAY: Overlaying a Character String (Maintain)
        POSIT: Finding the Beginning of a Substring (Maintain)
        RJUST: Right-Justifying a Character String (Maintain)
        SELECTS: Decoding a Value From a Stack
        STRAN: Substituting One Substring for Another
        STRCMP: Comparing Character Strings
        STRICMP: Comparing Character Strings and Ignoring Case
        STRNCMP: Comparing Character Substrings
        STRTOKEN: Extracting a Substring Based on Delimiters
        SUBSTR: Extracting a Substring (Maintain)
        TRIM: Removing Trailing Occurrences (Maintain)
        TRIMLEN: Determining the Length of a String Excluding Trailing Spaces
        UPCASE: Converting Text to Uppercase (Maintain)
      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
      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
        DPART: Extracting a Component From a Date
        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
        CVTSTIME: Converting the System Date and Time (OpenVMS Only)
        GETSTIME: Extracting the System Date and Time (OpenVMS Only)
        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
        HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
        HGETC: Storing the Current 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
        HMASK: Extracting Date-Time Components and Preserving Remaining Components
        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 or TIMETOTS: Converting a Time to a Timestamp
        HYYWD: Returning the Year and Week Number From a Date-Time Value
        WRTSTIME: Converting Dates to 64-Bit DEC Date/Time Format (OpenVMS Only)
      Simplified Date and Date-Time Functions
        DTADD: Incrementing a Date or Date-Time Component
        DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
        DTPART: Returning a Date or Date-Time Component in Integer Format
        DTRUNC: Returning the Start of a Date Period for a Given Date
      Maintain-specific Date and Time Functions
        Maintain-specific Standard Date and Time Functions
      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 Binary Integer 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
      Maintain-specific Light Update Support Functions
        IWC.FindAppCGIValue: Retrieving a WebFOCUS Parameter or Variable Value
        IWC.GetAppCGIValue: Importing a WebFOCUS Parameter or Variable
      Numeric Functions
        ABS: Calculating Absolute Value
        ASIS: Distinguishing Blank From Zero
        BAR: Producing a Bar Chart
        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
        FMLINFO: Returning FOR Values
        FMLLIST: Returning an FML Tag List
        FMLFOR: Retrieving FML Tag Values
        FMLCAP: Retrieving FML Hierarchy Captions
        INT: Finding the Greatest Integer
        LOG: Calculating the Natural Logarithm
        MAX and MIN: Finding the Maximum or Minimum Value
        MIRR: Calculating the Modified Internal Return Rate
        NORMSDST and NORMSINV: Calculating Normal Distributions
        PRDNOR and PRDUNI: Generating Reproducible Random Numbers
        RDNORM and RDUNIF: Generating Random Numbers
        SQRT: Calculating the Square Root
        XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
      Maintain-specific Script Functions
        IWCLink: Displaying a URL in a Browser or Frame
        IWCSwitchToSecure and IWCSwitchToUnsecure: Turning the Secure Sockets Layer On and Off
        IWCTrigger: Calling a Maintain Function From a Script Handler
        IWC.FindAppCGIValue: Finding a WebFOCUS Parameter or Variable Value
        IWC.GetAppCGIValue: Retrieving a WebFOCUS Parameter or Variable
      System Functions
        CHECKPRIVS: Retrieving the Privilege State for the Connected User
        CLSDDREC: Closing All Files Opened by the PUTDDREC Function
        FEXERR: Retrieving an Error Message
        FGETENV: Retrieving the Value of an Environment Variable
        FINDMEM: Finding a Member of a Partitioned Data Set
        FPUTENV: Assigning a Value to an Environment Variable
        GETCOOKI: Retrieving a Browser Cookie Value
        GETHEADR: Retrieving an HTTP Header Variable
        GETPDS: Determining If a Member of a Partitioned Data Set Exists
        GETUSER: Retrieving a User ID
        GRPLIST: Retrieving the Group List of the Connected User
        JOBNAME: Retrieving the Current Process Identification String
        MVSDYNAM: Passing a DYNAM Command to the Command Processor
        PUTCOOKI: Submitting a Value to a Browser Cookie
        PUTDDREC: Writing a Character String as a Record in a Sequential File
        SLEEP: Suspending Execution for a Given Number of Seconds
        SPAWN: Creating a Subprocess From a Procedure
        SYSTEM: Calling a System Program
        SYSVAR: Retrieving the Value of a z/OS System Variable
      Creating a Subroutine
        Writing a Subroutine
        Compiling and Storing a Subroutine
        Testing the Subroutine
        Using a Custom Subroutine: The MTHNAM Subroutine
        Subroutines Written in REXX
      Launch PDF
  DataMigrator Functions
  DataMigrator User's Guide
    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, 5.3, 7.1, or 7.6
    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 ETL 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, Enhancing, and Editing 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
    Change Data Capture
      Enabling the Database for Logging in Relational Databases
      Enabling the Database for Logging in VSAM
      Properties of a Table Log Record Synonym
      Tutorial: Using Change Data Capture with Relational Databases
      Tutorial: Using Change Data Capture With VSAM
    DataMigrator Log Statistics and Tables
      Log and Statistics Tables
    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
      Using a Source Control System to Manage Procedures and Synonyms
    Launch PDF
  Resource Analyzer Administrator's and User's Manual
    What Is Resource Analyzer?
      Resource Analyzer Overview
      Resource Analyzer for Decision Support Analysis
      Uses for Resource Analyzer: Performance Analysis
      Introduction to Data Access and Performance Analysis With Resource Analyzer
      Sample Data Access Questions
      How Resource Analyzer Works
      Software Prerequisites
      Overview of the Web Console
      Overview of Reporting With Resource Analyzer
      Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
    Configuring and Administering Resource Management
      Resource Management Interface
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Resource Analyzer Report Options
      Reports Overview
      Resource Analyzer Reporting
      Resource Analyzer Report Options
      General Reports
      Resource Analyzer Reports
    Getting Help
      Resource Management Administration Help
      Reporting Application Context-Sensitive Help From Reports
    Administrative Usage Monitoring Tables Column Descriptions
      Administrative Tables (RMLSYS.MAS)
      Usage Monitoring Table (RMLDB.MAS)
      Usage Monitoring RDBMS Table Sizing
      Renamed or Moved Columns
    Using DDL Statements to Create the Internal Tables
      Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
    Launch PDF
  Resource Governor Administrator's and User's Manual
     What Is Resource Governor?
      Resource Governor Overview
      Resource Governor Features
      Resource Governor Operations
      How Resource Governor Works
      Resource Governor Usage Monitoring
    Configuring and Administering Resource Management
      Resource Management Interface
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Rules Files and Knowledge Bases
      Overview
      Working With Business Rules
      Working with Resource Thresholds
      Working with Knowledge Bases
      Maintaining Knowledge Bases
    Resource Governor Report Options
      Reports Overview
      Resource Governor Reporting
      Resource Governor Report Options
      General Reports
      Resource Governor Reports
    Getting Help
      Resource Management Administration Help
      Reporting Application Context-Sensitive Help From Reports
    Administrative Usage Monitoring Tables Column Descriptions
      Administrative Tables (RMLSYS.MAS)
      Usage Monitoring Table (RMLDB.MAS)
      Usage Monitoring RDBMS Table Sizing
      Renamed or Moved Columns
    Using DDL Statements to Create the Internal Tables
      Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
    Business Rule Language (BRL)
      Using Business Rule Language (BRL)
      BRL Factual Information
      BRL Keywords
      Pre-defined Variables
      Internal Functions
      Customized Rule Examples
    Launch PDF