DataMigrator Server/WebFOCUS Reporting Server Technical Library
  Technical Support
  Technical Support
Release 7703
  WebFOCUS Reporting Server
    Server Administration
      Server Introduction
        Using the Web Console
        My Console Options
        Configuration Overview
        Running and Configuring the FOCUS Database Server (z/OS Only)
        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
      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
        Reports and Help
        Restricting the Use of APP Commands
        Accessing Metadata and Procedures
        Allocating Temporary Files
        Temporary Space Allocation for UNIX and z/OS UNIX System Services
        Temporary File Directory Structure for Non-PDS Deployment
      Data Adapters
        Configuring an Adapter
        Changing the Adapter Configuration
        Configuring a Remote Server
      Metadata
        Creating Synonyms
        Testing Synonyms
        Managing Synonyms
        Metadata Wizard
      Stored Procedures
        Creating a Stored Procedure
        Editing a Stored Procedure
        Running a Stored Procedure
        Scheduling a Procedure
        Sending an E-mail Notification for a Procedure
        Stress Testing a Procedure
        Running Impact Analysis Reports
      Server Workspace Manager
        Configuring Workspace Manager
        Workspace Configuration Settings
        Editing Configuration Files
        Fine-Tuning the Server
        Monitoring Server Activity
      Listeners and Special Services
        Using the Listeners and Special Services Configuration Panes
      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 USS/HFS Deployment
        Retrieving IBISNAP Output
        Recording and Reproducing User Actions
        Troubleshooting the Console
        Workspace Manager Safe Mode
        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
      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 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 Enterprise Java Beans
        Preparing the Web Application Server Environment
        Configuring the Adapter for Enterprise Java Beans
        Managing Enterprise Java Beans Metadata
      Using the Adapter for ERwin
        Preparation Steps for ERwin
        Configuring the Adapter for ERwin
        Enhancing Synonyms With ERwin Metadata
      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
        Modifying Essbase Data
      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)
      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 HP Neoview
        Preparing the HP Neoview Environment
        Configuring the Adapter for HP Neoview
        Managing HP Neoview Metadata
        Customizing the HP Neoview 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 Information Manager
        IBM Information/Management
        How the Server Works With Information/Management
        InfoMan Hardware and Software Requirements
        Configuring the Adapter for InfoMan
        Defining the Adapter for InfoMan User ID and Session ID
        InfoMan Access Control
        Server Security in InfoMan
        IBM Information/Management Database Security
        AUTOIMAN Configuration File
        Describing InfoMan Data Sources
        Executing AUTOIMAN
        Working With AUTOIMAN
        Master File Generation Facility in InfoMan
        PIDT Selection Panel in InfoMan
        Retrieval PIDT Name Confirmation in InfoMan
      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
        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 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 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 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 MetaMatrix
        Preparing the MetaMatrix Environment
        Configuring the Adapter for MetaMatrix
        Managing MetaMatrix Metadata
        Customizing the MetaMatrix 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 2000 Analysis Services (MS OLAP)
        Preparing the Microsoft SQL Server 2000 Analysis Services (MS OLAP) Environment
        Configuring the Adapter for Microsoft SQL Server 2000 Analysis Services (MS OLAP)
        Managing Microsoft SQL Server 2000 Analysis Services (MS OLAP) Metadata
        Customizing the Microsoft SQL Server 2000 Analysis Services (MS OLAP) Environment
      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 MQSeries
        Preparing the MQSeries Environment
        Configuring the Adapter for MQSeries
        Managing MQSeries Metadata
        Customizing the MQSeries Environment
      Using the Adapter for Digital Standard Mumps
        Preparing the Mumps Environment
        Configuring the Adapter for Digital Standard Mumps
        Managing Mumps Metadata
        Including Records in a Mumps Data Source
      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
        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 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 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 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 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 Supra
        Preparing the Supra Environment
        Configuring the Adapter for Supra
        Supra Overview and Mapping Considerations
        Managing Supra Metadata
        Supra Modules
        Adapter Tracing
      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 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 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 XBRL
        What Is XBRL?
        Configuring the Adapter for XBRL
        Reporting Against XBRL Instance Documents
        Reporting on Dimensions
      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 Release Notes
      General Information
      Known Issues in 7.7
      Adapter for DB2 on IBM i
      Adapter for ODBC
      Adapter for Oracle
      Adapter for PeopleSoft
      Adapter Support
      Connector for OLE DB
      DB2 Extender
      DataMigrator
      Resource Analyzer
      Run Deferred Option Changed to Submit With Options
      Running or Sharing 77x and 76x on the Same Machine
      Migration From SPG, TPG or AAS to Full Function Server for CICS Transactions
      Platform Support
      Launch PDF
    Server Installation
      Introduction to Server Installation
        Server Versions
        What to Read After You Install the Server
      Server Installation for Windows
        Installation Requirements
        Installation and Configuration Directories
        Accessing the Installation Software
        Installing a Server
        Verifying Server Installation
        Choosing a Security Mode
        Additional Server Installation Options
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a Windows Installation
        Troubleshooting for Windows
      Server Installation for UNIX
        Installation Requirements
        Installation and Configuration Directories
        Installing a Server
        Verifying Server Installation
        Choosing a Security Mode
        Starting and Using a Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a UNIX Installation
        Troubleshooting for UNIX
      Server Installation for z/OS
        Server Installation for HFS & PDS
        HFS Deployment
        PDS Deployment
      Server 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. Configuring the Server With Different Security Modes
        Starting and Using the Server
        Other IBM i Start Up Options
        Accessing IFS Files and QSYS Libraries
        Generating a Trace
        Third-Party Software and Licenses
        Troubleshooting for IBM i
      Server Installation for OpenVMS
        Step 1. Checking System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Setup Procedure
        Step 5. Verifying the Server Installation
        Step 6. Configuring the Server With Different Security Modes
        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
      Introducing Stored Procedures
        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 EDARPC
        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
      Writing a Dialogue Manager Procedure
        Commands Included in a Procedure
        Commands and Processing
        Commenting a Procedure
        Sending a Message to a Client Application
        Controlling Execution
        Using Variables
        Supplying Values for Variables
        Branching
        Looping
        Calling Another Procedure
        The -REMOTE Commands
        Reading From and Writing to an External File
        .EVAL Operator
        Creating Expressions
        Using Functions
        Using Commands Specific to an Operating System
        ON TABLE HOLD
        ON TABLE PCHOLD
      Platform-Specific Commands and Features
        DYNAM Command (MVS)
        Comparison of TSO Commands, JCL, and DYNAM
        DDNAME Translation in User-Written Subroutines: MSODDX
        FILEDEF Command Under VM
        FILEDEF Command Under UNIX, Windows, IBM i, z/OS, and OpenVMS
      Dialogue Manager Quick Reference
        Dialogue Manager Commands
      GENCPGM Usage
        Using GENCPGM
        Subroutine Source Examples and Runtime Testing
      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
        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
      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 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: EXL07, EXL2K, EXL97, EXCEL
        Using PowerPoint 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 an HTML TOC to a Report
        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
        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 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
        Adding Underlines and Skipped Lines
        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
        Support for Repeated Headings and Footings on Panels in PDF Report Output
        Customizing a Column Title
        Controlling Column Title Underlining
        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, EXL07, 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
        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 Long and 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
        Providing Descriptive Information for a Data Source: REMARKS
        Specifying a Physical File Name: DATASET
      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
        Parameterizing Master and Access File Values Using Variables
        Describing a Filter: FILTER
        Describing a Calculated Value: COMPUTE
        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
        Comparing Static and Dynamic Joins
        Joining to One Cross-Referenced Segment From Several Host Segments
      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
        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
        Reports and Help
        Restricting the Use of APP Commands
        Accessing Metadata and Procedures
        Allocating Temporary Files
        Temporary Space Allocation for UNIX and z/OS UNIX System Services
        Temporary File Directory Structure for Non-PDS Deployment
      Coding a User Interface
        Which Tools Can You Use?
        The WebFOCUS Client
        Using the Servlet
        Using ISAPI
        Using CGI
        Using a Dynamic Multi-Select 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 Web Page 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 Parameter Values Categorized by Functional Area
        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
        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
      Using the Command Console
        Command Console Window
        Working in the Command Console
      Migrating Applications to Version 7
        Before You Begin Migrating
        The Migration Process
        After the Migration Process
      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
        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
      Variable Length Character Functions
        Overview
        LENV: Returning the Length of an Alphanumeric Field
        LOCASV: Creating a Variable Length Lowercase String
        POSITV: Finding the Beginning of a Variable Length Substring
        SUBSTV: Extracting a Variable Length Substring
        TRIMV: Removing Characters From a String
        UPCASV: Creating a Variable Length Uppercase String
      Character Functions for DBCS Code Pages
        DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
        DEDIT: Extracting or Adding Characters
        DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
        DSUBSTR: Extracting a Substring
        JPTRANS: Converting Japanese Specific Characters
      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_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
        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
        HHMMSS: Retrieving the Current Time
        HINPUT: Converting an Alphanumeric String to a Date-Time Value
        HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
        HMASK: Extracting Components of a Date-Time Field 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
      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
        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 Between a Blank and a 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: Calculating Standard Cumulative Normal Distribution
        NORMSINV: Calculating Inverse Cumulative Normal Distribution
        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
        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
        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
      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
    Functions Overview
      Function Arguments
      Function Categories
      Character Chart for ASCII and EBCDIC
    Character Functions
      ARGLEN: Measuring the Length of a String
      ASIS: Distinguishing Between Space and Zero
      BITSON: Determining If a Bit Is On or Off
      BITVAL: Evaluating a Bit String as an Integer
      BYTVAL: Translating a Character to Decimal
      CHKFMT: Checking the Format of a String
      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
    Variable Length Character Functions
      Overview
      LENV: Returning the Length of an Alphanumeric Field
      LOCASV: Creating a Variable Length Lowercase String
      POSITV: Finding the Beginning of a Variable Length Substring
      SUBSTV: Extracting a Variable Length Substring
      TRIMV: Removing Characters From a String
      UPCASV: Creating a Variable Length Uppercase String
    Character Functions for DBCS Code Pages
      DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
      DEDIT: Extracting or Adding Characters
      DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
      DSUBSTR: Extracting a Substring
      JPTRANS: Converting Japanese Specific Characters
    Data Source and Decoding Functions
      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
      FIYR: Obtaining the Financial Year
      FIQTR: Obtaining the Financial Quarter
      FIYYQ: Converting a Calendar Date to a Financial Date
      TODAY: Returning the Current Date
      Using Legacy Date Functions
      AYM: Adding or Subtracting Months
      AYMD: Adding or Subtracting Days
      CHGDAT: Changing How a Date String Displays
      DA Functions: Converting a Legacy Date to an Integer
      DMY, MDY, YMD: Calculating the Difference Between Two Dates
      DOWK and DOWKL: Finding the Day of the Week
      DT Functions: Converting an Integer to a Date
      GREGDT: Converting From Julian to Gregorian Format
      JULDAT: Converting From Gregorian to Julian Format
      YM: Calculating Elapsed Months
    Date-Time Functions
      Using Date-Time Functions
      HADD: Incrementing a Date-Time Value
      HCNVRT: Converting a Date-Time Value to Alphanumeric Format
      HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
      HDIFF: Finding the Number of Units Between Two Date-Time Values
      HDTTM: Converting a Date Value to a Date-Time Value
      HGETC: Storing the Current Date and Time in a Date-Time Field
      HHMMSS: Retrieving the Current Time
      HINPUT: Converting an Alphanumeric String to a Date-Time Value
      HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
      HNAME: Retrieving a Date-Time Component in Alphanumeric Format
      HPART: Retrieving a Date-Time Component as a Numeric Value
      HSETPT: Inserting a Component Into a Date-Time Value
      HTIME: Converting the Time Portion of a Date-Time Value to a Number
      HTMTOTS: Converting a Time to a Timestamp
      HYYWD: Returning the Year and Week Number From a Date-Time Value
    Format Conversion Functions
      ATODBL: Converting an Alphanumeric String to Double-Precision Format
      EDIT: Converting the Format of a Field
      FPRINT: Converting Fields to Alphanumeric Format
      FTOA: Converting a Number to Alphanumeric Format
      HEXBYT: Converting a Decimal Integer to a Character
      ITONUM: Converting a Large Number to Double-Precision Format
      ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
      ITOZ: Converting a Number to Zoned Format
      PCKOUT: Writing a Packed Number of Variable Length
      PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
      UFMT: Converting an Alphanumeric String to Hexadecimal
      XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
    Numeric Functions
      ABS: Calculating Absolute Value
      CHKPCK: Validating a Packed Field
      DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
      EXP: Raising e to the Nth Power
      EXPN: Evaluating a Number in Scientific Notation
      INT: Finding the Greatest Integer
      LOG: Calculating the Natural Logarithm
      MAX and MIN: Finding the Maximum or Minimum Value
      NORMSDST: Calculating Standard Cumulative Normal Distribution
      NORMSINV: Calculating Inverse Cumulative Normal Distribution
      PRDNOR and PRDUNI: Generating Reproducible Random Numbers
      RDNORM and RDUNIF: Generating Random Numbers
      SQRT: Calculating the Square Root
    System Functions
      CLSDDREC: Closing All Files Opened by the PUTDDREC Function
      FEXERR: Retrieving an Error Message
      FGETENV: Retrieving the Value of an Environment Variable
      FPUTENV: Assigning a Value to an Environment Variable
      GETUSER: Retrieving a User ID
      PUTDDREC: Writing a Character String as a Record in a Sequential File
      SLEEP: Suspending Execution for a Given Number of Seconds
    SQL Character Functions
      CHAR_LENGTH: Finding the Length of a Character String
      CONCAT: Concatenating Two Character Strings
      DIGITS: Converting a Numeric Value to a Character String
      EDIT: Editing a Value According to a Format (SQL)
      LCASE: Converting a Character String to Lowercase
      LTRIM: Removing Leading Spaces
      POSITION: Finding the Position of a Substring
      RTRIM: Removing Trailing Spaces
      SUBSTR: Extracting a Substring From a String Value (SQL)
      TRIM: Removing Leading or Trailing Characters (SQL)
      UCASE: Converting a Character String to Uppercase
      VARGRAPHIC: Converting to Double-byte Character Data
    SQL Date and Time Functions
      CURRENT_DATE: Obtaining the Date
      CURRENT_TIME: Obtaining the Time
      CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
      DAY: Obtaining the Day of the Month From a Date/Timestamp
      DAYS: Obtaining the Number of Days Since January 1, 1900
      EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
      HOUR: Obtaining the Hour From Time/Timestamp
      MICROSECOND: Obtaining Microseconds From Time/Timestamp
      MILLISECOND: Obtaining Milliseconds From Time/Timestamp
      MINUTE: Obtaining the Minute From Time/Timestamp
      MONTH: Obtaining the Month From Date/Timestamp
      SECOND: Obtaining the Second Field From Time/Timestamp
      YEAR: Obtaining the Year From Date/Timestamp
    SQL Data Type Conversion Functions
      CAST: Converting to a Specific Data Type
      CHAR: Converting to a Character String
      DATE: Converting to a Date
      DECIMAL: Converting to Decimal Format
      FLOAT: Converting to Floating Point Format
      INT: Converting to an Integer
      SMALLINT: Converting to a Small Integer
      TIME: Converting to a Time
      TIMESTAMP: Converting to a Timestamp
    SQL Numeric Functions
      ABS: Returning an Absolute Value (SQL)
      LOG: Returning a Logarithm (SQL)
      SQRT Returning a Square Root (SQL)
    SQL Miscellaneous Functions
      COUNTBY: Incrementing Column Values Row by Row
      HEX: Converting to Hexadecimal
      IF: Testing a Condition
      LENGTH: Obtaining the Physical Length of a Data Item
      VALUE: Coalescing Data Values
    SQL Operators
      CASE: SQL Case Operator
      COALESCE: Coalescing Data Values
      NULLIF: NULLIF Operator
    Launch PDF
  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
      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 Process Flows
      Performing Server Administration Tasks
      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
      Main Menu
      Toolbars
      Text Editor Toolbar
      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 Stored Procedures
      Adding E-Mail 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
      Use a Variable in a Synonym
      Creating, Enhancing, and Editing Synonyms Using Modeling View
      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
      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 a FTP Server
      Loading a Star Schema
      Iterating Through Multiple Tables
    Change Data Capture
      Tutorial: Using Change Data Capture
      Enabling Database for Logging
      CDC Configuration
    DataMigrator Log Statistics and Tables
      Log and Statistics Tables
    Event-Based Scheduling
      Starting Flows With CMRUN
      Starting Flows With CMASAP
      Starting Flows With Your Own API Program
      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 From the Web Console
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Configuring a Central Relational Repository Model
      Configuring Many-to-One Monitoring
      Overview of Enterprise Monitoring
      Configuring the Repository Server
      Configuring the Non-Repository Server
    Resource Analyzer Report Options
      Reports Overview
      Resource Analyzer Reporting
      Resource Analyzer Report Options
      General Reports
      Usage Analysis Reports
      Domain Analysis Report
      Impact Analysis Report
      Performance Analysis Reports
      Network Analysis Reports
      Graph 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)
      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 From the Web Console
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Configuring a Central Relational Repository Model
      Configuring Many-to-One Monitoring
      Overview of Enterprise Monitoring
      Configuring the Repository Server
      Configuring the Non-Repository Server
    Creating Business Rules
      Creating Business Rules
    Resource Governor Administration
      The Resource Governor Administrator on the Web Console
      Usage Monitoring
      Rule Parameters
      Building Rules
      Governing
    Resource Governor Reports
      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)
      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 Administration
      Server Introduction
        Using the Web Console
        My Console Options
        Configuration Overview
        Running and Configuring the FOCUS Database Server (z/OS Only)
        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
      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
        Reports and Help
        Restricting the Use of APP Commands
        Accessing Metadata and Procedures
        Allocating Temporary Files
        Temporary Space Allocation for UNIX and z/OS UNIX System Services
        Temporary File Directory Structure for Non-PDS Deployment
      Data Adapters
        Configuring an Adapter
        Changing the Adapter Configuration
        Configuring a Remote Server
      Metadata
        Creating Synonyms
        Testing Synonyms
        Managing Synonyms
        Metadata Wizard
      Stored Procedures
        Creating a Stored Procedure
        Editing a Stored Procedure
        Running a Stored Procedure
        Scheduling a Procedure
        Sending an E-mail Notification for a Procedure
        Stress Testing a Procedure
        Running Impact Analysis Reports
      Server Workspace Manager
        Configuring Workspace Manager
        Workspace Configuration Settings
        Editing Configuration Files
        Fine-Tuning the Server
        Monitoring Server Activity
      Listeners and Special Services
        Using the Listeners and Special Services Configuration Panes
      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 USS/HFS Deployment
        Retrieving IBISNAP Output
        Recording and Reproducing User Actions
        Troubleshooting the Console
        Workspace Manager Safe Mode
        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
      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 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 Enterprise Java Beans
        Preparing the Web Application Server Environment
        Configuring the Adapter for Enterprise Java Beans
        Managing Enterprise Java Beans Metadata
      Using the Adapter for ERwin
        Preparation Steps for ERwin
        Configuring the Adapter for ERwin
        Enhancing Synonyms With ERwin Metadata
      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
        Modifying Essbase Data
      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)
      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 HP Neoview
        Preparing the HP Neoview Environment
        Configuring the Adapter for HP Neoview
        Managing HP Neoview Metadata
        Customizing the HP Neoview 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 Information Manager
        IBM Information/Management
        How the Server Works With Information/Management
        InfoMan Hardware and Software Requirements
        Configuring the Adapter for InfoMan
        Defining the Adapter for InfoMan User ID and Session ID
        InfoMan Access Control
        Server Security in InfoMan
        IBM Information/Management Database Security
        AUTOIMAN Configuration File
        Describing InfoMan Data Sources
        Executing AUTOIMAN
        Working With AUTOIMAN
        Master File Generation Facility in InfoMan
        PIDT Selection Panel in InfoMan
        Retrieval PIDT Name Confirmation in InfoMan
      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
        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 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 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 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 MetaMatrix
        Preparing the MetaMatrix Environment
        Configuring the Adapter for MetaMatrix
        Managing MetaMatrix Metadata
        Customizing the MetaMatrix 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 2000 Analysis Services (MS OLAP)
        Preparing the Microsoft SQL Server 2000 Analysis Services (MS OLAP) Environment
        Configuring the Adapter for Microsoft SQL Server 2000 Analysis Services (MS OLAP)
        Managing Microsoft SQL Server 2000 Analysis Services (MS OLAP) Metadata
        Customizing the Microsoft SQL Server 2000 Analysis Services (MS OLAP) Environment
      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 MQSeries
        Preparing the MQSeries Environment
        Configuring the Adapter for MQSeries
        Managing MQSeries Metadata
        Customizing the MQSeries Environment
      Using the Adapter for Digital Standard Mumps
        Preparing the Mumps Environment
        Configuring the Adapter for Digital Standard Mumps
        Managing Mumps Metadata
        Including Records in a Mumps Data Source
      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
        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 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 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 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 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 Supra
        Preparing the Supra Environment
        Configuring the Adapter for Supra
        Supra Overview and Mapping Considerations
        Managing Supra Metadata
        Supra Modules
        Adapter Tracing
      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 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 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 XBRL
        What Is XBRL?
        Configuring the Adapter for XBRL
        Reporting Against XBRL Instance Documents
        Reporting on Dimensions
      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 Release Notes
      General Information
      Known Issues in 7.7
      Adapter for DB2 on IBM i
      Adapter for ODBC
      Adapter for Oracle
      Adapter for PeopleSoft
      Adapter Support
      Connector for OLE DB
      DB2 Extender
      DataMigrator
      Resource Analyzer
      Run Deferred Option Changed to Submit With Options
      Running or Sharing 77x and 76x on the Same Machine
      Migration From SPG, TPG or AAS to Full Function Server for CICS Transactions
      Platform Support
      Launch PDF
    Server Installation
      Introduction to Server Installation
        Server Versions
        What to Read After You Install the Server
      Server Installation for Windows
        Installation Requirements
        Installation and Configuration Directories
        Accessing the Installation Software
        Installing a Server
        Verifying Server Installation
        Choosing a Security Mode
        Additional Server Installation Options
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a Windows Installation
        Troubleshooting for Windows
      Server Installation for UNIX
        Installation Requirements
        Installation and Configuration Directories
        Installing a Server
        Verifying Server Installation
        Choosing a Security Mode
        Starting and Using a Server
        Generating a Trace
        Third-Party Software and Licenses
        General Information for a UNIX Installation
        Troubleshooting for UNIX
      Server Installation for z/OS
        Server Installation for HFS & PDS
        HFS Deployment
        PDS Deployment
      Server 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. Configuring the Server With Different Security Modes
        Starting and Using the Server
        Other IBM i Start Up Options
        Accessing IFS Files and QSYS Libraries
        Generating a Trace
        Third-Party Software and Licenses
        Troubleshooting for IBM i
      Server Installation for OpenVMS
        Step 1. Checking System Requirements
        Step 2. Creating User IDs
        Step 3. Accessing the Installation Software
        Step 4. Running the Setup Procedure
        Step 5. Verifying the Server Installation
        Step 6. Configuring the Server With Different Security Modes
        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
      Introducing Stored Procedures
        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 EDARPC
        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
      Writing a Dialogue Manager Procedure
        Commands Included in a Procedure
        Commands and Processing
        Commenting a Procedure
        Sending a Message to a Client Application
        Controlling Execution
        Using Variables
        Supplying Values for Variables
        Branching
        Looping
        Calling Another Procedure
        The -REMOTE Commands
        Reading From and Writing to an External File
        .EVAL Operator
        Creating Expressions
        Using Functions
        Using Commands Specific to an Operating System
        ON TABLE HOLD
        ON TABLE PCHOLD
      Platform-Specific Commands and Features
        DYNAM Command (MVS)
        Comparison of TSO Commands, JCL, and DYNAM
        DDNAME Translation in User-Written Subroutines: MSODDX
        FILEDEF Command Under VM
        FILEDEF Command Under UNIX, Windows, IBM i, z/OS, and OpenVMS
      Dialogue Manager Quick Reference
        Dialogue Manager Commands
      GENCPGM Usage
        Using GENCPGM
        Subroutine Source Examples and Runtime Testing
      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
        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
      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 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: EXL07, EXL2K, EXL97, EXCEL
        Using PowerPoint 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 an HTML TOC to a Report
        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
        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 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
        Adding Underlines and Skipped Lines
        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
        Support for Repeated Headings and Footings on Panels in PDF Report Output
        Customizing a Column Title
        Controlling Column Title Underlining
        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, EXL07, 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
        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 Long and 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
        Providing Descriptive Information for a Data Source: REMARKS
        Specifying a Physical File Name: DATASET
      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
        Parameterizing Master and Access File Values Using Variables
        Describing a Filter: FILTER
        Describing a Calculated Value: COMPUTE
        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
        Comparing Static and Dynamic Joins
        Joining to One Cross-Referenced Segment From Several Host Segments
      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
        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
        Reports and Help
        Restricting the Use of APP Commands
        Accessing Metadata and Procedures
        Allocating Temporary Files
        Temporary Space Allocation for UNIX and z/OS UNIX System Services
        Temporary File Directory Structure for Non-PDS Deployment
      Coding a User Interface
        Which Tools Can You Use?
        The WebFOCUS Client
        Using the Servlet
        Using ISAPI
        Using CGI
        Using a Dynamic Multi-Select 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 Web Page 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 Parameter Values Categorized by Functional Area
        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
        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
      Using the Command Console
        Command Console Window
        Working in the Command Console
      Migrating Applications to Version 7
        Before You Begin Migrating
        The Migration Process
        After the Migration Process
      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
        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
      Variable Length Character Functions
        Overview
        LENV: Returning the Length of an Alphanumeric Field
        LOCASV: Creating a Variable Length Lowercase String
        POSITV: Finding the Beginning of a Variable Length Substring
        SUBSTV: Extracting a Variable Length Substring
        TRIMV: Removing Characters From a String
        UPCASV: Creating a Variable Length Uppercase String
      Character Functions for DBCS Code Pages
        DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
        DEDIT: Extracting or Adding Characters
        DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
        DSUBSTR: Extracting a Substring
        JPTRANS: Converting Japanese Specific Characters
      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_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
        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
        HHMMSS: Retrieving the Current Time
        HINPUT: Converting an Alphanumeric String to a Date-Time Value
        HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
        HMASK: Extracting Components of a Date-Time Field 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
      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
        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 Between a Blank and a 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: Calculating Standard Cumulative Normal Distribution
        NORMSINV: Calculating Inverse Cumulative Normal Distribution
        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
        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
        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
      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
    Functions Overview
      Function Arguments
      Function Categories
      Character Chart for ASCII and EBCDIC
    Character Functions
      ARGLEN: Measuring the Length of a String
      ASIS: Distinguishing Between Space and Zero
      BITSON: Determining If a Bit Is On or Off
      BITVAL: Evaluating a Bit String as an Integer
      BYTVAL: Translating a Character to Decimal
      CHKFMT: Checking the Format of a String
      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
    Variable Length Character Functions
      Overview
      LENV: Returning the Length of an Alphanumeric Field
      LOCASV: Creating a Variable Length Lowercase String
      POSITV: Finding the Beginning of a Variable Length Substring
      SUBSTV: Extracting a Variable Length Substring
      TRIMV: Removing Characters From a String
      UPCASV: Creating a Variable Length Uppercase String
    Character Functions for DBCS Code Pages
      DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
      DEDIT: Extracting or Adding Characters
      DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
      DSUBSTR: Extracting a Substring
      JPTRANS: Converting Japanese Specific Characters
    Data Source and Decoding Functions
      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
      FIYR: Obtaining the Financial Year
      FIQTR: Obtaining the Financial Quarter
      FIYYQ: Converting a Calendar Date to a Financial Date
      TODAY: Returning the Current Date
      Using Legacy Date Functions
      AYM: Adding or Subtracting Months
      AYMD: Adding or Subtracting Days
      CHGDAT: Changing How a Date String Displays
      DA Functions: Converting a Legacy Date to an Integer
      DMY, MDY, YMD: Calculating the Difference Between Two Dates
      DOWK and DOWKL: Finding the Day of the Week
      DT Functions: Converting an Integer to a Date
      GREGDT: Converting From Julian to Gregorian Format
      JULDAT: Converting From Gregorian to Julian Format
      YM: Calculating Elapsed Months
    Date-Time Functions
      Using Date-Time Functions
      HADD: Incrementing a Date-Time Value
      HCNVRT: Converting a Date-Time Value to Alphanumeric Format
      HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
      HDIFF: Finding the Number of Units Between Two Date-Time Values
      HDTTM: Converting a Date Value to a Date-Time Value
      HGETC: Storing the Current Date and Time in a Date-Time Field
      HHMMSS: Retrieving the Current Time
      HINPUT: Converting an Alphanumeric String to a Date-Time Value
      HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
      HNAME: Retrieving a Date-Time Component in Alphanumeric Format
      HPART: Retrieving a Date-Time Component as a Numeric Value
      HSETPT: Inserting a Component Into a Date-Time Value
      HTIME: Converting the Time Portion of a Date-Time Value to a Number
      HTMTOTS: Converting a Time to a Timestamp
      HYYWD: Returning the Year and Week Number From a Date-Time Value
    Format Conversion Functions
      ATODBL: Converting an Alphanumeric String to Double-Precision Format
      EDIT: Converting the Format of a Field
      FPRINT: Converting Fields to Alphanumeric Format
      FTOA: Converting a Number to Alphanumeric Format
      HEXBYT: Converting a Decimal Integer to a Character
      ITONUM: Converting a Large Number to Double-Precision Format
      ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
      ITOZ: Converting a Number to Zoned Format
      PCKOUT: Writing a Packed Number of Variable Length
      PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
      UFMT: Converting an Alphanumeric String to Hexadecimal
      XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
    Numeric Functions
      ABS: Calculating Absolute Value
      CHKPCK: Validating a Packed Field
      DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
      EXP: Raising e to the Nth Power
      EXPN: Evaluating a Number in Scientific Notation
      INT: Finding the Greatest Integer
      LOG: Calculating the Natural Logarithm
      MAX and MIN: Finding the Maximum or Minimum Value
      NORMSDST: Calculating Standard Cumulative Normal Distribution
      NORMSINV: Calculating Inverse Cumulative Normal Distribution
      PRDNOR and PRDUNI: Generating Reproducible Random Numbers
      RDNORM and RDUNIF: Generating Random Numbers
      SQRT: Calculating the Square Root
    System Functions
      CLSDDREC: Closing All Files Opened by the PUTDDREC Function
      FEXERR: Retrieving an Error Message
      FGETENV: Retrieving the Value of an Environment Variable
      FPUTENV: Assigning a Value to an Environment Variable
      GETUSER: Retrieving a User ID
      PUTDDREC: Writing a Character String as a Record in a Sequential File
      SLEEP: Suspending Execution for a Given Number of Seconds
    SQL Character Functions
      CHAR_LENGTH: Finding the Length of a Character String
      CONCAT: Concatenating Two Character Strings
      DIGITS: Converting a Numeric Value to a Character String
      EDIT: Editing a Value According to a Format (SQL)
      LCASE: Converting a Character String to Lowercase
      LTRIM: Removing Leading Spaces
      POSITION: Finding the Position of a Substring
      RTRIM: Removing Trailing Spaces
      SUBSTR: Extracting a Substring From a String Value (SQL)
      TRIM: Removing Leading or Trailing Characters (SQL)
      UCASE: Converting a Character String to Uppercase
      VARGRAPHIC: Converting to Double-byte Character Data
    SQL Date and Time Functions
      CURRENT_DATE: Obtaining the Date
      CURRENT_TIME: Obtaining the Time
      CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
      DAY: Obtaining the Day of the Month From a Date/Timestamp
      DAYS: Obtaining the Number of Days Since January 1, 1900
      EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
      HOUR: Obtaining the Hour From Time/Timestamp
      MICROSECOND: Obtaining Microseconds From Time/Timestamp
      MILLISECOND: Obtaining Milliseconds From Time/Timestamp
      MINUTE: Obtaining the Minute From Time/Timestamp
      MONTH: Obtaining the Month From Date/Timestamp
      SECOND: Obtaining the Second Field From Time/Timestamp
      YEAR: Obtaining the Year From Date/Timestamp
    SQL Data Type Conversion Functions
      CAST: Converting to a Specific Data Type
      CHAR: Converting to a Character String
      DATE: Converting to a Date
      DECIMAL: Converting to Decimal Format
      FLOAT: Converting to Floating Point Format
      INT: Converting to an Integer
      SMALLINT: Converting to a Small Integer
      TIME: Converting to a Time
      TIMESTAMP: Converting to a Timestamp
    SQL Numeric Functions
      ABS: Returning an Absolute Value (SQL)
      LOG: Returning a Logarithm (SQL)
      SQRT Returning a Square Root (SQL)
    SQL Miscellaneous Functions
      COUNTBY: Incrementing Column Values Row by Row
      HEX: Converting to Hexadecimal
      IF: Testing a Condition
      LENGTH: Obtaining the Physical Length of a Data Item
      VALUE: Coalescing Data Values
    SQL Operators
      CASE: SQL Case Operator
      COALESCE: Coalescing Data Values
      NULLIF: NULLIF Operator
    Launch PDF
  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
      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 Process Flows
      Performing Server Administration Tasks
      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
      Main Menu
      Toolbars
      Text Editor Toolbar
      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 Stored Procedures
      Adding E-Mail 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
      Use a Variable in a Synonym
      Creating, Enhancing, and Editing Synonyms Using Modeling View
      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
      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 a FTP Server
      Loading a Star Schema
      Iterating Through Multiple Tables
    Change Data Capture
      Tutorial: Using Change Data Capture
      Enabling Database for Logging
      CDC Configuration
    DataMigrator Log Statistics and Tables
      Log and Statistics Tables
    Event-Based Scheduling
      Starting Flows With CMRUN
      Starting Flows With CMASAP
      Starting Flows With Your Own API Program
      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 From the Web Console
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Configuring a Central Relational Repository Model
      Configuring Many-to-One Monitoring
      Overview of Enterprise Monitoring
      Configuring the Repository Server
      Configuring the Non-Repository Server
    Resource Analyzer Report Options
      Reports Overview
      Resource Analyzer Reporting
      Resource Analyzer Report Options
      General Reports
      Usage Analysis Reports
      Domain Analysis Report
      Impact Analysis Report
      Performance Analysis Reports
      Network Analysis Reports
      Graph 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)
      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 From the Web Console
      Configuring Resource Management
      Administering Resource Management From the Web Console
      Migrating the Resource Management Repository
      Event Routing
    Configuring a Central Relational Repository Model
      Configuring Many-to-One Monitoring
      Overview of Enterprise Monitoring
      Configuring the Repository Server
      Configuring the Non-Repository Server
    Creating Business Rules
      Creating Business Rules
    Resource Governor Administration
      The Resource Governor Administrator on the Web Console
      Usage Monitoring
      Rule Parameters
      Building Rules
      Governing
    Resource Governor Reports
      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)
      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