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