DataMigrator Server/WebFOCUS Reporting Server Technical Library
Technical Support
Technical Support
Release 7706/81
WebFOCUS Reporting Server
Server New Features
Server Enhancements
Applications
Configuration and Monitoring
Core Server and Clients
Diagnostics
Metadata
National Language Support
Security
Web Console
Adapter Enhancements
All Adapters
SQL Adapters
ERP Adapters
OLAP Adapters
DBMS Adapters
Procedures Adapters
Sequential and Indexed Adapters
Social Media Adapters
XML-Based Adapters
DataMigrator Enhancements
Check File
Dependencies Analysis Report
Updating Synonyms
Quick ETL Copy
Copying Selected Columns Using Quick ETL Copy
Copy Server Node
Noncontiguous Keys
Global Variables Editor
Updates for Type I Fields
Annotations in Flows
Finding Text in SQL Object
Extended Load Bulk Enhancements
Loading Images From Files
JSON Document Target
WHERE Calculator Support for ANY and ALL
Impact Analysis Enhancements
Slowly Changing Dimensions
Extended Bulk Load Utility for MS SQL ODBC Adapter
Transformation Calculator Enhancements
New SQL Functions
Data Profiling Drill-Down Reports for Patterns
Managing Object Groups In A Flow
Using Source Control on Multiple Files
Find Available for Data and Process Flows
Undo and Redo Capability
Segment Qualifications in Synonym Editor
Email File Types for a Process Flow
Non-Zero Return Code Lines in DataMigrator Log
ETLLOG Enhancements
Using SFTP as a Data Source
Option to Continue Processing on Partial Answer Set
Allowing Iterator for Non-DataMigrator Jobs
Support Change Data Capture for MS SQL 2012
Reading a Field With Delimited Values as Individual Rows
SCD Type I Flow Updates
File Types on EDAMAIL or on a Flow
Display of Long Procedure Names
Calculate Format for Expression In Transformation Grid
Specifying USAGE Attributes for Datetime Fields
Balloon Tips to Show Error or Information Messages
Batch Command for Data Profiling and Key Analysis
Source Control File Types
Resource Analyzer and Resource Governor Enhancements
New Errors and Messages Report
Monitoring Commands Enhancements
Sybase ASA Supported
Maximum Memory Used for Log File Records
Enhanced Administration for Thresholds and Business Rules
Enhanced Governor Business Rules Menu
Monitored Generated SQL Statements and Aggregation Messages
New Report to Display All Governor Rule File Properties
Reporting Language Enhancements
Controlling Column Title Underlining Using a StyleSheet Attribute
Rolling Up Calculations on Summary Rows
Simplified Character Functions
Simplified Date and Date-Time Functions
CHECKPRIVS: Retrieving the Privilege State for the Connected User
Adding a Value Test to RESTRICT=NOPRINT
Using ACCEPT=SYNONYM in a Master File
Using Multiple Prefix Operators on the Same Measure in SUBTOTAL
Validating Parameter Values Without Data File Access: REGEX
Storing Localized Metadata in Language Files
Adding DBA Restrictions to the Join Condition
Launch PDF
Server Release Notes
Disabling the CSRF Token When Connecting From a Release 8.0.x Client
General Information
Adapter for ESSBASE
Adapter for Netezza
Adapter for MQSeries
Adapter for Red Brick
Adapter for JBoss
Adapter for Oracle
Adapter for Informix
Adapter for DB2 on IBM i
Adapter for JDBC
Adapter for PeopleSoft
Adapter for SQL Server Analysis Services (SSAS)
Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
JVM Requirements for Java Services
Connector for OLE DB
Resource Analyzer
Run With Options Changed to Submit With E-Mail
Running or Sharing 7.7.x and 7.6.x on the Same Machine
New CMRUN Executable
Platform Support
Active Technologies
Reporting Language
Server Security
Launch PDF
Adapter Administration
Introduction to Adapters
Processing Requests
Functions of an Adapter
Data Management
Metadata Services With SQLENGINE SET
Additional Master File Attributes
Using the Adapter for 1010data
Configuring the Adapter for 1010data
Managing 1010data Metadata
Customizing the 1010data Environment
Optimization Settings
Using the Adapter for Adabas
Preparing the Adabas Environment
Configuring the Adapter for Adabas
Adabas Overview
Managing Adabas Metadata
Overview of Master and Access Files
Master Files for Adabas
Access Files for Adabas
Mapping Adabas Descriptors
Mapping Adabas Files With Variable-Length Records and Repeating Fields
Using the GROUP Attribute to Cross-Reference Files
Platform-Specific Functionality
Customizing the Adabas Environment
Adabas Reporting Considerations
Adabas Writing Considerations
Adapter Navigation
Entry Segment Retrieval of Adabas Records
Descendant Periodic Groups and Multi-Value Fields
Descendant Adabas Records
Using the Adapter for Adabas Stored Procedures
Preparing the Adabas Stored Procedures Environment
Configuring the Adapter for Adabas Stored Procedures
Managing Adabas Stored Procedure Metadata
Invoking an Adabas Stored Procedure
Using the Adapter for Alchemy Sentiment Analysis
Overview
Configuring the Alchemy Sentiment Analysis Adapter
Creating Metadata and Sample Reports for the Alchemy Adapter
Examples
Using the Adapter for Axiom EPM
Preparing the Environment
Configuring the Adapter for Axiom EPM
Managing Axiom EPM Metadata
Managing Connections to Axiom EPM
Using Administrative Utilities
Using the Adapter for C9 INC
Preparing the C9 INC Environment
Configuring the Adapter for C9 INC
Managing C9 INC Metadata
Customizing the C9 INC Environment
Using the Adapter for Caché
Preparing the Caché Environment
Configuring the Adapter for Caché
Managing Caché Metadata
Customizing the Caché Environment
Optimization Settings
Using the Adapter for CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Configuring the Adapter for CICS Transactions
Managing CICS Transaction Metadata
Invoking a CICS Transaction
Running a TPG/SPG/AAS Transaction
Using the Adapters for C-ISAM and ISAM
Preparing the Environment
Configuring the Adapter
Managing C-ISAM Metadata
Maintaining C-ISAM Data Sources Using SQL Commands
Using a Secondary Index in C-ISAM and ISAM Files
Using the Adapter for DATACOM
Preparing the DATACOM Environment
Configuring the Adapter for DATACOM
DATACOM Overview and Mapping Considerations
Managing DATACOM Metadata
Master Files for DATACOM
Access Files for DATACOM
Describing Multi-File Structures for DATACOM
Data Retrieval Logic for DATACOM
Using the Adapter for DB2
Preparing the DB2 Environment
Configuring the Adapter for DB2
Managing DB2 Metadata
Reporting Against a DB2 Stored Procedure
Customizing the DB2 Environment
Optimization Settings
Using DB2 Cube Views
Calling a DB2 Stored Procedure Using SQL Passthru
Using the Adapter for DB Heritage Files
Preparing the DB Heritage Files Environment
Configuring the Adapter for DB Heritage Files
Managing DB Heritage Files Metadata
Standard Master File Attributes for a DB Heritage Files Data Source
Redefining a Field in a DB Heritage Files Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Multi-Format Logical Files
DB Heritage Files Record Selection Efficiencies
Using the Adapter for Essbase
Preparing the Essbase Environment
Configuring the Adapter for Essbase
Managing Essbase Metadata
Customizing the Essbase Environment
Essbase Reporting With WebFOCUS
Using the Adapter for Excel
Configuring the Adapter for Excel
Managing Excel Metadata
Customizing the Excel Environment
Optimization Settings
Using the Adapter for Excel (via Direct Retrieval)
Configuring the Adapter for Excel (via Direct Retrieval)
Managing Metadata for Excel (via Direct Retrieval)
Changing Adapter Settings
Using the Adapter for Facebook
Overview
Creating a Facebook Application
Configuring the Facebook Adapter
Creating Metadata and Sample Reports for the Facebook Adapter
Examples
Using the Adapters for Flat and Delimited Flat Files
Preparing the Environment
Configuring the Adapters for Flat and Delimited Flat Files
Managing Metadata for Flat and Delimited Flat Files
Using the Adapter for Google Analytics
Overview
Creating a Google Project
Obtaining the Web Profile ID
Configuring the Google Analytics Adapter
Creating Metadata for the Google Analytics Adapter
Using the Adapter for Greenplum
Configuring the Adapter for Greenplum
Managing Greenplum Metadata
Using the Adapter for Hadoop with Apache Hive and Cloudera Impala
Introducing the Adapter for Apache Hive and Cloudera Impala
Preparing the Environment
Configuring the Adapter for Hadoop/Hive/Impala
Creating Synonyms
Using Direct Pass-through
Loading Data Using DataMigrator
Using the Adapter for HP Vertica
Preparing the HP Vertica Environment
Configuring the Adapter for HP Vertica
Managing HP Vertica Metadata
Customizing the HP Vertica Environment
Optimization Settings
Using the Adapter for Hyperstage
Preparing the Hyperstage Environment
Configuring the Adapter for Hyperstage
Managing Hyperstage Metadata
Customizing the Adapter for the Hyperstage Environment
Optimization Settings
Using the Adapter for i Access
Preparing the i Access Environment
Configuring the Adapter for i Access
Managing i Access Metadata
Customizing the i Access Environment
Optimization Settings
Using the Adapter for CA-IDMS/DB
Preparing the IDMS/DB Environment
Configuring the Adapter for IDMS/DB
IDMS/DB Overview and Mapping Considerations
Managing IDMS/DB Metadata
Master Files for IDMS/DB
Access Files for IDMS/DB
IDMS/DB Sample File Descriptions
File Retrieval
Record Retrieval
Customizing the IDMS/DB Environment
Tracing the Adapter for IDMS/DB
Using the Adapter for CA-IDMS/SQL
Preparing the IDMS/SQL Environment
Configuring the Adapter for IDMS/SQL
Managing IDMS/SQL Metadata
Customizing the IDMS/SQL Environment
Optimization Settings
Using the Adapter for IMS
IMS Environments: Overview
Preparing the IMS Environment
Configuring the Adapter for IMS
Managing IMS Metadata
Master File Attributes
Access File Attributes (DBCTL)
Migrating From an Existing MVS Server (DBCTL)
WebFOCUS Reporting With IMS
Maintaining IMS Data Sources (DBCTL)
Using the Adapter for IMS Transactions
Preparing the IMS Transactions Environment
Supported Platforms and Release Information
Configuring the Adapter for IMS Transactions
Managing IMS Transactions Metadata
Invoking an IMS Transaction
Invoking an IMS Stored Procedure
Using the Adapter for Informix
Preparing the Informix Environment
Configuring the Adapter for Informix
Managing Informix Metadata
Customizing the Informix Environment
Optimization Settings
Calling an Informix Stored Procedure Using SQL Passthru
Using the Adapter for Ingres
Preparing the Ingres Environment
Configuring the Adapter for Ingres
Managing Ingres Metadata
Customizing the Ingres Environment
Optimization Settings
Using the Adapter for Interplex
Preparing the Interplex Environment
Configuring the Adapter for Interplex
Managing Interplex Metadata
Customizing the Interplex Environment
Optimization Settings
Using the Adapter for iWay Adapter Framework (IWAF)
Preparing the IWAF Environment
Configuring the Adapter for IWAF
Creating Synonyms
Using the Adapter for JBoss Application Server
Preparing the JBoss Application Server Environment
Configuring the Adapter for JBoss Application Server
Managing JBoss Application Server Metadata
Customizing the JBoss Application Server Environment
Optimization Settings
Using the Adapter for JDBC
Preparing the JDBC Environment
Configuring the Adapter for JDBC
Managing JDBC Metadata
Customizing the JDBC Environment
Optimization Settings
Using the Adapter for JD Edwards EnterpriseOne
Preparing the JD Edwards EnterpriseOne Environment
Overview of the Setup Process
Configuring the Adapter for JD Edwards EnterpriseOne
Creating Synonyms for JD Edwards EnterpriseOne
Refreshing the Metadata Repository
Refresh Security Extracts
Converting Synonyms for JD Edwards EnterpriseOne (Non IBM i Platforms Only)
Setting the UDCDIC Environment Variable (Windows only)
Using the Adapter for JD Edwards World
Installation Prerequisites
Configuring the Adapter for JD Edwards World
Managing JD Edwards World Metadata
Enabling JD Edwards World Security
Enabling Tracing
Frequently Asked Questions
Using the Adapter for JSON
Preparing the JSON Environment
Configuring the Adapter for JSON
Managing JSON Metadata
Using the Adapter for Lawson
Adapter for Lawson: Overview
Configuring the Adapter for Lawson
Preparing the Lawson Environment
Managing Lawson Metadata
Updating Lawson Security Information
Using the Adapter for LinkedIn
Overview
Creating a LinkedIn Application
Configuring the LinkedIn Adapter
Creating Metadata and Sample Reports for the LinkedIn Adapter
Examples
Using the Adapter for Lotus Notes
Preparing the Lotus Notes Environment
Configuring the Adapter for Lotus Notes
Managing Lotus Notes Metadata
Using the Adapter for LDAP
Preparing the LDAP Environment
Configuring the Adapter for LDAP
Managing LDAP Metadata
Using the Adapter for Microsoft Access
Preparing the Microsoft Access Environment
Configuring the Adapter for Microsoft Access
Managing Microsoft Access Metadata
Customizing the Microsoft Access Environment
Optimization Settings
Using the Adapter for Microsoft SQL Server
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server
Managing Microsoft SQL Server Metadata
Reporting Against a Microsoft SQL Server Stored Procedure
Customizing the Microsoft SQL Server Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Microsoft SQL Server Compatibility With ODBC
Using the Adapter for Microsoft SQL Server ODBC
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server ODBC
Managing Microsoft SQL Server ODBC Metadata
Reporting Against a Microsoft SQL Server ODBC Stored Procedure
Customizing the Microsoft SQL Server ODBC Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Using the Adapter for Millennium
Preparing the Server Environment for Millennium
Configuring the Adapter for Millennium
Preparing the Millennium Environment
Managing Millennium Metadata
Standard Master File Attributes for a Millennium Data Source
Using the Adapter for Model 204
Preparing the Model 204 Environment
Configuring the Adapter for Model 204
Model 204 Overview and Mapping Considerations
Managing Model 204 Metadata
Master Files for Model 204
Access Files for Model 204
Customizing the Model 204 Environment
Using Customized Security Exits
Adapter Tracing for Model 204
Using the Adapter for MongoDB
Introducing the Adapter for MongoDB
Preparing the Environment
Configuring the Adapter for MongoDB
Creating Synonyms
Limitations
Using the Adapter for MySQL
Preparing the MySQL Environment
Configuring the Adapter for MySQL
Managing MySQL Metadata
Customizing the Adapter for the MySQL Environment
Optimization Settings
Using the Adapter for NATURAL
Preparing the NATURAL Environment
Configuring the Adapter for NATURAL
Managing Metadata for NATURAL
Invoking a NATURAL Program
Using the Adapter for NATURAL CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Installing NATURAL Support Programs
Configuring the Adapter for NATURAL CICS Transactions
Managing NATURAL CICS Transactions Metadata
NATURAL Data Buffer Processing API
Invoking a NATURAL CICS Transaction
Using the Adapter for Netezza
Preparing the Netezza Environment
Unicode Support
Configuring the Adapter for Netezza
Managing Netezza Metadata
Customizing the Netezza Environment
Optimization Settings
Using the Adapter for Nucleus
Preparing the Nucleus Environment
Configuring the Adapter for Nucleus
Managing Nucleus Metadata
Customizing the Nucleus Environment
Optimization Settings
Using the Adapter for ODBC
Preparing the ODBC Environment
Configuring the Adapter for ODBC
Managing ODBC Metadata
Customizing the ODBC Environment
Optimization Settings
Using the Adapter for Oracle
Preparing the Oracle Environment
Configuring the Adapter for Oracle
Managing Oracle Metadata
Reporting Against an Oracle Stored Procedure
Customizing the Oracle Environment
Optimization Settings
Calling an Oracle Stored Procedure Using SQL Passthru
Using the Adapter for Oracle E-Business Suite
Preparing the Oracle E-Business Suite Environment
Data Access and Security
Configuring the Adapter for Oracle E-Business Suite
Maintaining Security Rules
Using the Adapter for Oracle TimesTen
Preparing the Oracle TimesTen Environment
Configuring the Adapter for Oracle TimesTen
Managing Oracle TimesTen Metadata
Customizing the Oracle TimesTen Environment
Optimization Settings
Using the Adapter for parAccel
Configuring the Adapter for parAccel
Managing parAccel Metadata
Using the Adapter for PeopleSoft
Preparing the Environment
Configuring the Adapter for PeopleSoft
Managing PeopleSoft Metadata
Managing PeopleSoft Secured Data Access
Managing Connections to PeopleSoft
Using Administrative Utilities
Migrating from 7.1x and 7.6.x to 7.7
Advanced Administrative Topics
Using the Adapter for PostgreSQL
Preparing the PostgreSQL Environment
Configuring the Adapter for PostgreSQL
Managing PostgreSQL Metadata
Customizing the PostgreSQL Environment
Optimization Settings
Using the Adapter for Progress
Preparing the Progress Environment
Configuring the Adapter for Progress
Managing Progress Metadata
Customizing the Progress Environment
Optimization Settings
Using the Adapter for PSQL
Preparing the PSQL Environment
Configuring the Adapter for PSQL
Managing PSQL Metadata
Customizing the PSQL Environment
Optimization Settings
Using the Adapter for Query/400
Preparing the Adapter for Query/400 Environment
Configuring the Adapter for Query/400
Managing Query/400 Metadata
Using the Adapter for Rdb
Preparing the Rdb Environment
Configuring the Adapter for Rdb
Managing Rdb Metadata
Using Multiple Rdb DBMS Files
Using Multischema Rdb DBMS Files
Rdb Database Driver Performance
Using the Adapter for Red Brick
Preparing the Red Brick Environment
Configuring the Adapter for Red Brick
Managing Red Brick Metadata
Customizing the Red Brick Environment
Optimization Settings
Using the Adapter for REST
Configuring the Adapter for REST
Managing RESTful Web Services Metadata
Using the Adapter for Remote Servers
Configuring Remote Servers
Managing Metadata for Remote Servers
Executing Stored Procedures
Using the Adapter for RMS
Preparing the RMS Environment
Configuring the Adapter for RMS
Managing RMS Metadata
Manually Describing RMS Files
Describing Complex RMS Keyed
Associating an RMS Data Source to a Master File
Retrieving Data From RMS Files
Syntax for RMS Master File Attributes
RMS Attribute Summary
Read/Write Usage Limitations of the Adapter for RMS
Using the Adapter for Salesforce.com
Configuring the Adapter for Salesforce.com
Creating Synonyms
Using the Adapter for SAP Business Intelligence Warehouse (BW)
Preparing the SAP BW Environment
Configuring the Adapter for SAP BW
Supporting Mixed Code Page Environments
Creating BEx Queries
SAP BW Reporting With WebFOCUS
Managing SAP BW Metadata
Customization Settings
Support for BEx Structures
Producing SAP BW Requests Using SQL
Using the Adapter for SAP
Preparing the SAP Environment
Accessing Multiple SAP Systems
Configuring the Adapter for SAP
Post-Configuration Tasks in an SAP Environment
Managing SAP Metadata
SAP Table Class Support for an Individual Table
SAP Support for a Function Module
SAP Data Type Support
SAP Open/SQL Support
Advanced SAP Features
Setting Up the Report Processing Mode
Supporting Mixed Code Page Environments
Producing SAP Requests
Using the Adapter for SAP Hana
Preparing the SAP Hana Environment
Configuring the Adapter for SAP Hana
Managing SAP Hana Metadata
Customizing the SAP Hana Environment
Optimization Settings
Using the Adapter for Siebel
Software Requirements for the Adapter for Siebel
Preparing the Siebel Environment
Preparing the Server Environment for Adapter Configuration
Configuring the Adapter for Siebel
Managing Siebel Metadata
Optimization Settings
Using the Adapter for SQLBase
Preparing the SQLBase Environment
Configuring the Adapter for SQLBase
Managing SQLBase Metadata
Customizing the SQLBase Environment
Optimization Settings
Using the Adapter for SQL Server Analysis Services (SSAS)
Preparing the SQL Server Analysis Services (SSAS) Environment
Configuring the Adapter for SQL Server Analysis Services
Managing SQL Server Analysis Services Metadata
Customizing the SQL Server Analysis Services Environment
SQL Server Analysis Services (SSAS) Reporting With WebFOCUS
Using the Adapter for Sybase
Preparing the Sybase Environment
Configuring the Adapter for Sybase
Managing Sybase Metadata
Reporting Against a Sybase Stored Procedure
Customizing the Sybase Environment
Optimization Settings
Calling a Sybase Stored Procedure Using SQL Passthru
Using the Adapter for Teradata
Preparing the Teradata Environment
Configuring the Adapter for Teradata
Managing Teradata Metadata
Reporting Against a Teradata Stored Procedure
Customizing the Teradata Environment
Optimization Settings
Calling a Teradata Macro or Stored Procedure Using SQL Passthru
Using the Adapter for Transoft
Preparing the Transoft Environment
Configuring the Adapter for Transoft
Managing Transoft Metadata
Customizing the Transoft Environment
Optimization Settings
Using the Adapter for Twitter
Overview
Creating a Twitter Application
Configuring the Twitter Adapter
Creating Metadata and Sample Reports for the Twitter Adapter
Examples
Using the Adapter for UniData
Preparing the UniData Environment
Configuring the Adapter for UniData
Managing UniData Metadata
Customizing the UniData Environment
Optimization Settings
Using the Adapter for UniVerse
Preparing the UniVerse Environment
Configuring the Adapter for UniVerse
Managing UniVerse Metadata
Customizing the UniVerse Environment
Optimization Settings
Using the Adapter for VSAM
Preparing the Environment for VSAM
Configuring the Adapter for VSAM
Managing VSAM Metadata
Associating a VSAM Data Source With a Master File
Standard Master File Attributes for a VSAM Data Source
Redefining a Field in a VSAM Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
VSAM Record Selection Efficiencies
Maintaining VSAM KSDS Data Sources
Using VSAM Relative Record Data Set (RRDS) Files
Reviewing SQL Updates to VSAM Data Sources
Using the Adapter for WAND Sentiment Analysis
Overview
Installing, Configuring, and Updating the WAND Taxonomy Server
Installing and Using the WAND Taxonomy Editor
Configuring the WAND Sentiment Analysis Adapter
Creating Metadata and Sample Reports for the WAND Sentiment Analysis Adapter
Examples
Using the Adapter for Web Services
Configuring the Adapter for Web Services
Managing Web Services Metadata
Capturing a SOAP Request Using FILEDEF SOAPTSCQ in a Procedure
Using the Adapter for Words Analysis
Overview
Configuring the Words Analysis Adapter
Creating Metadata and Sample Reports for the Words Analysis Adapter
Examples
Using the Adapter for XML
Preparing the XML Environment
Configuring the Adapter for XML
Managing XML Metadata
XA Support
XA Transaction Management
Supported Interfaces
Implementation
Vendor Specifics
Aggregate Awareness Support
Relational Adapters and Aggregated SQL Queries
Aggregate Awareness in an RDBMS
Cluster Join
Embedded Joins
Embedded Join Master Files
Translating COBOL File Descriptions
Creating Synonyms From COBOL File Descriptions
Controlling the Translation of a COBOL File Description
Data Set Compression Exit: ZCOMP
Invoking the ZCOMP Exit
What Happens When ZCOMP is LOADED?
Dynamic Private User Exit
FOCSAM and the GETPRV User Exit
Physical Implementation of the GETPRV Exit
Master File for Data Access With GETPRV
Access File for Data Access With GETPRV
Calling Parameters and Work Areas
Validation for Special Characters and Reserved Words
Validation for Special Characters
Validation for Reserved Words
Launch PDF
Server Administration
Server Introduction
Using the Web Console
Console Options
Other Icon Options
Configuration Overview
Running and Configuring the FOCUS Database and FOCUS Database Server
Server Profiles
Profile Commands
Server Security
Server Security Overview
Configuring Authentication
Configuring Privileges and Other Authorizations
Configuring Server Encryption
Access to Connection Information in WebFOCUS Procedures
Configuring the Server for Multi-Tenant Deployment
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Application Metadata Commands and Catalog Metadata
Help Information: APP HELP
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Data Adapters
Changing Common Adapter Settings
Configuring an Adapter
Changing the Adapter Configuration
Configuring a Remote Server
SQL Automatic Passthru Status
Determining SQL Optimization
Determining Function Parameters
Data Type Support Report
Social Media Adapters
Metadata
Creating Synonyms
Testing Synonyms
Managing Synonyms
Using the Wizards
Stored Procedures
Working With Stored Procedures
Creating a Stored Procedure
Sending Stored Procedure Report Output to Server-Side Printers
Editing a Stored Procedure
Running a Stored Procedure
Scheduling a Procedure
Sending an E-mail Notification for a Procedure
Procedure Run-Time Processing Essentials
Platform-Specific Commands and Features
Stress Testing a Procedure
Running Impact Analysis Reports
Server Workspace Manager
Configuring Workspace Manager
Workspace Configuration Settings
Editing Configuration Files
Configuring Java Services
Cluster Manager
Monitoring Server Activity
Listeners and Special Services
Using the Listeners and Special Services Configuration Panes
Special Services
Listeners
Troubleshooting
Viewing Version Information
Analyzing Server Activity
Analyzing FOCUS Database Server Activity
Tracing Server Activity
z/OS-Specific Troubleshooting for the Unified Server
z/OS-Specific Troubleshooting for z/OS HFS Deployment
Recording and Reproducing User Actions
Troubleshooting the Console
Server Processes
Gathering Diagnostic Information for Customer Support Services
Unicode Support
Unicode and the WebFOCUS Reporting Server
Accessing Unicode Data
Selecting, Reformatting, and Manipulating Characters
Sort Order Under Unicode
Added Unicode Support for Master Files, Data Files, and Application Directory Names
Unicode PDF Output
Platform-Specific Methods for Specifying EDAEXTSEC
Platform-Specific Methods for Setting EDAEXTSEC
Launch PDF
Server Installation
Introduction to Installation
Versions
What to Read After You Install
Installation for Windows
Installation Requirements
Accessing the Software
Installing
Installation and Configuration Directories
Verifying Installation
Starting and Using a Server or Data Management Console
Security Providers
Additional Installation Options
Generating a Trace
Third-Party Software and Licenses
General Information for a Windows Installation
Troubleshooting for Windows
Installation for UNIX
Installation Requirements
Installation and Configuration Directories
Installing
Verifying Installation
Security Providers
Starting and Using a Server
Generating a Trace
Third-Party Software and Licenses
General Information for a UNIX Installation
Troubleshooting for UNIX
Installation for z/OS
Installation for HFS and PDS
HFS Deployment
PDS Deployment
Installation for IBM i
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Installation Program
Step 5. Verifying the Server Installation
Step 6. Security Providers
Starting and Using the Server
CL and CMD Programs
General Information for an IBM i Installation
Generating a Trace
Third-Party Software and Licenses
Troubleshooting for IBM i
Installation for OpenVMS
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Setup Procedure
Step 5. Verifying the Installation
Step 6. Security Providers
Starting and Using the Server
Generating a Trace
Third-Party Software and Licenses
General Information for an OpenVMS Installation
Troubleshooting for OpenVMS
Information Builders and Third-Party Licenses
Information Builders License
OpenFlex SDK License
Zip Archiver License
Launch PDF
Stored Procedure Reference for 3GL Procedures
Introducing Stored Procedures
Using a Stored Procedure
Calling a Stored Procedure
Stored Procedure Libraries
Setting the Execution Order
Calling a Program as a Stored Procedure
Calling a Compiled Program
Calling a Program With CALLPGM or EXEC
Calling a Program With SQL EX
Passing Parameters
Program Communication
Calling a JAVA Class as a Stored Procedure
Execute Using CALLJAVA
Execute Using EX
Execute Using SQL EX and SQL CPJAVA EX
Passing Parameters
Writing a JAVA Class
JAVA Class Communication
Compiling and Running a JAVA Program
Writing a 3GL Compiled Stored Procedure Program
Program Requirements
Setting Up the Control Block
Storing Program Values
Error Handling
Issuing the CREATE TABLE Command
User Written Routines
Calling a User Written Routine
Using the GENCPGM Build Tool
Using GENCPGM
Additional 3GL Reference Examples
Subroutine Source Examples and Runtime Testing
MTHNAME C Implementation
MTHNAME C++ Implementation
MTHNAME Fortran Implementation
MTHNAME COBOL Implementation
MTHNAME z/OS BAL Assembler Implementation
MTHNAME Basic Implementation (Based on HP OpenVMS Basic 1.4)
MTHNAME RPG IBM i ILE Implementation
MTHNAME PL/1 Implementation
MTHNAME Pascal Implementation (Based on HP OpenVMS Pascal 5.8)
UREVERSE C Implementation
Launch PDF
Reporting Language
Creating Reports With WebFOCUS Language
Creating Reports Overview
Requirements for Creating a Report
Report Types
Reporting Tools
Developing Your Report Request
Customizing a Report
Selecting a Report Output Destination
Displaying Report Data
Using Display Commands in a Request
Displaying Individual Values
Adding Values
Counting Values
Expanding Byte Precision for COUNT and LIST
Maximum Number of Display Fields Supported in a Request
Manipulating Display Fields With Prefix Operators
Displaying Pop-up Field Descriptions for Column Titles
Sorting Tabular Reports
Sorting Tabular Reports Overview
Sorting Rows
Sorting Columns
Reformatting Sort Fields
Manipulating Display Field Values in a Sort Group
Creating a Matrix Report
Controlling Collation Sequence
Specifying the Sort Order
Ranking Sort Field Values
Grouping Numeric Data Into Ranges
Restricting Sort Field Values by Highest/Lowest Rank
Sorting and Aggregating Report Columns
Hiding Sort Values
Sorting With Multiple Display Commands
Improving Efficiency With External Sorts
Hierarchical Reporting: BY HIERARCHY
Selecting Records for Your Report
Selecting Records Overview
Choosing a Filtering Method
Selections Based on Individual Values
Selection Based on Aggregate Values
Using Compound Expressions for Record Selection
Using Operators in Record Selection Tests
Types of Record Selection Tests
Selections Based on Group Key Values
Setting Limits on the Number of Records Read
Selecting Records Using IF Phrases
Reading Selection Values From a File
Assigning Screening Conditions to a File
VSAM Record Selection Efficiencies
Creating Temporary Fields
What Is a Temporary Field?
Defining a Virtual Field
Creating a Calculated Value
Assigning Column Reference Numbers
Calculating Trends and Predicting Values With FORECAST
Calculating Trends and Predicting Values With Multivariate REGRESS
Using Text Fields in DEFINE and COMPUTE
Creating Temporary Fields Independent of a Master File
Including Totals and Subtotals
Calculating Row and Column Totals
Including Section Totals and a Grand Total
Including Subtotals
Recalculating Values for Subtotal Rows
Summarizing Alphanumeric Columns
Manipulating Summary Values With Prefix Operators
Combinations of Summary Commands
Producing Summary Columns for Horizontal Sort Fields
Performing Calculations at Sort Field Breaks
Suppressing Grand Totals
Conditionally Displaying Summary Lines and Text
Using Expressions
Using Expressions in Commands and Phrases
Types of Expressions
Creating a Numeric Expression
Creating a Date Expression
Creating a Date-Time Expression
Creating a Character Expression
Creating a Variable Length Character Expression
Creating a Logical Expression
Creating a Conditional Expression
Saving and Reusing Your Report Output
Saving Your Report Output
Creating a HOLD File
Holding Report Output in FOCUS Format
Controlling Attributes in HOLD Master Files
Keyed Retrieval From HOLD Files
Saving and Retrieving HOLD Files
Using DBMS Temporary Tables as HOLD Files
Creating SAVE and SAVB Files
Creating a PCHOLD File
Choosing Output File Formats
Using Text Fields in Output Files
Creating a Delimited Sequential File
Saving Report Output in INTERNAL Format
Creating A Subquery or Sequential File With HOLD FORMAT SQL_SCRIPT
Creating a Structured HOLD File
Specifying MIME Types for WebFOCUS Reports
Choosing a Display Format
Report Display Formats
Preserving Leading and Internal Blanks in Report Output
Using Web Display Format: HTML
Using Print Display Formats: PDF, PS
Using Word Processing Display Formats: DOC, WP
Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL
Using PowerPoint PPT Display Format
Using PowerPoint PPTX Display Format
Linking a Report to Other Resources
Linking Using StyleSheets
Linking to Another Report
Linking to a URL
Linking to a JavaScript Function
Linking to a WebFOCUS Maintain Procedure
Creating Multiple Drill-Down Links
Creating Parameters
Linking With Conditions
Linking From a Graphic Image
Specifying a Base URL
Specifying a Target Frame
Creating a Compound Report
Creating a PDF Compound Report With Drill Through Links
Navigating Within an HTML Report
Navigating Sort Groups From a Table of Contents
Adding the HTML Table of Contents Tree Control to Reports
Controlling the Display of Sorted Data With Accordion Reports
Navigating a Multi-Page Report With the WebFOCUS Viewer
Linking Report Pages
Bursting Reports Into Multiple HTML Files
Bursting Reports Overview
Handling Records With Missing Field Values
Irrelevant Report Data
Missing Field Values
Handling a Missing Segment Instance
Setting the NODATA Character String
Joining Data Sources
Types of Joins
How the JOIN Command Works
Creating an Equijoin
Using a Conditional Join
Full Outer Joins for Relational Data Sources
Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT
Joining From a Multi-Fact Synonym
Invoking Context Analysis for a Star Schema With a Fan Trap
Adding DBA Restrictions to the Join Condition: SET DBAJOIN
Preserving Virtual Fields During Join Parsing
Displaying Joined Structures
Clearing Joined Structures
Merging Data Sources
Merging Data
MATCH Processing
MATCH Processing With Common High-Order Sort Fields
Fine-Tuning MATCH Processing
Universal Concatenation
Merging Concatenated Data Sources
Cartesian Product
Formatting Reports: An Overview
What Kinds of Formatting Can I Do?
How to Specify Formatting in a Report
Standard and Legacy Formatting
Techniques for Quick and Easy Formatting
Navigating From a Report to Other Resources
Creating and Managing a WebFOCUS StyleSheet
Creating a WebFOCUS StyleSheet
General WebFOCUS StyleSheet Syntax
Reusing WebFOCUS StyleSheet Declarations With Macros
WebFOCUS StyleSheet Attribute Inheritance
Controlling Report Formatting
Generating an Internal Cascading Style Sheet for HTML Reports
Selecting a Unit of Measurement
Conditionally Formatting, Displaying, and Linking in a StyleSheet
Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
Conditionally Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
Controlling the Display of Empty Reports
Formatting a Report Using Only StyleSheet Defaults
Identifying a Report Component in a WebFOCUS StyleSheet
Identifying an Entire Report, Column, or Row
Identifying Tags for SUBTOTAL and GRANDTOTAL Lines
Identifying Data
Identifying a Heading, Footing, Title, or FML Free Text
Identifying a Page Number, Underline, or Skipped Line
Using an External Cascading Style Sheet
What Is a Cascading Style Sheet?
Why Use an External Cascading Style Sheet?
Formatting a Report With an External Cascading Style Sheet
Working With an External Cascading Style Sheet
Applying External Cascading Style Sheet Formatting
Combining an External CSS With Other Formatting Methods
Linking to an External Cascading Style Sheet
Inheritance and External Cascading Style Sheets
Using External Cascading Style Sheets With Non-HTML Reports
Requirements for Using an External Cascading Style Sheet
FAQ About Using External Cascading Style Sheets
Troubleshooting External Cascading Style Sheets
Laying Out the Report Page
Selecting Page Size, Orientation, and Color
Setting Page Margins
Positioning a Report Component
Arranging Columns on a Page
Suppressing Column Display
Inserting a Page Break
Inserting Page Numbers
Adding Grids and Borders
Defining Borders Around Boxes With PPTX and PDF Formats
Displaying Superscripts On Data, Heading, and Footing Lines
Adding Underlines and Skipped Lines
Removing Blank Lines From a Report
Adding an Image to a Report
Associating Bar Graphs With Report Data
Working With Mailing Labels and Multi-Pane Pages
Using Headings, Footings, Titles, and Labels
Creating Headings and Footings
Including an Element in a Heading or Footing
Repeating Headings and Footings on Panels in PDF Report Output
Customizing a Column Title
Controlling Column Title Underlining Using a SET Command
Controlling Column Title Underlining Using a StyleSheet Attribute
Creating Labels to Identify Data
Formatting a Heading, Footing, Title, or Label
Applying Font Attributes to a Heading, Footing, Title, or Label
Adding Borders and Grid Lines
Justifying a Heading, Footing, Title, or Label
Choosing an Alignment Method for Heading and Footing Elements
Aligning a Heading or Footing Element in an HTML, XLSX, EXL2K, or PDF Report
Aligning a Heading or Footing Element Across Columns in an HTML or PDF Report
Aligning Content in a Multi-Line Heading or Footing
Positioning Headings, Footings, or Items Within Them
Controlling the Vertical Positioning of a Heading or Footing
Placing a Report Heading or Footing on Its Own Page
Formatting Report Data
Specifying Font Format in a Report
Specifying Background Color in a Report
Specifying Data Format in a Report
Positioning Data in a Report
Creating a Graph
Content Analysis: Determining Graphing Objectives
The GRAPH Command
Creating an HTML5 Graph
Selecting a Graph Type
Selecting Values for the X and Y Axes
Creating Multiple Graphs
Plotting Dates in Graphs
Refining the Data Set For Your Graph
Displaying Missing Data Values in a Graph
Applying Conditional Styling to a Graph
Linking Graphs to Other Resources
Adding Labels to a Graph
Applying Custom Styling to a Graph
Saving a Graph as an Image File
Printing a Graph
Creating Financial Reports With Financial Modeling Language (FML)
Reporting With FML
Creating Rows From Data
Supplying Data Directly in a Request
Performing Inter-Row Calculations
Referring to Rows in Calculations
Referring to Columns in Calculations
Referring to Rows and Columns in Calculations
Referring to Cells in Calculations
Using Functions in RECAP Calculations
Inserting Rows of Free Text
Adding a Column to an FML Report
Creating a Recursive Model
Reporting Dynamically From a Hierarchy
Customizing a Row Title
Formatting an FML Report
Suppressing the Display of Rows
Saving and Retrieving Intermediate Report Results
Creating HOLD Files From FML Reports
Creating a Free-Form Report
Creating a Free-Form Report
Designing a Free-Form Report
Using SQL to Create Reports
Supported and Unsupported SQL Statements
Using SQL Translator Commands
SQL Translator Support for Date, Time, and Timestamp Fields
Index Optimized Retrieval
TABLEF Optimization
SQL INSERT, UPDATE, and DELETE Commands
Improving Report Processing
Rotating a Data Structure for Enhanced Retrieval
Optimizing Retrieval Speed for FOCUS Data Sources
Automatic Indexed Retrieval
Data Retrieval Using TABLEF
Preserving the Internal Matrix of Your Last Report
Compiling Expressions
Master Files and Diagrams
EMPLOYEE Data Source
JOBFILE Data Source
EDUCFILE Data Source
SALES Data Source
CAR Data Source
LEDGER Data Source
FINANCE Data Source
REGION Data Source
EMPDATA Data Source
TRAINING Data Source
COURSE Data Source
JOBHIST Data Source
JOBLIST Data Source
LOCATOR Data Source
PERSINFO Data Source
SALHIST Data Source
VIDEOTRK, MOVIES, and ITEMS Data Sources
VIDEOTR2 Data Source
Gotham Grinds Data Sources
Century Corp Data Sources
Error Messages
Displaying Messages
Table Syntax Summary and Limits
TABLE Syntax Summary
TABLEF Syntax Summary
MATCH Syntax Summary
FOR Syntax Summary
TABLE Limits
Referring to Fields in a Report Request
Referring to an Individual Field
Referring to Fields Using Qualified Field Names
Referring to All of the Fields in a Segment
Displaying a List of Field Names
Launch PDF
Describing Data With WebFOCUS Language
Understanding a Data Source Description
A Note About Data Source Terminology
What Is a Data Source Description?
How an Application Uses a Data Source Description
What Does a Master File Describe?
Creating a Data Source Description
Naming a Master File
What Is in a Master File?
Identifying a Data Source
Identifying a Data Source Overview
Specifying a Data Source Name: FILENAME
Identifying a Data Source Type: SUFFIX
Specifying Byte Order
Specifying Data Type: IOTYPE
Providing Descriptive Information for a Data Source: REMARKS
Specifying a Physical File Name: DATASET
Creating and Using a Master File Profile
Describing a Group of Fields
Defining a Single Group of Fields
Identifying a Logical View: Redefining a Segment
Relating Multiple Groups of Fields
Logical Dependence: The Parent-Child Relationship
Logical Independence: Multiple Paths
Cardinal Relationships Between Segments
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Recursive Relationships
Relating Segments From Different Types of Data Sources
Rotating a Data Source: An Alternate View
Describing an Individual Field
Field Characteristics
The Field Name: FIELDNAME
The Field Synonym: ALIAS
The Displayed Data Type: USAGE
The Stored Data Type: ACTUAL
Null or MISSING Values: MISSING
Describing an FML Hierarchy
Defining a Dimension: WITHIN
Validating Data: ACCEPT
Specifying Acceptable Values for a Dimension
Alternative Report Column Titles: TITLE
Documenting the Field: DESCRIPTION
Multilingual Metadata
Describing a Virtual Field: DEFINE
Describing a Calculated Value: COMPUTE
Describing a Filter: FILTER
Describing a Sort Object: SORTOBJ
Calling a DEFINE FUNCTION in a Master File
Using Date System Amper Variables in Master File DEFINEs
Parameterizing Master and Access File Values Using Variables
Converting Alphanumeric Dates to WebFOCUS Dates
Describing a Sequential, VSAM, or ISAM Data Source
Sequential Data Source Formats
Standard Master File Attributes for a Sequential Data Source
Standard Master File Attributes for a VSAM or ISAM Data Source
Describing a Multiply Occurring Field in a Free-Format Data Source
Describing a Multiply Occurring Field in a Fixed-Format, VSAM, or ISAM Data Source
Redefining a Field in a Non-FOCUS Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
Describing a Token-Delimited Data Source
Describing a FOCUS Data Source
Types of FOCUS Data Sources
Designing a FOCUS Data Source
Describing a Single Segment
GROUP Attribute
ACCEPT Attribute
INDEX Attribute
Describing a Partitioned FOCUS Data Source
Multi-Dimensional Index (MDI)
Defining a Join in a Master File
Join Types
Static Joins Defined in the Master File: SEGTYPE = KU and KM
Using Cross-Referenced Descendant Segments: SEGTYPE = KL and KLU
Dynamic Joins Defined in the Master File: SEGTYPE = DKU and DKM
Conditional Joins in the Master File
Comparing Static and Dynamic Joins
Joining to One Cross-Referenced Segment From Several Host Segments
Creating a Cluster Master File
Creating a Business View of a Master File
Grouping Business Logic In a Business View
Checking and Changing a Master File: CHECK
Checking a Data Source Description
CHECK Command Display
PICTURE Option
HOLD Option
Providing Data Source Security: DBA
Introduction to Data Source Security
Implementing Data Source Security
Specifying an Access Type: The ACCESS Attribute
Limiting Data Source Access: The RESTRICT Attribute
Controlling the Source of Access Restrictions in a Multi-file Structure
Adding DBA Restrictions to the Join Condition
Placing Security Information in a Central Master File
Summary of Security Attributes
Hiding Restriction Rules: The ENCRYPT Command
FOCEXEC Security
Creating and Rebuilding a Data Source
Creating a New Data Source: The CREATE Command
Rebuilding a Data Source: The REBUILD Command
Optimizing File Size: The REBUILD Subcommand
Changing Data Source Structure: The REORG Subcommand
Indexing Fields: The INDEX Subcommand
Creating an External Index: The EXTERNAL INDEX Subcommand
Checking Data Source Integrity: The CHECK Subcommand
Changing the Data Source Creation Date and Time: The TIMESTAMP Subcommand
Converting Legacy Dates: The DATE NEW Subcommand
Creating a Multi-Dimensional Index: The MDINDEX Subcommand
Master Files and Diagrams
EMPLOYEE Data Source
JOBFILE Data Source
EDUCFILE Data Source
SALES Data Source
CAR Data Source
LEDGER Data Source
FINANCE Data Source
REGION Data Source
EMPDATA Data Source
TRAINING Data Source
COURSE Data Source
JOBHIST Data Source
JOBLIST Data Source
LOCATOR Data Source
PERSINFO Data Source
SALHIST Data Source
VIDEOTRK, MOVIES, and ITEMS Data Sources
VIDEOTR2 Data Source
Gotham Grinds Data Sources
Century Corp Data Sources
Error Messages
Displaying Messages
Launch PDF
Developing Reporting Applications
WebFOCUS Application Logic
Three-Tier Application Logic
Deploying a Partitioned Project
WebFOCUS Components
Storing and Searching for Application Files
Section 508 Accessibility in WebFOCUS
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Application Metadata Commands and Catalog Metadata
Help Information: APP HELP
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Coding a User Interface
Which Tools Can You Use?
The WebFOCUS Client
Using the Servlet
Using a Dynamic Multiselect Drop-Down List
Enabling Ad Hoc Reporting
Validating a Form With JavaScript
Amper Auto-Prompting
Displaying a Report on the Default WebFOCUS Page
Designing an HTML Page for Report Display
Enhancing a User Interface
Displaying a Report in a Helper Application
Controlling Multiple Reports
Adding JavaScript for Drill-Down Reporting
Facilitating Report Manipulation
Using a Cascading Style Sheet to Standardize Display
Displaying a Previously Run Report
Passing a User ID From HTML for a Custom Menu
Managing Flow of Control in an Application
Uses for Dialogue Manager
Dialogue Manager Processing
Creating a Dialogue Manager Procedure
Customizing a Procedure With Variables
Creating a Standard Quote-Delimited String
Creating and Working With Variables
Using Numeric Amper Variables in Functions
Controlling the Execution of a Procedure
Navigating a Procedure
Enhancing an HTML Webpage With a Procedure
Issuing Operating System Commands
Controlling Passwords With Dialogue Manager
Sending a Message to the Application
Testing and Debugging a Dialogue Manager Procedure
Dialogue Manager Process Flow in the Procedure Viewer
Dialogue Manager Syntax Reference
Testing and Debugging a Procedure
Debugging Your Application With Query Commands
Displaying Combined Structures
Displaying Virtual Fields
Displaying the Currency Data Source in Effect
Displaying Available Fields
Displaying the File Directory Table
Displaying Field Information for a Master File
Displaying Data Source Statistics
Displaying Current ddnames Assigned With FILEDEF
Displaying Defined Functions
Displaying HOLD Fields
Displaying JOIN Structures
Displaying National Language Support
Displaying Explanations of Error Messages
Displaying the Current Search Path
Displaying the Release Number
Displaying the Values of a Remote Server
Displaying Parameter Settings
Displaying Parameters That Cannot Be Set in an Area
Displaying Graph Parameters
Displaying the Site Code of the Connected Server
Displaying Command Statistics
Displaying StyleSheet Parameter Settings
Displaying Information About the SU Machine
Displaying Data Sources Specified With USE
Displaying Global Variable Values
Identifying the Files Being Used
Managing the WebFOCUS Environment
Setting Up a WebFOCUS Environment
Refreshing or Removing an Environment
Accessing a FOCUS Data Source
The USE Command
The Developer Studio Use Tool
Identifying a FOCUS Data Source
Using Alternative File Specifications
Identifying a New Data Source
Protecting a Data Source
Concatenating Data Sources
Displaying the Current USE Options
Clearing the USE Options
Customizing Your Environment
When Do You Use the SET Command?
Ways to Issue a SET Command
Issuing a SET Command With the Set Tool
Coding a SET Command
Types of SET Parameters
SET Parameter Syntax
Defining and Allocating WebFOCUS Files
Allocating WebFOCUS Files
Application Files Under Windows
Extract Files Under Windows
Work Files Under Windows
Determining If A File Exists Under Windows
WebFOCUS Files Under MVS
Application Files Under MVS
Extract Files Under MVS
Work Files Under MVS
Reviewing Attributes of Allocated Files Under MVS
Application Files Under UNIX
Extract Files Under UNIX
Work Files Under UNIX
Determining If A File Exists Under UNIX
Using the Command Console
Command Console Window
Working in the Command Console
Euro Currency Support
Integrating the Euro Currency
Converting Currencies
Creating the Currency Data Source
Identifying Fields That Contain Currency Data
Activating the Currency Data Source
Processing Currency Data
Querying the Currency Data Source in Effect
Punctuating Numbers
Selecting an Extended Currency Symbol
Launch PDF
Using Functions
How to Use This Manual
Available Languages
Operating Systems
Introducing Functions
Using Functions
Types of Functions
Character Chart for ASCII and EBCDIC
Accessing and Calling a Function
Calling a Function
Supplying an Argument in a Function
Calling a Function From a DEFINE, COMPUTE, or VALIDATE Command
Calling a Function From a Dialogue Manager Command
Calling a Function From Another Function
Calling a Function in WHERE or IF Criteria
Calling a Function in WHEN Criteria
Calling a Function From a RECAP Command
Storing and Accessing an External Function
Character Functions
Character Function Notes
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CHKNUM: Checking a String for Numeric Format
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
XMLDECOD: Decoding XML-Encoded Characters
XMLENCOD: XML-Encoding Characters
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Simplified Character Functions
CHAR_LENGTH: Returning the Length in Characters of a String
DIGITS: Converting a Number to a Character String
LOWER: Returning a String With All Letters Lowercase
LPAD: Left-Padding a Character String
LTRIM: Removing Blanks From the Left End of a String
POSITION: Returning the First Position of a Substring in a Source String
RPAD: Right-Padding a Character String
RTRIM: Removing Blanks From the Right End of a String
SUBSTRING: Extracting a Substring From a Source String
TOKEN: Extracting a Token From a String
TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
UPPER: Returning a String With All Letters Uppercase
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
KKFCUT: Truncating a String
SFTDEL: Deleting the Shift Code From DBCS Data
SFTINS: Inserting the Shift Code Into DBCS Data
Maintain-specific Character Functions
CHAR2INT: Translating a Character Into an Integer Value
INT2CHAR: Translating an Integer Value Into a Character
LCWORD and LCWORD2: Converting a Character String to Mixed-Case
LENGTH: Determining the Length of a Character String
LJUST: Left-Justifying a Character String (Maintain)
LOWER: Converting a Character String to Lowercase
MASK: Extracting or Adding Characters
MNTGETTOK: Extracting Tokens From a String Function
NLSCHR: Converting Characters From the Native English Code Page
OVRLAY: Overlaying a Character String (Maintain)
POSIT: Finding the Beginning of a Substring (Maintain)
RJUST: Right-Justifying a Character String (Maintain)
SELECTS: Decoding a Value From a Stack
STRAN: Substituting One Substring for Another
STRCMP: Comparing Character Strings
STRICMP: Comparing Character Strings and Ignoring Case
STRNCMP: Comparing Character Substrings
STRTOKEN: Extracting a Substring Based on Delimiters
SUBSTR: Extracting a Substring (Maintain)
TRIM: Removing Trailing Occurrences (Maintain)
TRIMLEN: Determining the Length of a String Excluding Trailing Spaces
UPCASE: Converting Text to Uppercase (Maintain)
Data Source and Decoding Functions
DB_EXPR: Inserting an SQL Expression Into a Request
DB_INFILE: Testing Values Against a File or an SQL Subquery
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
DPART: Extracting a Component From a Date
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
CVTSTIME: Converting the System Date and Time (OpenVMS Only)
GETSTIME: Extracting the System Date and Time (OpenVMS Only)
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
HGETC: Storing the Current Date and Time in a Date-Time Field
HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HHMS: Converting a Date-Time Value to a Time Value
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HMASK: Extracting Date-Time Components and Preserving Remaining Components
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS or TIMETOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
WRTSTIME: Converting Dates to 64-Bit DEC Date/Time Format (OpenVMS Only)
Simplified Date and Date-Time Functions
DTADD: Incrementing a Date or Date-Time Component
DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
DTPART: Returning a Date or Date-Time Component in Integer Format
DTRUNC: Returning the Start of a Date Period for a Given Date
Maintain-specific Date and Time Functions
Maintain-specific Standard Date and Time Functions
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Binary Integer to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Maintain-specific Light Update Support Functions
IWC.FindAppCGIValue: Retrieving a WebFOCUS Parameter or Variable Value
IWC.GetAppCGIValue: Importing a WebFOCUS Parameter or Variable
Numeric Functions
ABS: Calculating Absolute Value
ASIS: Distinguishing Blank From Zero
BAR: Producing a Bar Chart
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
FMLINFO: Returning FOR Values
FMLLIST: Returning an FML Tag List
FMLFOR: Retrieving FML Tag Values
FMLCAP: Retrieving FML Hierarchy Captions
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
MIRR: Calculating the Modified Internal Return Rate
NORMSDST and NORMSINV: Calculating Normal Distributions
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
Maintain-specific Script Functions
IWCLink: Displaying a URL in a Browser or Frame
IWCSwitchToSecure and IWCSwitchToUnsecure: Turning the Secure Sockets Layer On and Off
IWCTrigger: Calling a Maintain Function From a Script Handler
IWC.FindAppCGIValue: Finding a WebFOCUS Parameter or Variable Value
IWC.GetAppCGIValue: Retrieving a WebFOCUS Parameter or Variable
System Functions
CHECKPRIVS: Retrieving the Privilege State for the Connected User
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FINDMEM: Finding a Member of a Partitioned Data Set
FPUTENV: Assigning a Value to an Environment Variable
GETCOOKI: Retrieving a Browser Cookie Value
GETHEADR: Retrieving an HTTP Header Variable
GETPDS: Determining If a Member of a Partitioned Data Set Exists
GETUSER: Retrieving a User ID
GRPLIST: Retrieving the Group List of the Connected User
JOBNAME: Retrieving the Current Process Identification String
MVSDYNAM: Passing a DYNAM Command to the Command Processor
PUTCOOKI: Submitting a Value to a Browser Cookie
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SPAWN: Creating a Subprocess From a Procedure
SYSTEM: Calling a System Program
SYSVAR: Retrieving the Value of a z/OS System Variable
Creating a Subroutine
Writing a Subroutine
Compiling and Storing a Subroutine
Testing the Subroutine
Using a Custom Subroutine: The MTHNAM Subroutine
Subroutines Written in REXX
Launch PDF
DataMigrator Functions
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
Information Builders and iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and a Process Flow
Performing Server Administration Tasks
Using Secure Shell FTP (SFTP)
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Aerial View
Ribbon Tabs
Metadata Tab
Text Editor Tab
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding Email Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
How to Use a Variable in a Synonym
Creating, Enhancing, and Editing Synonyms Using Modeling View
Adding Indexes to a Synonym
Adding Virtual Columns (DEFINE) in a Synonym
Viewing Data Profiling Characteristics
Viewing Data Lineage for a Column
Advanced DataMigrator Tips and Techniques
Overview of Examples
Creating Sample Data and Metadata
Horizontal Partitioning with Multi-Table Load
Using the Decode Function
Generating a Surrogate Key
Generating a Surrogate Key Using Slowly Changing Dimensions
Mapping to a Sequential File of a Specific Format
Creating and Using Reusable Transformations
Using Multiple Targets to Create a Single File With Multiple Records Types
Creating a Target File With Multiple RECTYPEs
Combining Multiple Sources Rows in a Single Target Row
Using Lookups to Create Multi-Table Flows Without Joins
Record Logging
Using Variables in Data Flows
Creating a Data Flow Using a Target Based on a Predefined XML Schema
Loading a Target Table Using the File Listener
Sending a Target File to an FTP or SFTP Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Loading Images Into a Database Table
Change Data Capture
Enabling the Database for Logging in Relational Databases
Enabling the Database for Logging in VSAM
Properties of a Table Log Record Synonym
Tutorial: Using Change Data Capture with Relational Databases
Tutorial: Using Change Data Capture With VSAM
DataMigrator Log Statistics and Tables
Log and Statistics Tables
Event-Based Scheduling
Starting Flows With CMRUN
Starting Flows With CMASAP
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Resource Analyzer Administrator's and User's Manual
What Is Resource Analyzer?
Resource Analyzer Overview
Resource Analyzer for Decision Support Analysis
Uses for Resource Analyzer: Performance Analysis
Introduction to Data Access and Performance Analysis With Resource Analyzer
Sample Data Access Questions
How Resource Analyzer Works
Software Prerequisites
Overview of the Web Console
Overview of Reporting With Resource Analyzer
Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
Configuring and Administering Resource Management
Resource Management Interface
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Resource Analyzer Report Options
Reports Overview
Resource Analyzer Reporting
Resource Analyzer Report Options
General Reports
Resource Analyzer Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Usage Monitoring RDBMS Table Sizing
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Launch PDF
Resource Governor Administrator's and User's Manual
What Is Resource Governor?
Resource Governor Overview
Resource Governor Features
Resource Governor Operations
How Resource Governor Works
Resource Governor Usage Monitoring
Configuring and Administering Resource Management
Resource Management Interface
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Rules Files and Knowledge Bases
Overview
Working With Business Rules
Working with Resource Thresholds
Working with Knowledge Bases
Maintaining Knowledge Bases
Resource Governor Report Options
Reports Overview
Resource Governor Reporting
Resource Governor Report Options
General Reports
Resource Governor Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Usage Monitoring RDBMS Table Sizing
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Business Rule Language (BRL)
Using Business Rule Language (BRL)
BRL Factual Information
BRL Keywords
Pre-defined Variables
Internal Functions
Customized Rule Examples
Launch PDF
WebFOCUS Reporting Server
Server New Features
Server Enhancements
Applications
Configuration and Monitoring
Core Server and Clients
Diagnostics
Metadata
National Language Support
Security
Web Console
Adapter Enhancements
All Adapters
SQL Adapters
ERP Adapters
OLAP Adapters
DBMS Adapters
Procedures Adapters
Sequential and Indexed Adapters
Social Media Adapters
XML-Based Adapters
DataMigrator Enhancements
Check File
Dependencies Analysis Report
Updating Synonyms
Quick ETL Copy
Copying Selected Columns Using Quick ETL Copy
Copy Server Node
Noncontiguous Keys
Global Variables Editor
Updates for Type I Fields
Annotations in Flows
Finding Text in SQL Object
Extended Load Bulk Enhancements
Loading Images From Files
JSON Document Target
WHERE Calculator Support for ANY and ALL
Impact Analysis Enhancements
Slowly Changing Dimensions
Extended Bulk Load Utility for MS SQL ODBC Adapter
Transformation Calculator Enhancements
New SQL Functions
Data Profiling Drill-Down Reports for Patterns
Managing Object Groups In A Flow
Using Source Control on Multiple Files
Find Available for Data and Process Flows
Undo and Redo Capability
Segment Qualifications in Synonym Editor
Email File Types for a Process Flow
Non-Zero Return Code Lines in DataMigrator Log
ETLLOG Enhancements
Using SFTP as a Data Source
Option to Continue Processing on Partial Answer Set
Allowing Iterator for Non-DataMigrator Jobs
Support Change Data Capture for MS SQL 2012
Reading a Field With Delimited Values as Individual Rows
SCD Type I Flow Updates
File Types on EDAMAIL or on a Flow
Display of Long Procedure Names
Calculate Format for Expression In Transformation Grid
Specifying USAGE Attributes for Datetime Fields
Balloon Tips to Show Error or Information Messages
Batch Command for Data Profiling and Key Analysis
Source Control File Types
Resource Analyzer and Resource Governor Enhancements
New Errors and Messages Report
Monitoring Commands Enhancements
Sybase ASA Supported
Maximum Memory Used for Log File Records
Enhanced Administration for Thresholds and Business Rules
Enhanced Governor Business Rules Menu
Monitored Generated SQL Statements and Aggregation Messages
New Report to Display All Governor Rule File Properties
Reporting Language Enhancements
Controlling Column Title Underlining Using a StyleSheet Attribute
Rolling Up Calculations on Summary Rows
Simplified Character Functions
Simplified Date and Date-Time Functions
CHECKPRIVS: Retrieving the Privilege State for the Connected User
Adding a Value Test to RESTRICT=NOPRINT
Using ACCEPT=SYNONYM in a Master File
Using Multiple Prefix Operators on the Same Measure in SUBTOTAL
Validating Parameter Values Without Data File Access: REGEX
Storing Localized Metadata in Language Files
Adding DBA Restrictions to the Join Condition
Launch PDF
Server Release Notes
Disabling the CSRF Token When Connecting From a Release 8.0.x Client
General Information
Adapter for ESSBASE
Adapter for Netezza
Adapter for MQSeries
Adapter for Red Brick
Adapter for JBoss
Adapter for Oracle
Adapter for Informix
Adapter for DB2 on IBM i
Adapter for JDBC
Adapter for PeopleSoft
Adapter for SQL Server Analysis Services (SSAS)
Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
JVM Requirements for Java Services
Connector for OLE DB
Resource Analyzer
Run With Options Changed to Submit With E-Mail
Running or Sharing 7.7.x and 7.6.x on the Same Machine
New CMRUN Executable
Platform Support
Active Technologies
Reporting Language
Server Security
Launch PDF
Adapter Administration
Introduction to Adapters
Processing Requests
Functions of an Adapter
Data Management
Metadata Services With SQLENGINE SET
Additional Master File Attributes
Using the Adapter for 1010data
Configuring the Adapter for 1010data
Managing 1010data Metadata
Customizing the 1010data Environment
Optimization Settings
Using the Adapter for Adabas
Preparing the Adabas Environment
Configuring the Adapter for Adabas
Adabas Overview
Managing Adabas Metadata
Overview of Master and Access Files
Master Files for Adabas
Access Files for Adabas
Mapping Adabas Descriptors
Mapping Adabas Files With Variable-Length Records and Repeating Fields
Using the GROUP Attribute to Cross-Reference Files
Platform-Specific Functionality
Customizing the Adabas Environment
Adabas Reporting Considerations
Adabas Writing Considerations
Adapter Navigation
Entry Segment Retrieval of Adabas Records
Descendant Periodic Groups and Multi-Value Fields
Descendant Adabas Records
Using the Adapter for Adabas Stored Procedures
Preparing the Adabas Stored Procedures Environment
Configuring the Adapter for Adabas Stored Procedures
Managing Adabas Stored Procedure Metadata
Invoking an Adabas Stored Procedure
Using the Adapter for Alchemy Sentiment Analysis
Overview
Configuring the Alchemy Sentiment Analysis Adapter
Creating Metadata and Sample Reports for the Alchemy Adapter
Examples
Using the Adapter for Axiom EPM
Preparing the Environment
Configuring the Adapter for Axiom EPM
Managing Axiom EPM Metadata
Managing Connections to Axiom EPM
Using Administrative Utilities
Using the Adapter for C9 INC
Preparing the C9 INC Environment
Configuring the Adapter for C9 INC
Managing C9 INC Metadata
Customizing the C9 INC Environment
Using the Adapter for Caché
Preparing the Caché Environment
Configuring the Adapter for Caché
Managing Caché Metadata
Customizing the Caché Environment
Optimization Settings
Using the Adapter for CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Configuring the Adapter for CICS Transactions
Managing CICS Transaction Metadata
Invoking a CICS Transaction
Running a TPG/SPG/AAS Transaction
Using the Adapters for C-ISAM and ISAM
Preparing the Environment
Configuring the Adapter
Managing C-ISAM Metadata
Maintaining C-ISAM Data Sources Using SQL Commands
Using a Secondary Index in C-ISAM and ISAM Files
Using the Adapter for DATACOM
Preparing the DATACOM Environment
Configuring the Adapter for DATACOM
DATACOM Overview and Mapping Considerations
Managing DATACOM Metadata
Master Files for DATACOM
Access Files for DATACOM
Describing Multi-File Structures for DATACOM
Data Retrieval Logic for DATACOM
Using the Adapter for DB2
Preparing the DB2 Environment
Configuring the Adapter for DB2
Managing DB2 Metadata
Reporting Against a DB2 Stored Procedure
Customizing the DB2 Environment
Optimization Settings
Using DB2 Cube Views
Calling a DB2 Stored Procedure Using SQL Passthru
Using the Adapter for DB Heritage Files
Preparing the DB Heritage Files Environment
Configuring the Adapter for DB Heritage Files
Managing DB Heritage Files Metadata
Standard Master File Attributes for a DB Heritage Files Data Source
Redefining a Field in a DB Heritage Files Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Multi-Format Logical Files
DB Heritage Files Record Selection Efficiencies
Using the Adapter for Essbase
Preparing the Essbase Environment
Configuring the Adapter for Essbase
Managing Essbase Metadata
Customizing the Essbase Environment
Essbase Reporting With WebFOCUS
Using the Adapter for Excel
Configuring the Adapter for Excel
Managing Excel Metadata
Customizing the Excel Environment
Optimization Settings
Using the Adapter for Excel (via Direct Retrieval)
Configuring the Adapter for Excel (via Direct Retrieval)
Managing Metadata for Excel (via Direct Retrieval)
Changing Adapter Settings
Using the Adapter for Facebook
Overview
Creating a Facebook Application
Configuring the Facebook Adapter
Creating Metadata and Sample Reports for the Facebook Adapter
Examples
Using the Adapters for Flat and Delimited Flat Files
Preparing the Environment
Configuring the Adapters for Flat and Delimited Flat Files
Managing Metadata for Flat and Delimited Flat Files
Using the Adapter for Google Analytics
Overview
Creating a Google Project
Obtaining the Web Profile ID
Configuring the Google Analytics Adapter
Creating Metadata for the Google Analytics Adapter
Using the Adapter for Greenplum
Configuring the Adapter for Greenplum
Managing Greenplum Metadata
Using the Adapter for Hadoop with Apache Hive and Cloudera Impala
Introducing the Adapter for Apache Hive and Cloudera Impala
Preparing the Environment
Configuring the Adapter for Hadoop/Hive/Impala
Creating Synonyms
Using Direct Pass-through
Loading Data Using DataMigrator
Using the Adapter for HP Vertica
Preparing the HP Vertica Environment
Configuring the Adapter for HP Vertica
Managing HP Vertica Metadata
Customizing the HP Vertica Environment
Optimization Settings
Using the Adapter for Hyperstage
Preparing the Hyperstage Environment
Configuring the Adapter for Hyperstage
Managing Hyperstage Metadata
Customizing the Adapter for the Hyperstage Environment
Optimization Settings
Using the Adapter for i Access
Preparing the i Access Environment
Configuring the Adapter for i Access
Managing i Access Metadata
Customizing the i Access Environment
Optimization Settings
Using the Adapter for CA-IDMS/DB
Preparing the IDMS/DB Environment
Configuring the Adapter for IDMS/DB
IDMS/DB Overview and Mapping Considerations
Managing IDMS/DB Metadata
Master Files for IDMS/DB
Access Files for IDMS/DB
IDMS/DB Sample File Descriptions
File Retrieval
Record Retrieval
Customizing the IDMS/DB Environment
Tracing the Adapter for IDMS/DB
Using the Adapter for CA-IDMS/SQL
Preparing the IDMS/SQL Environment
Configuring the Adapter for IDMS/SQL
Managing IDMS/SQL Metadata
Customizing the IDMS/SQL Environment
Optimization Settings
Using the Adapter for IMS
IMS Environments: Overview
Preparing the IMS Environment
Configuring the Adapter for IMS
Managing IMS Metadata
Master File Attributes
Access File Attributes (DBCTL)
Migrating From an Existing MVS Server (DBCTL)
WebFOCUS Reporting With IMS
Maintaining IMS Data Sources (DBCTL)
Using the Adapter for IMS Transactions
Preparing the IMS Transactions Environment
Supported Platforms and Release Information
Configuring the Adapter for IMS Transactions
Managing IMS Transactions Metadata
Invoking an IMS Transaction
Invoking an IMS Stored Procedure
Using the Adapter for Informix
Preparing the Informix Environment
Configuring the Adapter for Informix
Managing Informix Metadata
Customizing the Informix Environment
Optimization Settings
Calling an Informix Stored Procedure Using SQL Passthru
Using the Adapter for Ingres
Preparing the Ingres Environment
Configuring the Adapter for Ingres
Managing Ingres Metadata
Customizing the Ingres Environment
Optimization Settings
Using the Adapter for Interplex
Preparing the Interplex Environment
Configuring the Adapter for Interplex
Managing Interplex Metadata
Customizing the Interplex Environment
Optimization Settings
Using the Adapter for iWay Adapter Framework (IWAF)
Preparing the IWAF Environment
Configuring the Adapter for IWAF
Creating Synonyms
Using the Adapter for JBoss Application Server
Preparing the JBoss Application Server Environment
Configuring the Adapter for JBoss Application Server
Managing JBoss Application Server Metadata
Customizing the JBoss Application Server Environment
Optimization Settings
Using the Adapter for JDBC
Preparing the JDBC Environment
Configuring the Adapter for JDBC
Managing JDBC Metadata
Customizing the JDBC Environment
Optimization Settings
Using the Adapter for JD Edwards EnterpriseOne
Preparing the JD Edwards EnterpriseOne Environment
Overview of the Setup Process
Configuring the Adapter for JD Edwards EnterpriseOne
Creating Synonyms for JD Edwards EnterpriseOne
Refreshing the Metadata Repository
Refresh Security Extracts
Converting Synonyms for JD Edwards EnterpriseOne (Non IBM i Platforms Only)
Setting the UDCDIC Environment Variable (Windows only)
Using the Adapter for JD Edwards World
Installation Prerequisites
Configuring the Adapter for JD Edwards World
Managing JD Edwards World Metadata
Enabling JD Edwards World Security
Enabling Tracing
Frequently Asked Questions
Using the Adapter for JSON
Preparing the JSON Environment
Configuring the Adapter for JSON
Managing JSON Metadata
Using the Adapter for Lawson
Adapter for Lawson: Overview
Configuring the Adapter for Lawson
Preparing the Lawson Environment
Managing Lawson Metadata
Updating Lawson Security Information
Using the Adapter for LinkedIn
Overview
Creating a LinkedIn Application
Configuring the LinkedIn Adapter
Creating Metadata and Sample Reports for the LinkedIn Adapter
Examples
Using the Adapter for Lotus Notes
Preparing the Lotus Notes Environment
Configuring the Adapter for Lotus Notes
Managing Lotus Notes Metadata
Using the Adapter for LDAP
Preparing the LDAP Environment
Configuring the Adapter for LDAP
Managing LDAP Metadata
Using the Adapter for Microsoft Access
Preparing the Microsoft Access Environment
Configuring the Adapter for Microsoft Access
Managing Microsoft Access Metadata
Customizing the Microsoft Access Environment
Optimization Settings
Using the Adapter for Microsoft SQL Server
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server
Managing Microsoft SQL Server Metadata
Reporting Against a Microsoft SQL Server Stored Procedure
Customizing the Microsoft SQL Server Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Microsoft SQL Server Compatibility With ODBC
Using the Adapter for Microsoft SQL Server ODBC
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server ODBC
Managing Microsoft SQL Server ODBC Metadata
Reporting Against a Microsoft SQL Server ODBC Stored Procedure
Customizing the Microsoft SQL Server ODBC Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Using the Adapter for Millennium
Preparing the Server Environment for Millennium
Configuring the Adapter for Millennium
Preparing the Millennium Environment
Managing Millennium Metadata
Standard Master File Attributes for a Millennium Data Source
Using the Adapter for Model 204
Preparing the Model 204 Environment
Configuring the Adapter for Model 204
Model 204 Overview and Mapping Considerations
Managing Model 204 Metadata
Master Files for Model 204
Access Files for Model 204
Customizing the Model 204 Environment
Using Customized Security Exits
Adapter Tracing for Model 204
Using the Adapter for MongoDB
Introducing the Adapter for MongoDB
Preparing the Environment
Configuring the Adapter for MongoDB
Creating Synonyms
Limitations
Using the Adapter for MySQL
Preparing the MySQL Environment
Configuring the Adapter for MySQL
Managing MySQL Metadata
Customizing the Adapter for the MySQL Environment
Optimization Settings
Using the Adapter for NATURAL
Preparing the NATURAL Environment
Configuring the Adapter for NATURAL
Managing Metadata for NATURAL
Invoking a NATURAL Program
Using the Adapter for NATURAL CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Installing NATURAL Support Programs
Configuring the Adapter for NATURAL CICS Transactions
Managing NATURAL CICS Transactions Metadata
NATURAL Data Buffer Processing API
Invoking a NATURAL CICS Transaction
Using the Adapter for Netezza
Preparing the Netezza Environment
Unicode Support
Configuring the Adapter for Netezza
Managing Netezza Metadata
Customizing the Netezza Environment
Optimization Settings
Using the Adapter for Nucleus
Preparing the Nucleus Environment
Configuring the Adapter for Nucleus
Managing Nucleus Metadata
Customizing the Nucleus Environment
Optimization Settings
Using the Adapter for ODBC
Preparing the ODBC Environment
Configuring the Adapter for ODBC
Managing ODBC Metadata
Customizing the ODBC Environment
Optimization Settings
Using the Adapter for Oracle
Preparing the Oracle Environment
Configuring the Adapter for Oracle
Managing Oracle Metadata
Reporting Against an Oracle Stored Procedure
Customizing the Oracle Environment
Optimization Settings
Calling an Oracle Stored Procedure Using SQL Passthru
Using the Adapter for Oracle E-Business Suite
Preparing the Oracle E-Business Suite Environment
Data Access and Security
Configuring the Adapter for Oracle E-Business Suite
Maintaining Security Rules
Using the Adapter for Oracle TimesTen
Preparing the Oracle TimesTen Environment
Configuring the Adapter for Oracle TimesTen
Managing Oracle TimesTen Metadata
Customizing the Oracle TimesTen Environment
Optimization Settings
Using the Adapter for parAccel
Configuring the Adapter for parAccel
Managing parAccel Metadata
Using the Adapter for PeopleSoft
Preparing the Environment
Configuring the Adapter for PeopleSoft
Managing PeopleSoft Metadata
Managing PeopleSoft Secured Data Access
Managing Connections to PeopleSoft
Using Administrative Utilities
Migrating from 7.1x and 7.6.x to 7.7
Advanced Administrative Topics
Using the Adapter for PostgreSQL
Preparing the PostgreSQL Environment
Configuring the Adapter for PostgreSQL
Managing PostgreSQL Metadata
Customizing the PostgreSQL Environment
Optimization Settings
Using the Adapter for Progress
Preparing the Progress Environment
Configuring the Adapter for Progress
Managing Progress Metadata
Customizing the Progress Environment
Optimization Settings
Using the Adapter for PSQL
Preparing the PSQL Environment
Configuring the Adapter for PSQL
Managing PSQL Metadata
Customizing the PSQL Environment
Optimization Settings
Using the Adapter for Query/400
Preparing the Adapter for Query/400 Environment
Configuring the Adapter for Query/400
Managing Query/400 Metadata
Using the Adapter for Rdb
Preparing the Rdb Environment
Configuring the Adapter for Rdb
Managing Rdb Metadata
Using Multiple Rdb DBMS Files
Using Multischema Rdb DBMS Files
Rdb Database Driver Performance
Using the Adapter for Red Brick
Preparing the Red Brick Environment
Configuring the Adapter for Red Brick
Managing Red Brick Metadata
Customizing the Red Brick Environment
Optimization Settings
Using the Adapter for REST
Configuring the Adapter for REST
Managing RESTful Web Services Metadata
Using the Adapter for Remote Servers
Configuring Remote Servers
Managing Metadata for Remote Servers
Executing Stored Procedures
Using the Adapter for RMS
Preparing the RMS Environment
Configuring the Adapter for RMS
Managing RMS Metadata
Manually Describing RMS Files
Describing Complex RMS Keyed
Associating an RMS Data Source to a Master File
Retrieving Data From RMS Files
Syntax for RMS Master File Attributes
RMS Attribute Summary
Read/Write Usage Limitations of the Adapter for RMS
Using the Adapter for Salesforce.com
Configuring the Adapter for Salesforce.com
Creating Synonyms
Using the Adapter for SAP Business Intelligence Warehouse (BW)
Preparing the SAP BW Environment
Configuring the Adapter for SAP BW
Supporting Mixed Code Page Environments
Creating BEx Queries
SAP BW Reporting With WebFOCUS
Managing SAP BW Metadata
Customization Settings
Support for BEx Structures
Producing SAP BW Requests Using SQL
Using the Adapter for SAP
Preparing the SAP Environment
Accessing Multiple SAP Systems
Configuring the Adapter for SAP
Post-Configuration Tasks in an SAP Environment
Managing SAP Metadata
SAP Table Class Support for an Individual Table
SAP Support for a Function Module
SAP Data Type Support
SAP Open/SQL Support
Advanced SAP Features
Setting Up the Report Processing Mode
Supporting Mixed Code Page Environments
Producing SAP Requests
Using the Adapter for SAP Hana
Preparing the SAP Hana Environment
Configuring the Adapter for SAP Hana
Managing SAP Hana Metadata
Customizing the SAP Hana Environment
Optimization Settings
Using the Adapter for Siebel
Software Requirements for the Adapter for Siebel
Preparing the Siebel Environment
Preparing the Server Environment for Adapter Configuration
Configuring the Adapter for Siebel
Managing Siebel Metadata
Optimization Settings
Using the Adapter for SQLBase
Preparing the SQLBase Environment
Configuring the Adapter for SQLBase
Managing SQLBase Metadata
Customizing the SQLBase Environment
Optimization Settings
Using the Adapter for SQL Server Analysis Services (SSAS)
Preparing the SQL Server Analysis Services (SSAS) Environment
Configuring the Adapter for SQL Server Analysis Services
Managing SQL Server Analysis Services Metadata
Customizing the SQL Server Analysis Services Environment
SQL Server Analysis Services (SSAS) Reporting With WebFOCUS
Using the Adapter for Sybase
Preparing the Sybase Environment
Configuring the Adapter for Sybase
Managing Sybase Metadata
Reporting Against a Sybase Stored Procedure
Customizing the Sybase Environment
Optimization Settings
Calling a Sybase Stored Procedure Using SQL Passthru
Using the Adapter for Teradata
Preparing the Teradata Environment
Configuring the Adapter for Teradata
Managing Teradata Metadata
Reporting Against a Teradata Stored Procedure
Customizing the Teradata Environment
Optimization Settings
Calling a Teradata Macro or Stored Procedure Using SQL Passthru
Using the Adapter for Transoft
Preparing the Transoft Environment
Configuring the Adapter for Transoft
Managing Transoft Metadata
Customizing the Transoft Environment
Optimization Settings
Using the Adapter for Twitter
Overview
Creating a Twitter Application
Configuring the Twitter Adapter
Creating Metadata and Sample Reports for the Twitter Adapter
Examples
Using the Adapter for UniData
Preparing the UniData Environment
Configuring the Adapter for UniData
Managing UniData Metadata
Customizing the UniData Environment
Optimization Settings
Using the Adapter for UniVerse
Preparing the UniVerse Environment
Configuring the Adapter for UniVerse
Managing UniVerse Metadata
Customizing the UniVerse Environment
Optimization Settings
Using the Adapter for VSAM
Preparing the Environment for VSAM
Configuring the Adapter for VSAM
Managing VSAM Metadata
Associating a VSAM Data Source With a Master File
Standard Master File Attributes for a VSAM Data Source
Redefining a Field in a VSAM Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
VSAM Record Selection Efficiencies
Maintaining VSAM KSDS Data Sources
Using VSAM Relative Record Data Set (RRDS) Files
Reviewing SQL Updates to VSAM Data Sources
Using the Adapter for WAND Sentiment Analysis
Overview
Installing, Configuring, and Updating the WAND Taxonomy Server
Installing and Using the WAND Taxonomy Editor
Configuring the WAND Sentiment Analysis Adapter
Creating Metadata and Sample Reports for the WAND Sentiment Analysis Adapter
Examples
Using the Adapter for Web Services
Configuring the Adapter for Web Services
Managing Web Services Metadata
Capturing a SOAP Request Using FILEDEF SOAPTSCQ in a Procedure
Using the Adapter for Words Analysis
Overview
Configuring the Words Analysis Adapter
Creating Metadata and Sample Reports for the Words Analysis Adapter
Examples
Using the Adapter for XML
Preparing the XML Environment
Configuring the Adapter for XML
Managing XML Metadata
XA Support
XA Transaction Management
Supported Interfaces
Implementation
Vendor Specifics
Aggregate Awareness Support
Relational Adapters and Aggregated SQL Queries
Aggregate Awareness in an RDBMS
Cluster Join
Embedded Joins
Embedded Join Master Files
Translating COBOL File Descriptions
Creating Synonyms From COBOL File Descriptions
Controlling the Translation of a COBOL File Description
Data Set Compression Exit: ZCOMP
Invoking the ZCOMP Exit
What Happens When ZCOMP is LOADED?
Dynamic Private User Exit
FOCSAM and the GETPRV User Exit
Physical Implementation of the GETPRV Exit
Master File for Data Access With GETPRV
Access File for Data Access With GETPRV
Calling Parameters and Work Areas
Validation for Special Characters and Reserved Words
Validation for Special Characters
Validation for Reserved Words
Launch PDF
Server Administration
Server Introduction
Using the Web Console
Console Options
Other Icon Options
Configuration Overview
Running and Configuring the FOCUS Database and FOCUS Database Server
Server Profiles
Profile Commands
Server Security
Server Security Overview
Configuring Authentication
Configuring Privileges and Other Authorizations
Configuring Server Encryption
Access to Connection Information in WebFOCUS Procedures
Configuring the Server for Multi-Tenant Deployment
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Application Metadata Commands and Catalog Metadata
Help Information: APP HELP
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Data Adapters
Changing Common Adapter Settings
Configuring an Adapter
Changing the Adapter Configuration
Configuring a Remote Server
SQL Automatic Passthru Status
Determining SQL Optimization
Determining Function Parameters
Data Type Support Report
Social Media Adapters
Metadata
Creating Synonyms
Testing Synonyms
Managing Synonyms
Using the Wizards
Stored Procedures
Working With Stored Procedures
Creating a Stored Procedure
Sending Stored Procedure Report Output to Server-Side Printers
Editing a Stored Procedure
Running a Stored Procedure
Scheduling a Procedure
Sending an E-mail Notification for a Procedure
Procedure Run-Time Processing Essentials
Platform-Specific Commands and Features
Stress Testing a Procedure
Running Impact Analysis Reports
Server Workspace Manager
Configuring Workspace Manager
Workspace Configuration Settings
Editing Configuration Files
Configuring Java Services
Cluster Manager
Monitoring Server Activity
Listeners and Special Services
Using the Listeners and Special Services Configuration Panes
Special Services
Listeners
Troubleshooting
Viewing Version Information
Analyzing Server Activity
Analyzing FOCUS Database Server Activity
Tracing Server Activity
z/OS-Specific Troubleshooting for the Unified Server
z/OS-Specific Troubleshooting for z/OS HFS Deployment
Recording and Reproducing User Actions
Troubleshooting the Console
Server Processes
Gathering Diagnostic Information for Customer Support Services
Unicode Support
Unicode and the WebFOCUS Reporting Server
Accessing Unicode Data
Selecting, Reformatting, and Manipulating Characters
Sort Order Under Unicode
Added Unicode Support for Master Files, Data Files, and Application Directory Names
Unicode PDF Output
Platform-Specific Methods for Specifying EDAEXTSEC
Platform-Specific Methods for Setting EDAEXTSEC
Launch PDF
Server Installation
Introduction to Installation
Versions
What to Read After You Install
Installation for Windows
Installation Requirements
Accessing the Software
Installing
Installation and Configuration Directories
Verifying Installation
Starting and Using a Server or Data Management Console
Security Providers
Additional Installation Options
Generating a Trace
Third-Party Software and Licenses
General Information for a Windows Installation
Troubleshooting for Windows
Installation for UNIX
Installation Requirements
Installation and Configuration Directories
Installing
Verifying Installation
Security Providers
Starting and Using a Server
Generating a Trace
Third-Party Software and Licenses
General Information for a UNIX Installation
Troubleshooting for UNIX
Installation for z/OS
Installation for HFS and PDS
HFS Deployment
PDS Deployment
Installation for IBM i
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Installation Program
Step 5. Verifying the Server Installation
Step 6. Security Providers
Starting and Using the Server
CL and CMD Programs
General Information for an IBM i Installation
Generating a Trace
Third-Party Software and Licenses
Troubleshooting for IBM i
Installation for OpenVMS
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Setup Procedure
Step 5. Verifying the Installation
Step 6. Security Providers
Starting and Using the Server
Generating a Trace
Third-Party Software and Licenses
General Information for an OpenVMS Installation
Troubleshooting for OpenVMS
Information Builders and Third-Party Licenses
Information Builders License
OpenFlex SDK License
Zip Archiver License
Launch PDF
Stored Procedure Reference for 3GL Procedures
Introducing Stored Procedures
Using a Stored Procedure
Calling a Stored Procedure
Stored Procedure Libraries
Setting the Execution Order
Calling a Program as a Stored Procedure
Calling a Compiled Program
Calling a Program With CALLPGM or EXEC
Calling a Program With SQL EX
Passing Parameters
Program Communication
Calling a JAVA Class as a Stored Procedure
Execute Using CALLJAVA
Execute Using EX
Execute Using SQL EX and SQL CPJAVA EX
Passing Parameters
Writing a JAVA Class
JAVA Class Communication
Compiling and Running a JAVA Program
Writing a 3GL Compiled Stored Procedure Program
Program Requirements
Setting Up the Control Block
Storing Program Values
Error Handling
Issuing the CREATE TABLE Command
User Written Routines
Calling a User Written Routine
Using the GENCPGM Build Tool
Using GENCPGM
Additional 3GL Reference Examples
Subroutine Source Examples and Runtime Testing
MTHNAME C Implementation
MTHNAME C++ Implementation
MTHNAME Fortran Implementation
MTHNAME COBOL Implementation
MTHNAME z/OS BAL Assembler Implementation
MTHNAME Basic Implementation (Based on HP OpenVMS Basic 1.4)
MTHNAME RPG IBM i ILE Implementation
MTHNAME PL/1 Implementation
MTHNAME Pascal Implementation (Based on HP OpenVMS Pascal 5.8)
UREVERSE C Implementation
Launch PDF
Reporting Language
Creating Reports With WebFOCUS Language
Creating Reports Overview
Requirements for Creating a Report
Report Types
Reporting Tools
Developing Your Report Request
Customizing a Report
Selecting a Report Output Destination
Displaying Report Data
Using Display Commands in a Request
Displaying Individual Values
Adding Values
Counting Values
Expanding Byte Precision for COUNT and LIST
Maximum Number of Display Fields Supported in a Request
Manipulating Display Fields With Prefix Operators
Displaying Pop-up Field Descriptions for Column Titles
Sorting Tabular Reports
Sorting Tabular Reports Overview
Sorting Rows
Sorting Columns
Reformatting Sort Fields
Manipulating Display Field Values in a Sort Group
Creating a Matrix Report
Controlling Collation Sequence
Specifying the Sort Order
Ranking Sort Field Values
Grouping Numeric Data Into Ranges
Restricting Sort Field Values by Highest/Lowest Rank
Sorting and Aggregating Report Columns
Hiding Sort Values
Sorting With Multiple Display Commands
Improving Efficiency With External Sorts
Hierarchical Reporting: BY HIERARCHY
Selecting Records for Your Report
Selecting Records Overview
Choosing a Filtering Method
Selections Based on Individual Values
Selection Based on Aggregate Values
Using Compound Expressions for Record Selection
Using Operators in Record Selection Tests
Types of Record Selection Tests
Selections Based on Group Key Values
Setting Limits on the Number of Records Read
Selecting Records Using IF Phrases
Reading Selection Values From a File
Assigning Screening Conditions to a File
VSAM Record Selection Efficiencies
Creating Temporary Fields
What Is a Temporary Field?
Defining a Virtual Field
Creating a Calculated Value
Assigning Column Reference Numbers
Calculating Trends and Predicting Values With FORECAST
Calculating Trends and Predicting Values With Multivariate REGRESS
Using Text Fields in DEFINE and COMPUTE
Creating Temporary Fields Independent of a Master File
Including Totals and Subtotals
Calculating Row and Column Totals
Including Section Totals and a Grand Total
Including Subtotals
Recalculating Values for Subtotal Rows
Summarizing Alphanumeric Columns
Manipulating Summary Values With Prefix Operators
Combinations of Summary Commands
Producing Summary Columns for Horizontal Sort Fields
Performing Calculations at Sort Field Breaks
Suppressing Grand Totals
Conditionally Displaying Summary Lines and Text
Using Expressions
Using Expressions in Commands and Phrases
Types of Expressions
Creating a Numeric Expression
Creating a Date Expression
Creating a Date-Time Expression
Creating a Character Expression
Creating a Variable Length Character Expression
Creating a Logical Expression
Creating a Conditional Expression
Saving and Reusing Your Report Output
Saving Your Report Output
Creating a HOLD File
Holding Report Output in FOCUS Format
Controlling Attributes in HOLD Master Files
Keyed Retrieval From HOLD Files
Saving and Retrieving HOLD Files
Using DBMS Temporary Tables as HOLD Files
Creating SAVE and SAVB Files
Creating a PCHOLD File
Choosing Output File Formats
Using Text Fields in Output Files
Creating a Delimited Sequential File
Saving Report Output in INTERNAL Format
Creating A Subquery or Sequential File With HOLD FORMAT SQL_SCRIPT
Creating a Structured HOLD File
Specifying MIME Types for WebFOCUS Reports
Choosing a Display Format
Report Display Formats
Preserving Leading and Internal Blanks in Report Output
Using Web Display Format: HTML
Using Print Display Formats: PDF, PS
Using Word Processing Display Formats: DOC, WP
Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL
Using PowerPoint PPT Display Format
Using PowerPoint PPTX Display Format
Linking a Report to Other Resources
Linking Using StyleSheets
Linking to Another Report
Linking to a URL
Linking to a JavaScript Function
Linking to a WebFOCUS Maintain Procedure
Creating Multiple Drill-Down Links
Creating Parameters
Linking With Conditions
Linking From a Graphic Image
Specifying a Base URL
Specifying a Target Frame
Creating a Compound Report
Creating a PDF Compound Report With Drill Through Links
Navigating Within an HTML Report
Navigating Sort Groups From a Table of Contents
Adding the HTML Table of Contents Tree Control to Reports
Controlling the Display of Sorted Data With Accordion Reports
Navigating a Multi-Page Report With the WebFOCUS Viewer
Linking Report Pages
Bursting Reports Into Multiple HTML Files
Bursting Reports Overview
Handling Records With Missing Field Values
Irrelevant Report Data
Missing Field Values
Handling a Missing Segment Instance
Setting the NODATA Character String
Joining Data Sources
Types of Joins
How the JOIN Command Works
Creating an Equijoin
Using a Conditional Join
Full Outer Joins for Relational Data Sources
Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT
Joining From a Multi-Fact Synonym
Invoking Context Analysis for a Star Schema With a Fan Trap
Adding DBA Restrictions to the Join Condition: SET DBAJOIN
Preserving Virtual Fields During Join Parsing
Displaying Joined Structures
Clearing Joined Structures
Merging Data Sources
Merging Data
MATCH Processing
MATCH Processing With Common High-Order Sort Fields
Fine-Tuning MATCH Processing
Universal Concatenation
Merging Concatenated Data Sources
Cartesian Product
Formatting Reports: An Overview
What Kinds of Formatting Can I Do?
How to Specify Formatting in a Report
Standard and Legacy Formatting
Techniques for Quick and Easy Formatting
Navigating From a Report to Other Resources
Creating and Managing a WebFOCUS StyleSheet
Creating a WebFOCUS StyleSheet
General WebFOCUS StyleSheet Syntax
Reusing WebFOCUS StyleSheet Declarations With Macros
WebFOCUS StyleSheet Attribute Inheritance
Controlling Report Formatting
Generating an Internal Cascading Style Sheet for HTML Reports
Selecting a Unit of Measurement
Conditionally Formatting, Displaying, and Linking in a StyleSheet
Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
Conditionally Including Summary Lines, Underlines, Skipped Lines, and Page Breaks
Controlling the Display of Empty Reports
Formatting a Report Using Only StyleSheet Defaults
Identifying a Report Component in a WebFOCUS StyleSheet
Identifying an Entire Report, Column, or Row
Identifying Tags for SUBTOTAL and GRANDTOTAL Lines
Identifying Data
Identifying a Heading, Footing, Title, or FML Free Text
Identifying a Page Number, Underline, or Skipped Line
Using an External Cascading Style Sheet
What Is a Cascading Style Sheet?
Why Use an External Cascading Style Sheet?
Formatting a Report With an External Cascading Style Sheet
Working With an External Cascading Style Sheet
Applying External Cascading Style Sheet Formatting
Combining an External CSS With Other Formatting Methods
Linking to an External Cascading Style Sheet
Inheritance and External Cascading Style Sheets
Using External Cascading Style Sheets With Non-HTML Reports
Requirements for Using an External Cascading Style Sheet
FAQ About Using External Cascading Style Sheets
Troubleshooting External Cascading Style Sheets
Laying Out the Report Page
Selecting Page Size, Orientation, and Color
Setting Page Margins
Positioning a Report Component
Arranging Columns on a Page
Suppressing Column Display
Inserting a Page Break
Inserting Page Numbers
Adding Grids and Borders
Defining Borders Around Boxes With PPTX and PDF Formats
Displaying Superscripts On Data, Heading, and Footing Lines
Adding Underlines and Skipped Lines
Removing Blank Lines From a Report
Adding an Image to a Report
Associating Bar Graphs With Report Data
Working With Mailing Labels and Multi-Pane Pages
Using Headings, Footings, Titles, and Labels
Creating Headings and Footings
Including an Element in a Heading or Footing
Repeating Headings and Footings on Panels in PDF Report Output
Customizing a Column Title
Controlling Column Title Underlining Using a SET Command
Controlling Column Title Underlining Using a StyleSheet Attribute
Creating Labels to Identify Data
Formatting a Heading, Footing, Title, or Label
Applying Font Attributes to a Heading, Footing, Title, or Label
Adding Borders and Grid Lines
Justifying a Heading, Footing, Title, or Label
Choosing an Alignment Method for Heading and Footing Elements
Aligning a Heading or Footing Element in an HTML, XLSX, EXL2K, or PDF Report
Aligning a Heading or Footing Element Across Columns in an HTML or PDF Report
Aligning Content in a Multi-Line Heading or Footing
Positioning Headings, Footings, or Items Within Them
Controlling the Vertical Positioning of a Heading or Footing
Placing a Report Heading or Footing on Its Own Page
Formatting Report Data
Specifying Font Format in a Report
Specifying Background Color in a Report
Specifying Data Format in a Report
Positioning Data in a Report
Creating a Graph
Content Analysis: Determining Graphing Objectives
The GRAPH Command
Creating an HTML5 Graph
Selecting a Graph Type
Selecting Values for the X and Y Axes
Creating Multiple Graphs
Plotting Dates in Graphs
Refining the Data Set For Your Graph
Displaying Missing Data Values in a Graph
Applying Conditional Styling to a Graph
Linking Graphs to Other Resources
Adding Labels to a Graph
Applying Custom Styling to a Graph
Saving a Graph as an Image File
Printing a Graph
Creating Financial Reports With Financial Modeling Language (FML)
Reporting With FML
Creating Rows From Data
Supplying Data Directly in a Request
Performing Inter-Row Calculations
Referring to Rows in Calculations
Referring to Columns in Calculations
Referring to Rows and Columns in Calculations
Referring to Cells in Calculations
Using Functions in RECAP Calculations
Inserting Rows of Free Text
Adding a Column to an FML Report
Creating a Recursive Model
Reporting Dynamically From a Hierarchy
Customizing a Row Title
Formatting an FML Report
Suppressing the Display of Rows
Saving and Retrieving Intermediate Report Results
Creating HOLD Files From FML Reports
Creating a Free-Form Report
Creating a Free-Form Report
Designing a Free-Form Report
Using SQL to Create Reports
Supported and Unsupported SQL Statements
Using SQL Translator Commands
SQL Translator Support for Date, Time, and Timestamp Fields
Index Optimized Retrieval
TABLEF Optimization
SQL INSERT, UPDATE, and DELETE Commands
Improving Report Processing
Rotating a Data Structure for Enhanced Retrieval
Optimizing Retrieval Speed for FOCUS Data Sources
Automatic Indexed Retrieval
Data Retrieval Using TABLEF
Preserving the Internal Matrix of Your Last Report
Compiling Expressions
Master Files and Diagrams
EMPLOYEE Data Source
JOBFILE Data Source
EDUCFILE Data Source
SALES Data Source
CAR Data Source
LEDGER Data Source
FINANCE Data Source
REGION Data Source
EMPDATA Data Source
TRAINING Data Source
COURSE Data Source
JOBHIST Data Source
JOBLIST Data Source
LOCATOR Data Source
PERSINFO Data Source
SALHIST Data Source
VIDEOTRK, MOVIES, and ITEMS Data Sources
VIDEOTR2 Data Source
Gotham Grinds Data Sources
Century Corp Data Sources
Error Messages
Displaying Messages
Table Syntax Summary and Limits
TABLE Syntax Summary
TABLEF Syntax Summary
MATCH Syntax Summary
FOR Syntax Summary
TABLE Limits
Referring to Fields in a Report Request
Referring to an Individual Field
Referring to Fields Using Qualified Field Names
Referring to All of the Fields in a Segment
Displaying a List of Field Names
Launch PDF
Describing Data With WebFOCUS Language
Understanding a Data Source Description
A Note About Data Source Terminology
What Is a Data Source Description?
How an Application Uses a Data Source Description
What Does a Master File Describe?
Creating a Data Source Description
Naming a Master File
What Is in a Master File?
Identifying a Data Source
Identifying a Data Source Overview
Specifying a Data Source Name: FILENAME
Identifying a Data Source Type: SUFFIX
Specifying Byte Order
Specifying Data Type: IOTYPE
Providing Descriptive Information for a Data Source: REMARKS
Specifying a Physical File Name: DATASET
Creating and Using a Master File Profile
Describing a Group of Fields
Defining a Single Group of Fields
Identifying a Logical View: Redefining a Segment
Relating Multiple Groups of Fields
Logical Dependence: The Parent-Child Relationship
Logical Independence: Multiple Paths
Cardinal Relationships Between Segments
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Recursive Relationships
Relating Segments From Different Types of Data Sources
Rotating a Data Source: An Alternate View
Describing an Individual Field
Field Characteristics
The Field Name: FIELDNAME
The Field Synonym: ALIAS
The Displayed Data Type: USAGE
The Stored Data Type: ACTUAL
Null or MISSING Values: MISSING
Describing an FML Hierarchy
Defining a Dimension: WITHIN
Validating Data: ACCEPT
Specifying Acceptable Values for a Dimension
Alternative Report Column Titles: TITLE
Documenting the Field: DESCRIPTION
Multilingual Metadata
Describing a Virtual Field: DEFINE
Describing a Calculated Value: COMPUTE
Describing a Filter: FILTER
Describing a Sort Object: SORTOBJ
Calling a DEFINE FUNCTION in a Master File
Using Date System Amper Variables in Master File DEFINEs
Parameterizing Master and Access File Values Using Variables
Converting Alphanumeric Dates to WebFOCUS Dates
Describing a Sequential, VSAM, or ISAM Data Source
Sequential Data Source Formats
Standard Master File Attributes for a Sequential Data Source
Standard Master File Attributes for a VSAM or ISAM Data Source
Describing a Multiply Occurring Field in a Free-Format Data Source
Describing a Multiply Occurring Field in a Fixed-Format, VSAM, or ISAM Data Source
Redefining a Field in a Non-FOCUS Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
Describing a Token-Delimited Data Source
Describing a FOCUS Data Source
Types of FOCUS Data Sources
Designing a FOCUS Data Source
Describing a Single Segment
GROUP Attribute
ACCEPT Attribute
INDEX Attribute
Describing a Partitioned FOCUS Data Source
Multi-Dimensional Index (MDI)
Defining a Join in a Master File
Join Types
Static Joins Defined in the Master File: SEGTYPE = KU and KM
Using Cross-Referenced Descendant Segments: SEGTYPE = KL and KLU
Dynamic Joins Defined in the Master File: SEGTYPE = DKU and DKM
Conditional Joins in the Master File
Comparing Static and Dynamic Joins
Joining to One Cross-Referenced Segment From Several Host Segments
Creating a Cluster Master File
Creating a Business View of a Master File
Grouping Business Logic In a Business View
Checking and Changing a Master File: CHECK
Checking a Data Source Description
CHECK Command Display
PICTURE Option
HOLD Option
Providing Data Source Security: DBA
Introduction to Data Source Security
Implementing Data Source Security
Specifying an Access Type: The ACCESS Attribute
Limiting Data Source Access: The RESTRICT Attribute
Controlling the Source of Access Restrictions in a Multi-file Structure
Adding DBA Restrictions to the Join Condition
Placing Security Information in a Central Master File
Summary of Security Attributes
Hiding Restriction Rules: The ENCRYPT Command
FOCEXEC Security
Creating and Rebuilding a Data Source
Creating a New Data Source: The CREATE Command
Rebuilding a Data Source: The REBUILD Command
Optimizing File Size: The REBUILD Subcommand
Changing Data Source Structure: The REORG Subcommand
Indexing Fields: The INDEX Subcommand
Creating an External Index: The EXTERNAL INDEX Subcommand
Checking Data Source Integrity: The CHECK Subcommand
Changing the Data Source Creation Date and Time: The TIMESTAMP Subcommand
Converting Legacy Dates: The DATE NEW Subcommand
Creating a Multi-Dimensional Index: The MDINDEX Subcommand
Master Files and Diagrams
EMPLOYEE Data Source
JOBFILE Data Source
EDUCFILE Data Source
SALES Data Source
CAR Data Source
LEDGER Data Source
FINANCE Data Source
REGION Data Source
EMPDATA Data Source
TRAINING Data Source
COURSE Data Source
JOBHIST Data Source
JOBLIST Data Source
LOCATOR Data Source
PERSINFO Data Source
SALHIST Data Source
VIDEOTRK, MOVIES, and ITEMS Data Sources
VIDEOTR2 Data Source
Gotham Grinds Data Sources
Century Corp Data Sources
Error Messages
Displaying Messages
Launch PDF
Developing Reporting Applications
WebFOCUS Application Logic
Three-Tier Application Logic
Deploying a Partitioned Project
WebFOCUS Components
Storing and Searching for Application Files
Section 508 Accessibility in WebFOCUS
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Application Metadata Commands and Catalog Metadata
Help Information: APP HELP
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Coding a User Interface
Which Tools Can You Use?
The WebFOCUS Client
Using the Servlet
Using a Dynamic Multiselect Drop-Down List
Enabling Ad Hoc Reporting
Validating a Form With JavaScript
Amper Auto-Prompting
Displaying a Report on the Default WebFOCUS Page
Designing an HTML Page for Report Display
Enhancing a User Interface
Displaying a Report in a Helper Application
Controlling Multiple Reports
Adding JavaScript for Drill-Down Reporting
Facilitating Report Manipulation
Using a Cascading Style Sheet to Standardize Display
Displaying a Previously Run Report
Passing a User ID From HTML for a Custom Menu
Managing Flow of Control in an Application
Uses for Dialogue Manager
Dialogue Manager Processing
Creating a Dialogue Manager Procedure
Customizing a Procedure With Variables
Creating a Standard Quote-Delimited String
Creating and Working With Variables
Using Numeric Amper Variables in Functions
Controlling the Execution of a Procedure
Navigating a Procedure
Enhancing an HTML Webpage With a Procedure
Issuing Operating System Commands
Controlling Passwords With Dialogue Manager
Sending a Message to the Application
Testing and Debugging a Dialogue Manager Procedure
Dialogue Manager Process Flow in the Procedure Viewer
Dialogue Manager Syntax Reference
Testing and Debugging a Procedure
Debugging Your Application With Query Commands
Displaying Combined Structures
Displaying Virtual Fields
Displaying the Currency Data Source in Effect
Displaying Available Fields
Displaying the File Directory Table
Displaying Field Information for a Master File
Displaying Data Source Statistics
Displaying Current ddnames Assigned With FILEDEF
Displaying Defined Functions
Displaying HOLD Fields
Displaying JOIN Structures
Displaying National Language Support
Displaying Explanations of Error Messages
Displaying the Current Search Path
Displaying the Release Number
Displaying the Values of a Remote Server
Displaying Parameter Settings
Displaying Parameters That Cannot Be Set in an Area
Displaying Graph Parameters
Displaying the Site Code of the Connected Server
Displaying Command Statistics
Displaying StyleSheet Parameter Settings
Displaying Information About the SU Machine
Displaying Data Sources Specified With USE
Displaying Global Variable Values
Identifying the Files Being Used
Managing the WebFOCUS Environment
Setting Up a WebFOCUS Environment
Refreshing or Removing an Environment
Accessing a FOCUS Data Source
The USE Command
The Developer Studio Use Tool
Identifying a FOCUS Data Source
Using Alternative File Specifications
Identifying a New Data Source
Protecting a Data Source
Concatenating Data Sources
Displaying the Current USE Options
Clearing the USE Options
Customizing Your Environment
When Do You Use the SET Command?
Ways to Issue a SET Command
Issuing a SET Command With the Set Tool
Coding a SET Command
Types of SET Parameters
SET Parameter Syntax
Defining and Allocating WebFOCUS Files
Allocating WebFOCUS Files
Application Files Under Windows
Extract Files Under Windows
Work Files Under Windows
Determining If A File Exists Under Windows
WebFOCUS Files Under MVS
Application Files Under MVS
Extract Files Under MVS
Work Files Under MVS
Reviewing Attributes of Allocated Files Under MVS
Application Files Under UNIX
Extract Files Under UNIX
Work Files Under UNIX
Determining If A File Exists Under UNIX
Using the Command Console
Command Console Window
Working in the Command Console
Euro Currency Support
Integrating the Euro Currency
Converting Currencies
Creating the Currency Data Source
Identifying Fields That Contain Currency Data
Activating the Currency Data Source
Processing Currency Data
Querying the Currency Data Source in Effect
Punctuating Numbers
Selecting an Extended Currency Symbol
Launch PDF
Using Functions
How to Use This Manual
Available Languages
Operating Systems
Introducing Functions
Using Functions
Types of Functions
Character Chart for ASCII and EBCDIC
Accessing and Calling a Function
Calling a Function
Supplying an Argument in a Function
Calling a Function From a DEFINE, COMPUTE, or VALIDATE Command
Calling a Function From a Dialogue Manager Command
Calling a Function From Another Function
Calling a Function in WHERE or IF Criteria
Calling a Function in WHEN Criteria
Calling a Function From a RECAP Command
Storing and Accessing an External Function
Character Functions
Character Function Notes
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CHKNUM: Checking a String for Numeric Format
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
XMLDECOD: Decoding XML-Encoded Characters
XMLENCOD: XML-Encoding Characters
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Simplified Character Functions
CHAR_LENGTH: Returning the Length in Characters of a String
DIGITS: Converting a Number to a Character String
LOWER: Returning a String With All Letters Lowercase
LPAD: Left-Padding a Character String
LTRIM: Removing Blanks From the Left End of a String
POSITION: Returning the First Position of a Substring in a Source String
RPAD: Right-Padding a Character String
RTRIM: Removing Blanks From the Right End of a String
SUBSTRING: Extracting a Substring From a Source String
TOKEN: Extracting a Token From a String
TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
UPPER: Returning a String With All Letters Uppercase
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
KKFCUT: Truncating a String
SFTDEL: Deleting the Shift Code From DBCS Data
SFTINS: Inserting the Shift Code Into DBCS Data
Maintain-specific Character Functions
CHAR2INT: Translating a Character Into an Integer Value
INT2CHAR: Translating an Integer Value Into a Character
LCWORD and LCWORD2: Converting a Character String to Mixed-Case
LENGTH: Determining the Length of a Character String
LJUST: Left-Justifying a Character String (Maintain)
LOWER: Converting a Character String to Lowercase
MASK: Extracting or Adding Characters
MNTGETTOK: Extracting Tokens From a String Function
NLSCHR: Converting Characters From the Native English Code Page
OVRLAY: Overlaying a Character String (Maintain)
POSIT: Finding the Beginning of a Substring (Maintain)
RJUST: Right-Justifying a Character String (Maintain)
SELECTS: Decoding a Value From a Stack
STRAN: Substituting One Substring for Another
STRCMP: Comparing Character Strings
STRICMP: Comparing Character Strings and Ignoring Case
STRNCMP: Comparing Character Substrings
STRTOKEN: Extracting a Substring Based on Delimiters
SUBSTR: Extracting a Substring (Maintain)
TRIM: Removing Trailing Occurrences (Maintain)
TRIMLEN: Determining the Length of a String Excluding Trailing Spaces
UPCASE: Converting Text to Uppercase (Maintain)
Data Source and Decoding Functions
DB_EXPR: Inserting an SQL Expression Into a Request
DB_INFILE: Testing Values Against a File or an SQL Subquery
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
DPART: Extracting a Component From a Date
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
CVTSTIME: Converting the System Date and Time (OpenVMS Only)
GETSTIME: Extracting the System Date and Time (OpenVMS Only)
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
HGETC: Storing the Current Date and Time in a Date-Time Field
HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HHMS: Converting a Date-Time Value to a Time Value
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HMASK: Extracting Date-Time Components and Preserving Remaining Components
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS or TIMETOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
WRTSTIME: Converting Dates to 64-Bit DEC Date/Time Format (OpenVMS Only)
Simplified Date and Date-Time Functions
DTADD: Incrementing a Date or Date-Time Component
DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
DTPART: Returning a Date or Date-Time Component in Integer Format
DTRUNC: Returning the Start of a Date Period for a Given Date
Maintain-specific Date and Time Functions
Maintain-specific Standard Date and Time Functions
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Binary Integer to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Maintain-specific Light Update Support Functions
IWC.FindAppCGIValue: Retrieving a WebFOCUS Parameter or Variable Value
IWC.GetAppCGIValue: Importing a WebFOCUS Parameter or Variable
Numeric Functions
ABS: Calculating Absolute Value
ASIS: Distinguishing Blank From Zero
BAR: Producing a Bar Chart
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
FMLINFO: Returning FOR Values
FMLLIST: Returning an FML Tag List
FMLFOR: Retrieving FML Tag Values
FMLCAP: Retrieving FML Hierarchy Captions
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
MIRR: Calculating the Modified Internal Return Rate
NORMSDST and NORMSINV: Calculating Normal Distributions
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
Maintain-specific Script Functions
IWCLink: Displaying a URL in a Browser or Frame
IWCSwitchToSecure and IWCSwitchToUnsecure: Turning the Secure Sockets Layer On and Off
IWCTrigger: Calling a Maintain Function From a Script Handler
IWC.FindAppCGIValue: Finding a WebFOCUS Parameter or Variable Value
IWC.GetAppCGIValue: Retrieving a WebFOCUS Parameter or Variable
System Functions
CHECKPRIVS: Retrieving the Privilege State for the Connected User
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FINDMEM: Finding a Member of a Partitioned Data Set
FPUTENV: Assigning a Value to an Environment Variable
GETCOOKI: Retrieving a Browser Cookie Value
GETHEADR: Retrieving an HTTP Header Variable
GETPDS: Determining If a Member of a Partitioned Data Set Exists
GETUSER: Retrieving a User ID
GRPLIST: Retrieving the Group List of the Connected User
JOBNAME: Retrieving the Current Process Identification String
MVSDYNAM: Passing a DYNAM Command to the Command Processor
PUTCOOKI: Submitting a Value to a Browser Cookie
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SPAWN: Creating a Subprocess From a Procedure
SYSTEM: Calling a System Program
SYSVAR: Retrieving the Value of a z/OS System Variable
Creating a Subroutine
Writing a Subroutine
Compiling and Storing a Subroutine
Testing the Subroutine
Using a Custom Subroutine: The MTHNAM Subroutine
Subroutines Written in REXX
Launch PDF
DataMigrator Functions
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
Information Builders and iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and a Process Flow
Performing Server Administration Tasks
Using Secure Shell FTP (SFTP)
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Aerial View
Ribbon Tabs
Metadata Tab
Text Editor Tab
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding Email Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
How to Use a Variable in a Synonym
Creating, Enhancing, and Editing Synonyms Using Modeling View
Adding Indexes to a Synonym
Adding Virtual Columns (DEFINE) in a Synonym
Viewing Data Profiling Characteristics
Viewing Data Lineage for a Column
Advanced DataMigrator Tips and Techniques
Overview of Examples
Creating Sample Data and Metadata
Horizontal Partitioning with Multi-Table Load
Using the Decode Function
Generating a Surrogate Key
Generating a Surrogate Key Using Slowly Changing Dimensions
Mapping to a Sequential File of a Specific Format
Creating and Using Reusable Transformations
Using Multiple Targets to Create a Single File With Multiple Records Types
Creating a Target File With Multiple RECTYPEs
Combining Multiple Sources Rows in a Single Target Row
Using Lookups to Create Multi-Table Flows Without Joins
Record Logging
Using Variables in Data Flows
Creating a Data Flow Using a Target Based on a Predefined XML Schema
Loading a Target Table Using the File Listener
Sending a Target File to an FTP or SFTP Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Loading Images Into a Database Table
Change Data Capture
Enabling the Database for Logging in Relational Databases
Enabling the Database for Logging in VSAM
Properties of a Table Log Record Synonym
Tutorial: Using Change Data Capture with Relational Databases
Tutorial: Using Change Data Capture With VSAM
DataMigrator Log Statistics and Tables
Log and Statistics Tables
Event-Based Scheduling
Starting Flows With CMRUN
Starting Flows With CMASAP
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Resource Analyzer Administrator's and User's Manual
What Is Resource Analyzer?
Resource Analyzer Overview
Resource Analyzer for Decision Support Analysis
Uses for Resource Analyzer: Performance Analysis
Introduction to Data Access and Performance Analysis With Resource Analyzer
Sample Data Access Questions
How Resource Analyzer Works
Software Prerequisites
Overview of the Web Console
Overview of Reporting With Resource Analyzer
Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
Configuring and Administering Resource Management
Resource Management Interface
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Resource Analyzer Report Options
Reports Overview
Resource Analyzer Reporting
Resource Analyzer Report Options
General Reports
Resource Analyzer Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Usage Monitoring RDBMS Table Sizing
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Launch PDF
Resource Governor Administrator's and User's Manual
What Is Resource Governor?
Resource Governor Overview
Resource Governor Features
Resource Governor Operations
How Resource Governor Works
Resource Governor Usage Monitoring
Configuring and Administering Resource Management
Resource Management Interface
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Rules Files and Knowledge Bases
Overview
Working With Business Rules
Working with Resource Thresholds
Working with Knowledge Bases
Maintaining Knowledge Bases
Resource Governor Report Options
Reports Overview
Resource Governor Reporting
Resource Governor Report Options
General Reports
Resource Governor Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Usage Monitoring RDBMS Table Sizing
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Business Rule Language (BRL)
Using Business Rule Language (BRL)
BRL Factual Information
BRL Keywords
Pre-defined Variables
Internal Functions
Customized Rule Examples
Launch PDF