DataMigrator Server/WebFOCUS Reporting Server Technical Library
Technical Support
Technical Support
Release 7704
WebFOCUS Reporting Server
Server Administration
Server Introduction
Using the Web Console
Console Options
Other Icon Options
Configuration Overview
Running and Configuring the FOCUS Database Server (z/OS Only)
Server Profiles
Profile Commands
Server Security
Server Security Overview
Configuring Authentication
Configuring Privileges and Other Authorizations
Retrieving a User and Group List on OPSYS Security Registrations
Configuring Server Encryption
Access to Connection Information in WebFOCUS Procedures
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Reports and Help
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Data Adapters
Configuring an Adapter
Changing the Adapter Configuration
Configuring a Remote Server
Metadata
Creating Synonyms
Testing Synonyms
Managing Synonyms
Metadata Wizard
Stored Procedures
Creating a Stored Procedure
Editing a Stored Procedure
Running a Stored Procedure
Scheduling a Procedure
Sending an E-mail Notification for a Procedure
Stress Testing a Procedure
Running Impact Analysis Reports
Server Workspace Manager
Configuring Workspace Manager
Workspace Configuration Settings
Editing Configuration Files
Fine-Tuning the Server
Monitoring Server Activity
Listeners and Special Services
Using the Listeners and Special Services Configuration Panes
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 USS/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
Launch PDF
Adapter Administration
Introduction to Adapters
Processing Requests
Functions of an Adapter
Data Management
Metadata Services With SQLENGINE SET
Additional Master File Attributes
Using the Adapter for 1010data
Configuring the Adapter for 1010data
Managing 1010data Metadata
Customizing the 1010data Environment
Optimization Settings
Using the Adapter for Adabas
Preparing the Adabas Environment
Configuring the Adapter for Adabas
Adabas Overview
Managing Adabas Metadata
Overview of Master and Access Files
Master Files for Adabas
Access Files for Adabas
Mapping Adabas Descriptors
Mapping Adabas Files With Variable-Length Records and Repeating Fields
Using the GROUP Attribute to Cross-Reference Files
Platform-Specific Functionality
Customizing the Adabas Environment
Adabas Reporting Considerations
Adabas Writing Considerations
Adapter Navigation
Entry Segment Retrieval of Adabas Records
Descendant Periodic Groups and Multi-Value Fields
Descendant Adabas Records
Using the Adapter for Adabas Stored Procedures
Preparing the Adabas Stored Procedures Environment
Configuring the Adapter for Adabas Stored Procedures
Managing Adabas Stored Procedure Metadata
Invoking an Adabas Stored Procedure
Using the Adapter for Caché
Preparing the Caché Environment
Configuring the Adapter for Caché
Managing Caché Metadata
Customizing the Caché Environment
Optimization Settings
Using the Adapter for CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Configuring the Adapter for CICS Transactions
Managing CICS Transaction Metadata
Invoking a CICS Transaction
Running a TPG/SPG/AAS Transaction
Using the Adapters for C-ISAM and ISAM
Preparing the Environment
Configuring the Adapter
Managing C-ISAM Metadata
Maintaining C-ISAM Data Sources Using SQL Commands
Using a Secondary Index in C-ISAM and ISAM Files
Using the Adapter for DATACOM
Preparing the DATACOM Environment
Configuring the Adapter for DATACOM
DATACOM Overview and Mapping Considerations
Managing DATACOM Metadata
Master Files for DATACOM
Access Files for DATACOM
Describing Multi-File Structures for DATACOM
Data Retrieval Logic for DATACOM
Using the Adapter for DB2
Preparing the DB2 Environment
Configuring the Adapter for DB2
Managing DB2 Metadata
Reporting Against a DB2 Stored Procedure
Customizing the DB2 Environment
Optimization Settings
Using DB2 Cube Views
Calling a DB2 Stored Procedure Using SQL Passthru
Using the Adapter for DB Heritage Files
Preparing the DB Heritage Files Environment
Configuring the Adapter for DB Heritage Files
Managing DB Heritage Files Metadata
Standard Master File Attributes for a DB Heritage Files Data Source
Redefining a Field in a DB Heritage Files Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Multi-Format Logical Files
DB Heritage Files Record Selection Efficiencies
Using the Adapter for Enterprise Java Beans
Preparing the Web Application Server Environment
Configuring the Adapter for Enterprise Java Beans
Managing Enterprise Java Beans Metadata
Using the Adapter for ERwin
Preparation Steps for ERwin
Configuring the Adapter for ERwin
Enhancing Synonyms With ERwin Metadata
Using the Adapter for Essbase
Preparing the Essbase Environment
Configuring the Adapter for Essbase
Managing Essbase Metadata
Customizing the Essbase Environment
Essbase Reporting With WebFOCUS
Modifying Essbase Data
Using the Adapter for Excel
Configuring the Adapter for Excel
Managing Excel Metadata
Customizing the Excel Environment
Optimization Settings
Using the Adapter for Excel (via Direct Retrieval)
Configuring the Adapter for Excel (via Direct Retrieval)
Managing Metadata for Excel (via Direct Retrieval)
Using the Adapters for Flat and Delimited Flat Files
Preparing the Environment
Configuring the Adapters for Flat and Delimited Flat Files
Managing Metadata for Flat and Delimited Flat Files
Using the Adapter for 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 CA-IDMS/DB
Preparing the IDMS/DB Environment
Configuring the Adapter for IDMS/DB
IDMS/DB Overview and Mapping Considerations
Managing IDMS/DB Metadata
Master Files for IDMS/DB
Access Files for IDMS/DB
IDMS/DB Sample File Descriptions
File Retrieval
Record Retrieval
Customizing the IDMS/DB Environment
Tracing the Adapter for IDMS/DB
Using the Adapter for CA-IDMS/SQL
Preparing the IDMS/SQL Environment
Configuring the Adapter for IDMS/SQL
Managing IDMS/SQL Metadata
Customizing the IDMS/SQL Environment
Optimization Settings
Using the Adapter for IMS
IMS Environments: Overview
Preparing the IMS Environment
Configuring the Adapter for IMS
Managing IMS Metadata
Master File Attributes
Access File Attributes (DBCTL)
Migrating From an Existing MVS Server (DBCTL)
WebFOCUS Reporting With IMS
Maintaining IMS Data Sources (DBCTL)
Using the Adapter for IMS Transactions
Preparing the IMS Transactions Environment
Supported Platforms and Release Information
Configuring the Adapter for IMS Transactions
Managing IMS Transactions Metadata
Invoking an IMS Transaction
Invoking an IMS Stored Procedure
Using the Adapter for Information Manager
IBM Information/Management
How the Server Works With Information/Management
InfoMan Hardware and Software Requirements
Configuring the Adapter for InfoMan
Defining the Adapter for InfoMan User ID and Session ID
InfoMan Access Control
Server Security in InfoMan
IBM Information/Management Database Security
AUTOIMAN Configuration File
Describing InfoMan Data Sources
Executing AUTOIMAN
Working With AUTOIMAN
Master File Generation Facility in InfoMan
PIDT Selection Panel in InfoMan
Retrieval PIDT Name Confirmation in InfoMan
Using the Adapter for Informix
Preparing the Informix Environment
Configuring the Adapter for Informix
Managing Informix Metadata
Customizing the Informix Environment
Optimization Settings
Calling an Informix Stored Procedure Using SQL Passthru
Using the Adapter for Ingres
Preparing the Ingres Environment
Configuring the Adapter for Ingres
Managing Ingres Metadata
Optimization Settings
Using the Adapter for Interplex
Preparing the Interplex Environment
Configuring the Adapter for Interplex
Managing Interplex Metadata
Customizing the Interplex Environment
Optimization Settings
Using the Adapter for iWay Adapter Framework (IWAF)
Preparing the IWAF Environment
Configuring the Adapter for IWAF
Creating Synonyms
Using the Adapter for JDBC
Preparing the JDBC Environment
Configuring the Adapter for JDBC
Managing JDBC Metadata
Customizing the JDBC Environment
Optimization Settings
Using the Adapter for JD Edwards EnterpriseOne
Preparing the JD Edwards EnterpriseOne Environment
Overview of the Setup Process
Configuring the Adapter for JD Edwards EnterpriseOne
Creating Synonyms for JD Edwards EnterpriseOne
Refreshing the Metadata Repository
Refresh Security Extracts
Converting Synonyms for JD Edwards EnterpriseOne (Non IBM i Platforms Only)
Setting the UDCDIC Environment Variable (Windows only)
Using the Adapter for JD Edwards World
Installation Prerequisites
Configuring the Adapter for JD Edwards World
Managing JD Edwards World Metadata
Enabling JD Edwards World Security
Enabling Tracing
Frequently Asked Questions
Using the Adapter for 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 Lotus Notes
Preparing the Lotus Notes Environment
Configuring the Adapter for Lotus Notes
Managing Lotus Notes Metadata
Using the Adapter for LDAP
Preparing the LDAP Environment
Configuring the Adapter for LDAP
Managing LDAP Metadata
Using the Adapter for Microsoft Access
Preparing the Microsoft Access Environment
Configuring the Adapter for Microsoft Access
Managing Microsoft Access Metadata
Customizing the Microsoft Access Environment
Optimization Settings
Using the Adapter for MetaMatrix
Preparing the MetaMatrix Environment
Configuring the Adapter for MetaMatrix
Managing MetaMatrix Metadata
Customizing the MetaMatrix Environment
Optimization Settings
Using the Adapter for Microsoft SQL Server
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server
Managing Microsoft SQL Server Metadata
Reporting Against a Microsoft SQL Server Stored Procedure
Customizing the Microsoft SQL Server Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Microsoft SQL Server Compatibility With ODBC
Using the Adapter for Millennium
Preparing the Server Environment for Millennium
Configuring the Adapter for Millennium
Preparing the Millennium Environment
Managing Millennium Metadata
Standard Master File Attributes for a Millennium Data Source
Using the Adapter for Model 204
Preparing the Model 204 Environment
Configuring the Adapter for Model 204
Model 204 Overview and Mapping Considerations
Managing Model 204 Metadata
Master Files for Model 204
Access Files for Model 204
Customizing the Model 204 Environment
Using Customized Security Exits
Adapter Tracing for Model 204
Using the Adapter for MQSeries
Preparing the MQSeries Environment
Configuring the Adapter for MQSeries
Managing MQSeries Metadata
Customizing the MQSeries Environment
Using the Adapter for Digital Standard Mumps
Preparing the Mumps Environment
Configuring the Adapter for Digital Standard Mumps
Managing Mumps Metadata
Including Records in a Mumps Data Source
Using the Adapter for MySQL
Preparing the MySQL Environment
Configuring the Adapter for MySQL
Managing MySQL Metadata
Customizing the Adapter for the MySQL Environment
Optimization Settings
Using the Adapter for NATURAL
Preparing the NATURAL Environment
Configuring the Adapter for NATURAL
Managing Metadata for NATURAL
Invoking a NATURAL Program
Using the Adapter for NATURAL CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Installing NATURAL Support Programs
Configuring the Adapter for NATURAL CICS Transactions
Managing NATURAL CICS Transactions Metadata
NATURAL Data Buffer Processing API
Invoking a NATURAL CICS Transaction
Using the Adapter for Netezza
Preparing the Netezza Environment
Configuring the Adapter for Netezza
Managing Netezza Metadata
Customizing the Netezza Environment
Optimization Settings
Using the Adapter for Nucleus
Preparing the Nucleus Environment
Configuring the Adapter for Nucleus
Managing Nucleus Metadata
Customizing the Nucleus Environment
Optimization Settings
Using the Adapter for ODBC
Preparing the ODBC Environment
Configuring the Adapter for ODBC
Managing ODBC Metadata
Customizing the ODBC Environment
Optimization Settings
Using the Adapter for Oracle
Preparing the Oracle Environment
Configuring the Adapter for Oracle
Managing Oracle Metadata
Reporting Against an Oracle Stored Procedure
Customizing the Oracle Environment
Optimization Settings
Calling an Oracle Stored Procedure Using SQL Passthru
Using the Adapter for Oracle E-Business Suite
Preparing the Oracle E-Business Suite Environment
Data Access and Security
Configuring the Adapter for Oracle E-Business Suite
Maintaining Security Rules
Using the Adapter for parAccel
Configuring the Adapter for parAccel
Managing parAccel Metadata
Using the Adapter for PeopleSoft
Preparing the Environment
Configuring the Adapter for PeopleSoft
Managing PeopleSoft Metadata
Managing PeopleSoft Secured Data Access
Managing Connections to PeopleSoft
Using Administrative Utilities
Migrating from 7.1x and 7.6.x to 7.7
Advanced Administrative Topics
Using the Adapter for PostgreSQL
Preparing the PostgreSQL Environment
Configuring the Adapter for PostgreSQL
Managing PostgreSQL Metadata
Customizing the PostgreSQL Environment
Optimization Settings
Using the Adapter for Progress
Preparing the Progress Environment
Configuring the Adapter for Progress
Managing Progress Metadata
Customizing the Progress Environment
Optimization Settings
Using the Adapter for PSQL
Preparing the PSQL Environment
Configuring the Adapter for PSQL
Managing PSQL Metadata
Customizing the PSQL Environment
Optimization Settings
Using the Adapter for Query/400
Preparing the Adapter for Query/400 Environment
Configuring the Adapter for Query/400
Managing Query/400 Metadata
Using the Adapter for Rdb
Preparing the Rdb Environment
Configuring the Adapter for Rdb
Managing Rdb Metadata
Using Multiple Rdb DBMS Files
Using Multischema Rdb DBMS Files
Rdb Database Driver Performance
Using the Adapter for Red Brick
Preparing the Red Brick Environment
Configuring the Adapter for Red Brick
Managing Red Brick Metadata
Customizing the Red Brick Environment
Optimization Settings
Using the Adapter for Remote Servers
Configuring Remote Servers
Managing Metadata for Remote Servers
Executing Stored Procedures
Using the Adapter for RMS
Preparing the RMS Environment
Configuring the Adapter for RMS
Managing RMS Metadata
Manually Describing RMS Files
Describing Complex RMS Keyed
Associating an RMS Data Source to a Master File
Retrieving Data From RMS Files
Syntax for RMS Master File Attributes
RMS Attribute Summary
Read/Write Usage Limitations of the Adapter for RMS
Using the Adapter for 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 Siebel
Software Requirements for the Adapter for Siebel
Preparing the Siebel Environment
Preparing the Server Environment for Adapter Configuration
Configuring the Adapter for Siebel
Managing Siebel Metadata
Optimization Settings
Using the Adapter for SQLBase
Preparing the SQLBase Environment
Configuring the Adapter for SQLBase
Managing SQLBase Metadata
Customizing the SQLBase Environment
Optimization Settings
Using the Adapter for SQL Server Analysis Services (SSAS)
Preparing the SQL Server Analysis Services (SSAS) Environment
Configuring the Adapter for SQL Server Analysis Services
Managing SQL Server Analysis Services Metadata
Customizing the SQL Server Analysis Services Environment
SQL Server Analysis Services (SSAS) Reporting With WebFOCUS
Using the Adapter for Supra
Preparing the Supra Environment
Configuring the Adapter for Supra
Supra Overview and Mapping Considerations
Managing Supra Metadata
Supra Modules
Adapter Tracing
Using the Adapter for Sybase
Preparing the Sybase Environment
Configuring the Adapter for Sybase
Managing Sybase Metadata
Reporting Against a Sybase Stored Procedure
Customizing the Sybase Environment
Optimization Settings
Calling a Sybase Stored Procedure Using SQL Passthru
Using the Adapter for Teradata
Preparing the Teradata Environment
Configuring the Adapter for Teradata
Managing Teradata Metadata
Reporting Against a Teradata Stored Procedure
Customizing the Teradata Environment
Optimization Settings
Calling a Teradata Macro or Stored Procedure Using SQL Passthru
Using the Adapter for Transoft
Preparing the Transoft Environment
Configuring the Adapter for Transoft
Managing Transoft Metadata
Customizing the Transoft Environment
Optimization Settings
Using the Adapter for UniData
Preparing the UniData Environment
Configuring the Adapter for UniData
Managing UniData Metadata
Customizing the UniData Environment
Optimization Settings
Using the Adapter for UniVerse
Preparing the UniVerse Environment
Configuring the Adapter for UniVerse
Managing UniVerse Metadata
Customizing the UniVerse Environment
Optimization Settings
Using the Adapter for VSAM
Preparing the Environment for VSAM
Configuring the Adapter for VSAM
Managing VSAM Metadata
Associating a VSAM Data Source With a Master File
Standard Master File Attributes for a VSAM Data Source
Redefining a Field in a VSAM Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
VSAM Record Selection Efficiencies
Maintaining VSAM KSDS Data Sources
Using VSAM Relative Record Data Set (RRDS) Files
Reviewing SQL Updates to VSAM Data Sources
Using the Adapter for Web Services
Configuring the Adapter for Web Services
Managing Web Services Metadata
Capturing a SOAP Request Using FILEDEF SOAPTSCQ in a Procedure
Using the Adapter for XBRL
What Is XBRL?
Configuring the Adapter for XBRL
Reporting Against XBRL Instance Documents
Reporting on Dimensions
Using the Adapter for XML
Preparing the XML Environment
Configuring the Adapter for XML
Managing XML Metadata
XA Support
XA Transaction Management
Supported Interfaces
Implementation
Vendor Specifics
Aggregate Awareness Support
Relational Adapters and Aggregated SQL Queries
Aggregate Awareness in an RDBMS
Cluster Join
Embedded Joins
Embedded Join Master Files
Translating COBOL File Descriptions
Creating Synonyms From COBOL File Descriptions
Controlling the Translation of a COBOL File Description
Data Set Compression Exit: ZCOMP
Invoking the ZCOMP Exit
What Happens When ZCOMP is LOADED?
Dynamic Private User Exit
FOCSAM and the GETPRV User Exit
Physical Implementation of the GETPRV Exit
Master File for Data Access With GETPRV
Access File for Data Access With GETPRV
Calling Parameters and Work Areas
Validation for Special Characters and Reserved Words
Validation for Special Characters
Validation for Reserved Words
Launch PDF
Server Release Notes
General Information
Adapter for Netezza
Adapter for DB2 on IBM i
Adapter for ESSBASE
Adapter for JDBC
Adapter for PeopleSoft
Adapter for SQL Server Analysis Services (SSAS)
Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
Connector for OLE DB
DB2 Extender
Resource Analyzer
Run Deferred Option Changed to Submit With Options
Running or Sharing 7.7.x and 7.6.x on the Same Machine
Platform Support
DataMigrator
Active Technologies
Compound Reports
Launch PDF
Server Installation
Introduction to Server Installation
Server Versions
What to Read After You Install the Server
Server Installation for Windows
Installation Requirements
Installation and Configuration Directories
Accessing the Installation Software
Installing a Server
Verifying Server Installation
Choosing a Security Provider
Additional Server Installation Options
Generating a Trace
Third-Party Software and Licenses
General Information for a Windows Installation
Troubleshooting for Windows
Server Installation for UNIX
Installation Requirements
Installation and Configuration Directories
Installing a Server
Verifying Server Installation
Choosing a Security Provider Mode
Starting and Using a Server
Generating a Trace
Third-Party Software and Licenses
General Information for a UNIX Installation
Troubleshooting for UNIX
Server Installation for z/OS
Server Installation for HFS & PDS
HFS Deployment
PDS Deployment
Server Installation for IBM i
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Installation Program
Step 5. Verifying the Server Installation
Step 6. Configuring the Server With Different Security Providers
Starting and Using the Server
Other IBM i Start Up Options
Accessing IFS Files and QSYS Libraries
Generating a Trace
Third-Party Software and Licenses
Troubleshooting for IBM i
Server Installation for OpenVMS
Step 1. Checking System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Setup Procedure
Step 5. Verifying the Server Installation
Step 6. Configuring the Server With Different Security 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
Introducing Stored Procedures
Calling a Stored Procedure
Stored Procedure Libraries
Setting the Execution Order
Calling a Program as a Stored Procedure
Calling a Compiled Program
Calling a Program With EDARPC
Calling a Program With CALLPGM or EXEC
Calling a Program With SQL EX
Passing Parameters
Program Communication
Calling a JAVA Class as a Stored Procedure
Execute Using CALLJAVA
Execute Using EX
Execute Using SQL EX and SQL CPJAVA EX
Passing Parameters
Writing a JAVA Class
JAVA Class Communication
Compiling and Running a JAVA Program
Writing a 3GL Compiled Stored Procedure Program
Program Requirements
Setting Up the Control Block
Storing Program Values
Error Handling
Issuing the CREATE TABLE Command
Writing a Dialogue Manager Procedure
Commands Included in a Procedure
Commands and Processing
Commenting a Procedure
Sending a Message to a Client Application
Controlling Execution
Using Variables
Supplying Values for Variables
Branching
Looping
Calling Another Procedure
The -REMOTE Commands
Reading From and Writing to an External File
.EVAL Operator
Creating Expressions
Using Functions
Using Commands Specific to an Operating System
ON TABLE HOLD
ON TABLE PCHOLD
Platform-Specific Commands and Features
DYNAM Command (MVS)
Comparison of TSO Commands, JCL, and DYNAM
DDNAME Translation in User-Written Subroutines: MSODDX
FILEDEF Command Under VM
FILEDEF Command Under UNIX, Windows, IBM i, z/OS, and OpenVMS
Dialogue Manager Quick Reference
Dialogue Manager Commands
GENCPGM Usage
Using GENCPGM
Subroutine Source Examples and Runtime Testing
Launch PDF
DataMigrator Functions
Functions Overview
Function Arguments
Function Categories
Character Chart for ASCII and EBCDIC
Character Functions
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
Data Source and Decoding Functions
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HGETC: Storing the Current Date and Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Number to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Numeric Functions
ABS: Calculating Absolute Value
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
NORMSDST: Calculating Standard Cumulative Normal Distribution
NORMSINV: Calculating Inverse Cumulative Normal Distribution
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
System Functions
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FPUTENV: Assigning a Value to an Environment Variable
GETUSER: Retrieving a User ID
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SQL Character Functions
CHAR_LENGTH: Finding the Length of a Character String
CONCAT: Concatenating Two Character Strings
DIGITS: Converting a Numeric Value to a Character String
EDIT: Editing a Value According to a Format (SQL)
LCASE: Converting a Character String to Lowercase
LTRIM: Removing Leading Spaces
POSITION: Finding the Position of a Substring
RTRIM: Removing Trailing Spaces
SUBSTR: Extracting a Substring From a String Value (SQL)
TRIM: Removing Leading or Trailing Characters (SQL)
UCASE: Converting a Character String to Uppercase
VARGRAPHIC: Converting to Double-byte Character Data
SQL Date and Time Functions
CURRENT_DATE: Obtaining the Date
CURRENT_TIME: Obtaining the Time
CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
DAY: Obtaining the Day of the Month From a Date/Timestamp
DAYS: Obtaining the Number of Days Since January 1, 1900
EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
HOUR: Obtaining the Hour From Time/Timestamp
MICROSECOND: Obtaining Microseconds From Time/Timestamp
MILLISECOND: Obtaining Milliseconds From Time/Timestamp
MINUTE: Obtaining the Minute From Time/Timestamp
MONTH: Obtaining the Month From Date/Timestamp
SECOND: Obtaining the Second Field From Time/Timestamp
YEAR: Obtaining the Year From Date/Timestamp
SQL Data Type Conversion Functions
CAST: Converting to a Specific Data Type
CHAR: Converting to a Character String
CHAR: Converting to a Standard Date-Time Format
DATE: Converting to a Date
DECIMAL: Converting to Decimal Format
FLOAT: Converting to Floating Point Format
INT: Converting to an Integer
SMALLINT: Converting to a Small Integer
TIME: Converting to a Time
TIMESTAMP: Converting to a Timestamp
SQL Numeric Functions
ABS: Returning an Absolute Value (SQL)
LOG: Returning a Logarithm (SQL)
SQRT Returning a Square Root (SQL)
SQL Miscellaneous Functions
COUNTBY: Incrementing Column Values Row by Row
HEX: Converting to Hexadecimal
IF: Testing a Condition
LENGTH: Obtaining the Physical Length of a Data Item
VALUE: Coalescing Data Values
SQL Operators
CASE: SQL Case Operator
COALESCE: Coalescing Data Values
NULLIF: NULLIF Operator
Launch PDF
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and Process Flows
Performing Server Administration Tasks
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Main Menu
Toolbars
Synonym Editor Toolbar
Text Editor Toolbar
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding E-Mail Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
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 Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Change Data Capture
Tutorial: Using Change Data Capture
Enabling the Database for Logging
Change Data Capture (CDC) Configuration
Change Data Capture for VSAM on IBM z/OS
Updating Jobs
Creating Metadata for VSAM Logs
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 With Your Own API Program
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Resource Analyzer Administrator's and User's Manual
What Is Resource Analyzer?
Resource Analyzer Overview
Resource Analyzer for Decision Support Analysis
Uses for Resource Analyzer: Performance Analysis
Introduction to Data Access and Performance Analysis With Resource Analyzer
Sample Data Access Questions
How Resource Analyzer Works
Software Prerequisites
Overview of the Web Console
Overview of Reporting With Resource Analyzer
Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
Configuring and Administering Resource Management From the Web Console
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Configuring a Central Relational Repository Model
Configuring Many-to-One Monitoring
Overview of Enterprise Monitoring
Configuring the Repository Server
Configuring the Non-Repository Server
Resource Analyzer Report Options
Reports Overview
Resource Analyzer Reporting
Resource Analyzer Report Options
General Reports
Usage Analysis Reports
Domain Analysis Report
Impact Analysis Report
Performance Analysis Reports
Network Analysis Reports
Graph Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Launch PDF
Resource Governor Administrator's and User's Manual
What Is Resource Governor?
Resource Governor Overview
Resource Governor Features
Resource Governor Operations
How Resource Governor Works
Resource Governor Usage Monitoring
Configuring and Administering Resource Management From the Web Console
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Configuring a Central Relational Repository Model
Configuring Many-to-One Monitoring
Overview of Enterprise Monitoring
Configuring the Repository Server
Configuring the Non-Repository Server
Creating Business Rules
Creating Business Rules
Resource Governor Administration
The Resource Governor Administrator on the Web Console
Usage Monitoring
Rule Parameters
Building Rules
Governing
Resource Governor Reports
Resource Governor Reporting
Resource Governor Report Options
General Reports
Resource Governor Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Business Rule Language (BRL)
Using Business Rule Language (BRL)
BRL Factual Information
BRL Keywords
Pre-defined Variables
Internal Functions
Customized Rule Examples
Launch PDF
WebFOCUS Reporting Server
Server Administration
Server Introduction
Using the Web Console
Console Options
Other Icon Options
Configuration Overview
Running and Configuring the FOCUS Database Server (z/OS Only)
Server Profiles
Profile Commands
Server Security
Server Security Overview
Configuring Authentication
Configuring Privileges and Other Authorizations
Retrieving a User and Group List on OPSYS Security Registrations
Configuring Server Encryption
Access to Connection Information in WebFOCUS Procedures
Managing Applications
What Is an Application?
Procedures and Metadata on the Application Tree
Managing Applications and Paths
Application Commands Overview
Search Path Management Commands
Application and File Management Commands
Output Redirection Commands
Reports and Help
Restricting the Use of APP Commands
Accessing Metadata and Procedures
Allocating Temporary Files
Temporary Space Usage and Location
Temporary Disk Space Usage for Non-PDS Deployment
Application Tools
Data Adapters
Configuring an Adapter
Changing the Adapter Configuration
Configuring a Remote Server
Metadata
Creating Synonyms
Testing Synonyms
Managing Synonyms
Metadata Wizard
Stored Procedures
Creating a Stored Procedure
Editing a Stored Procedure
Running a Stored Procedure
Scheduling a Procedure
Sending an E-mail Notification for a Procedure
Stress Testing a Procedure
Running Impact Analysis Reports
Server Workspace Manager
Configuring Workspace Manager
Workspace Configuration Settings
Editing Configuration Files
Fine-Tuning the Server
Monitoring Server Activity
Listeners and Special Services
Using the Listeners and Special Services Configuration Panes
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 USS/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
Launch PDF
Adapter Administration
Introduction to Adapters
Processing Requests
Functions of an Adapter
Data Management
Metadata Services With SQLENGINE SET
Additional Master File Attributes
Using the Adapter for 1010data
Configuring the Adapter for 1010data
Managing 1010data Metadata
Customizing the 1010data Environment
Optimization Settings
Using the Adapter for Adabas
Preparing the Adabas Environment
Configuring the Adapter for Adabas
Adabas Overview
Managing Adabas Metadata
Overview of Master and Access Files
Master Files for Adabas
Access Files for Adabas
Mapping Adabas Descriptors
Mapping Adabas Files With Variable-Length Records and Repeating Fields
Using the GROUP Attribute to Cross-Reference Files
Platform-Specific Functionality
Customizing the Adabas Environment
Adabas Reporting Considerations
Adabas Writing Considerations
Adapter Navigation
Entry Segment Retrieval of Adabas Records
Descendant Periodic Groups and Multi-Value Fields
Descendant Adabas Records
Using the Adapter for Adabas Stored Procedures
Preparing the Adabas Stored Procedures Environment
Configuring the Adapter for Adabas Stored Procedures
Managing Adabas Stored Procedure Metadata
Invoking an Adabas Stored Procedure
Using the Adapter for Caché
Preparing the Caché Environment
Configuring the Adapter for Caché
Managing Caché Metadata
Customizing the Caché Environment
Optimization Settings
Using the Adapter for CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Configuring the Adapter for CICS Transactions
Managing CICS Transaction Metadata
Invoking a CICS Transaction
Running a TPG/SPG/AAS Transaction
Using the Adapters for C-ISAM and ISAM
Preparing the Environment
Configuring the Adapter
Managing C-ISAM Metadata
Maintaining C-ISAM Data Sources Using SQL Commands
Using a Secondary Index in C-ISAM and ISAM Files
Using the Adapter for DATACOM
Preparing the DATACOM Environment
Configuring the Adapter for DATACOM
DATACOM Overview and Mapping Considerations
Managing DATACOM Metadata
Master Files for DATACOM
Access Files for DATACOM
Describing Multi-File Structures for DATACOM
Data Retrieval Logic for DATACOM
Using the Adapter for DB2
Preparing the DB2 Environment
Configuring the Adapter for DB2
Managing DB2 Metadata
Reporting Against a DB2 Stored Procedure
Customizing the DB2 Environment
Optimization Settings
Using DB2 Cube Views
Calling a DB2 Stored Procedure Using SQL Passthru
Using the Adapter for DB Heritage Files
Preparing the DB Heritage Files Environment
Configuring the Adapter for DB Heritage Files
Managing DB Heritage Files Metadata
Standard Master File Attributes for a DB Heritage Files Data Source
Redefining a Field in a DB Heritage Files Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Multi-Format Logical Files
DB Heritage Files Record Selection Efficiencies
Using the Adapter for Enterprise Java Beans
Preparing the Web Application Server Environment
Configuring the Adapter for Enterprise Java Beans
Managing Enterprise Java Beans Metadata
Using the Adapter for ERwin
Preparation Steps for ERwin
Configuring the Adapter for ERwin
Enhancing Synonyms With ERwin Metadata
Using the Adapter for Essbase
Preparing the Essbase Environment
Configuring the Adapter for Essbase
Managing Essbase Metadata
Customizing the Essbase Environment
Essbase Reporting With WebFOCUS
Modifying Essbase Data
Using the Adapter for Excel
Configuring the Adapter for Excel
Managing Excel Metadata
Customizing the Excel Environment
Optimization Settings
Using the Adapter for Excel (via Direct Retrieval)
Configuring the Adapter for Excel (via Direct Retrieval)
Managing Metadata for Excel (via Direct Retrieval)
Using the Adapters for Flat and Delimited Flat Files
Preparing the Environment
Configuring the Adapters for Flat and Delimited Flat Files
Managing Metadata for Flat and Delimited Flat Files
Using the Adapter for 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 CA-IDMS/DB
Preparing the IDMS/DB Environment
Configuring the Adapter for IDMS/DB
IDMS/DB Overview and Mapping Considerations
Managing IDMS/DB Metadata
Master Files for IDMS/DB
Access Files for IDMS/DB
IDMS/DB Sample File Descriptions
File Retrieval
Record Retrieval
Customizing the IDMS/DB Environment
Tracing the Adapter for IDMS/DB
Using the Adapter for CA-IDMS/SQL
Preparing the IDMS/SQL Environment
Configuring the Adapter for IDMS/SQL
Managing IDMS/SQL Metadata
Customizing the IDMS/SQL Environment
Optimization Settings
Using the Adapter for IMS
IMS Environments: Overview
Preparing the IMS Environment
Configuring the Adapter for IMS
Managing IMS Metadata
Master File Attributes
Access File Attributes (DBCTL)
Migrating From an Existing MVS Server (DBCTL)
WebFOCUS Reporting With IMS
Maintaining IMS Data Sources (DBCTL)
Using the Adapter for IMS Transactions
Preparing the IMS Transactions Environment
Supported Platforms and Release Information
Configuring the Adapter for IMS Transactions
Managing IMS Transactions Metadata
Invoking an IMS Transaction
Invoking an IMS Stored Procedure
Using the Adapter for Information Manager
IBM Information/Management
How the Server Works With Information/Management
InfoMan Hardware and Software Requirements
Configuring the Adapter for InfoMan
Defining the Adapter for InfoMan User ID and Session ID
InfoMan Access Control
Server Security in InfoMan
IBM Information/Management Database Security
AUTOIMAN Configuration File
Describing InfoMan Data Sources
Executing AUTOIMAN
Working With AUTOIMAN
Master File Generation Facility in InfoMan
PIDT Selection Panel in InfoMan
Retrieval PIDT Name Confirmation in InfoMan
Using the Adapter for Informix
Preparing the Informix Environment
Configuring the Adapter for Informix
Managing Informix Metadata
Customizing the Informix Environment
Optimization Settings
Calling an Informix Stored Procedure Using SQL Passthru
Using the Adapter for Ingres
Preparing the Ingres Environment
Configuring the Adapter for Ingres
Managing Ingres Metadata
Optimization Settings
Using the Adapter for Interplex
Preparing the Interplex Environment
Configuring the Adapter for Interplex
Managing Interplex Metadata
Customizing the Interplex Environment
Optimization Settings
Using the Adapter for iWay Adapter Framework (IWAF)
Preparing the IWAF Environment
Configuring the Adapter for IWAF
Creating Synonyms
Using the Adapter for JDBC
Preparing the JDBC Environment
Configuring the Adapter for JDBC
Managing JDBC Metadata
Customizing the JDBC Environment
Optimization Settings
Using the Adapter for JD Edwards EnterpriseOne
Preparing the JD Edwards EnterpriseOne Environment
Overview of the Setup Process
Configuring the Adapter for JD Edwards EnterpriseOne
Creating Synonyms for JD Edwards EnterpriseOne
Refreshing the Metadata Repository
Refresh Security Extracts
Converting Synonyms for JD Edwards EnterpriseOne (Non IBM i Platforms Only)
Setting the UDCDIC Environment Variable (Windows only)
Using the Adapter for JD Edwards World
Installation Prerequisites
Configuring the Adapter for JD Edwards World
Managing JD Edwards World Metadata
Enabling JD Edwards World Security
Enabling Tracing
Frequently Asked Questions
Using the Adapter for 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 Lotus Notes
Preparing the Lotus Notes Environment
Configuring the Adapter for Lotus Notes
Managing Lotus Notes Metadata
Using the Adapter for LDAP
Preparing the LDAP Environment
Configuring the Adapter for LDAP
Managing LDAP Metadata
Using the Adapter for Microsoft Access
Preparing the Microsoft Access Environment
Configuring the Adapter for Microsoft Access
Managing Microsoft Access Metadata
Customizing the Microsoft Access Environment
Optimization Settings
Using the Adapter for MetaMatrix
Preparing the MetaMatrix Environment
Configuring the Adapter for MetaMatrix
Managing MetaMatrix Metadata
Customizing the MetaMatrix Environment
Optimization Settings
Using the Adapter for Microsoft SQL Server
Preparing the Microsoft SQL Server Environment
Configuring the Adapter for Microsoft SQL Server
Managing Microsoft SQL Server Metadata
Reporting Against a Microsoft SQL Server Stored Procedure
Customizing the Microsoft SQL Server Environment
Optimization Settings
Calling a Microsoft SQL Server Stored Procedure Using SQL Passthru
Microsoft SQL Server Compatibility With ODBC
Using the Adapter for Millennium
Preparing the Server Environment for Millennium
Configuring the Adapter for Millennium
Preparing the Millennium Environment
Managing Millennium Metadata
Standard Master File Attributes for a Millennium Data Source
Using the Adapter for Model 204
Preparing the Model 204 Environment
Configuring the Adapter for Model 204
Model 204 Overview and Mapping Considerations
Managing Model 204 Metadata
Master Files for Model 204
Access Files for Model 204
Customizing the Model 204 Environment
Using Customized Security Exits
Adapter Tracing for Model 204
Using the Adapter for MQSeries
Preparing the MQSeries Environment
Configuring the Adapter for MQSeries
Managing MQSeries Metadata
Customizing the MQSeries Environment
Using the Adapter for Digital Standard Mumps
Preparing the Mumps Environment
Configuring the Adapter for Digital Standard Mumps
Managing Mumps Metadata
Including Records in a Mumps Data Source
Using the Adapter for MySQL
Preparing the MySQL Environment
Configuring the Adapter for MySQL
Managing MySQL Metadata
Customizing the Adapter for the MySQL Environment
Optimization Settings
Using the Adapter for NATURAL
Preparing the NATURAL Environment
Configuring the Adapter for NATURAL
Managing Metadata for NATURAL
Invoking a NATURAL Program
Using the Adapter for NATURAL CICS Transactions
Preparing the CICS Environment
Supported Platforms and Release Information
CICS and VTAM Configuration
Installing NATURAL Support Programs
Configuring the Adapter for NATURAL CICS Transactions
Managing NATURAL CICS Transactions Metadata
NATURAL Data Buffer Processing API
Invoking a NATURAL CICS Transaction
Using the Adapter for Netezza
Preparing the Netezza Environment
Configuring the Adapter for Netezza
Managing Netezza Metadata
Customizing the Netezza Environment
Optimization Settings
Using the Adapter for Nucleus
Preparing the Nucleus Environment
Configuring the Adapter for Nucleus
Managing Nucleus Metadata
Customizing the Nucleus Environment
Optimization Settings
Using the Adapter for ODBC
Preparing the ODBC Environment
Configuring the Adapter for ODBC
Managing ODBC Metadata
Customizing the ODBC Environment
Optimization Settings
Using the Adapter for Oracle
Preparing the Oracle Environment
Configuring the Adapter for Oracle
Managing Oracle Metadata
Reporting Against an Oracle Stored Procedure
Customizing the Oracle Environment
Optimization Settings
Calling an Oracle Stored Procedure Using SQL Passthru
Using the Adapter for Oracle E-Business Suite
Preparing the Oracle E-Business Suite Environment
Data Access and Security
Configuring the Adapter for Oracle E-Business Suite
Maintaining Security Rules
Using the Adapter for parAccel
Configuring the Adapter for parAccel
Managing parAccel Metadata
Using the Adapter for PeopleSoft
Preparing the Environment
Configuring the Adapter for PeopleSoft
Managing PeopleSoft Metadata
Managing PeopleSoft Secured Data Access
Managing Connections to PeopleSoft
Using Administrative Utilities
Migrating from 7.1x and 7.6.x to 7.7
Advanced Administrative Topics
Using the Adapter for PostgreSQL
Preparing the PostgreSQL Environment
Configuring the Adapter for PostgreSQL
Managing PostgreSQL Metadata
Customizing the PostgreSQL Environment
Optimization Settings
Using the Adapter for Progress
Preparing the Progress Environment
Configuring the Adapter for Progress
Managing Progress Metadata
Customizing the Progress Environment
Optimization Settings
Using the Adapter for PSQL
Preparing the PSQL Environment
Configuring the Adapter for PSQL
Managing PSQL Metadata
Customizing the PSQL Environment
Optimization Settings
Using the Adapter for Query/400
Preparing the Adapter for Query/400 Environment
Configuring the Adapter for Query/400
Managing Query/400 Metadata
Using the Adapter for Rdb
Preparing the Rdb Environment
Configuring the Adapter for Rdb
Managing Rdb Metadata
Using Multiple Rdb DBMS Files
Using Multischema Rdb DBMS Files
Rdb Database Driver Performance
Using the Adapter for Red Brick
Preparing the Red Brick Environment
Configuring the Adapter for Red Brick
Managing Red Brick Metadata
Customizing the Red Brick Environment
Optimization Settings
Using the Adapter for Remote Servers
Configuring Remote Servers
Managing Metadata for Remote Servers
Executing Stored Procedures
Using the Adapter for RMS
Preparing the RMS Environment
Configuring the Adapter for RMS
Managing RMS Metadata
Manually Describing RMS Files
Describing Complex RMS Keyed
Associating an RMS Data Source to a Master File
Retrieving Data From RMS Files
Syntax for RMS Master File Attributes
RMS Attribute Summary
Read/Write Usage Limitations of the Adapter for RMS
Using the Adapter for 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 Siebel
Software Requirements for the Adapter for Siebel
Preparing the Siebel Environment
Preparing the Server Environment for Adapter Configuration
Configuring the Adapter for Siebel
Managing Siebel Metadata
Optimization Settings
Using the Adapter for SQLBase
Preparing the SQLBase Environment
Configuring the Adapter for SQLBase
Managing SQLBase Metadata
Customizing the SQLBase Environment
Optimization Settings
Using the Adapter for SQL Server Analysis Services (SSAS)
Preparing the SQL Server Analysis Services (SSAS) Environment
Configuring the Adapter for SQL Server Analysis Services
Managing SQL Server Analysis Services Metadata
Customizing the SQL Server Analysis Services Environment
SQL Server Analysis Services (SSAS) Reporting With WebFOCUS
Using the Adapter for Supra
Preparing the Supra Environment
Configuring the Adapter for Supra
Supra Overview and Mapping Considerations
Managing Supra Metadata
Supra Modules
Adapter Tracing
Using the Adapter for Sybase
Preparing the Sybase Environment
Configuring the Adapter for Sybase
Managing Sybase Metadata
Reporting Against a Sybase Stored Procedure
Customizing the Sybase Environment
Optimization Settings
Calling a Sybase Stored Procedure Using SQL Passthru
Using the Adapter for Teradata
Preparing the Teradata Environment
Configuring the Adapter for Teradata
Managing Teradata Metadata
Reporting Against a Teradata Stored Procedure
Customizing the Teradata Environment
Optimization Settings
Calling a Teradata Macro or Stored Procedure Using SQL Passthru
Using the Adapter for Transoft
Preparing the Transoft Environment
Configuring the Adapter for Transoft
Managing Transoft Metadata
Customizing the Transoft Environment
Optimization Settings
Using the Adapter for UniData
Preparing the UniData Environment
Configuring the Adapter for UniData
Managing UniData Metadata
Customizing the UniData Environment
Optimization Settings
Using the Adapter for UniVerse
Preparing the UniVerse Environment
Configuring the Adapter for UniVerse
Managing UniVerse Metadata
Customizing the UniVerse Environment
Optimization Settings
Using the Adapter for VSAM
Preparing the Environment for VSAM
Configuring the Adapter for VSAM
Managing VSAM Metadata
Associating a VSAM Data Source With a Master File
Standard Master File Attributes for a VSAM Data Source
Redefining a Field in a VSAM Data Source
Extra-Large Record Length Support
Describing Multiple Record Types
Combining Multiply-Occurring Fields and Multiple Record Types
Establishing VSAM Data and Index Buffers
Using a VSAM Alternate Index
VSAM Record Selection Efficiencies
Maintaining VSAM KSDS Data Sources
Using VSAM Relative Record Data Set (RRDS) Files
Reviewing SQL Updates to VSAM Data Sources
Using the Adapter for Web Services
Configuring the Adapter for Web Services
Managing Web Services Metadata
Capturing a SOAP Request Using FILEDEF SOAPTSCQ in a Procedure
Using the Adapter for XBRL
What Is XBRL?
Configuring the Adapter for XBRL
Reporting Against XBRL Instance Documents
Reporting on Dimensions
Using the Adapter for XML
Preparing the XML Environment
Configuring the Adapter for XML
Managing XML Metadata
XA Support
XA Transaction Management
Supported Interfaces
Implementation
Vendor Specifics
Aggregate Awareness Support
Relational Adapters and Aggregated SQL Queries
Aggregate Awareness in an RDBMS
Cluster Join
Embedded Joins
Embedded Join Master Files
Translating COBOL File Descriptions
Creating Synonyms From COBOL File Descriptions
Controlling the Translation of a COBOL File Description
Data Set Compression Exit: ZCOMP
Invoking the ZCOMP Exit
What Happens When ZCOMP is LOADED?
Dynamic Private User Exit
FOCSAM and the GETPRV User Exit
Physical Implementation of the GETPRV Exit
Master File for Data Access With GETPRV
Access File for Data Access With GETPRV
Calling Parameters and Work Areas
Validation for Special Characters and Reserved Words
Validation for Special Characters
Validation for Reserved Words
Launch PDF
Server Release Notes
General Information
Adapter for Netezza
Adapter for DB2 on IBM i
Adapter for ESSBASE
Adapter for JDBC
Adapter for PeopleSoft
Adapter for SQL Server Analysis Services (SSAS)
Adapter for Microsoft SQL Server 2000 Analysis Services (MSOLAP)
Connector for OLE DB
DB2 Extender
Resource Analyzer
Run Deferred Option Changed to Submit With Options
Running or Sharing 7.7.x and 7.6.x on the Same Machine
Platform Support
DataMigrator
Active Technologies
Compound Reports
Launch PDF
Server Installation
Introduction to Server Installation
Server Versions
What to Read After You Install the Server
Server Installation for Windows
Installation Requirements
Installation and Configuration Directories
Accessing the Installation Software
Installing a Server
Verifying Server Installation
Choosing a Security Provider
Additional Server Installation Options
Generating a Trace
Third-Party Software and Licenses
General Information for a Windows Installation
Troubleshooting for Windows
Server Installation for UNIX
Installation Requirements
Installation and Configuration Directories
Installing a Server
Verifying Server Installation
Choosing a Security Provider Mode
Starting and Using a Server
Generating a Trace
Third-Party Software and Licenses
General Information for a UNIX Installation
Troubleshooting for UNIX
Server Installation for z/OS
Server Installation for HFS & PDS
HFS Deployment
PDS Deployment
Server Installation for IBM i
Step 1. Reviewing System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Installation Program
Step 5. Verifying the Server Installation
Step 6. Configuring the Server With Different Security Providers
Starting and Using the Server
Other IBM i Start Up Options
Accessing IFS Files and QSYS Libraries
Generating a Trace
Third-Party Software and Licenses
Troubleshooting for IBM i
Server Installation for OpenVMS
Step 1. Checking System Requirements
Step 2. Creating User IDs
Step 3. Accessing the Installation Software
Step 4. Running the Setup Procedure
Step 5. Verifying the Server Installation
Step 6. Configuring the Server With Different Security 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
Introducing Stored Procedures
Calling a Stored Procedure
Stored Procedure Libraries
Setting the Execution Order
Calling a Program as a Stored Procedure
Calling a Compiled Program
Calling a Program With EDARPC
Calling a Program With CALLPGM or EXEC
Calling a Program With SQL EX
Passing Parameters
Program Communication
Calling a JAVA Class as a Stored Procedure
Execute Using CALLJAVA
Execute Using EX
Execute Using SQL EX and SQL CPJAVA EX
Passing Parameters
Writing a JAVA Class
JAVA Class Communication
Compiling and Running a JAVA Program
Writing a 3GL Compiled Stored Procedure Program
Program Requirements
Setting Up the Control Block
Storing Program Values
Error Handling
Issuing the CREATE TABLE Command
Writing a Dialogue Manager Procedure
Commands Included in a Procedure
Commands and Processing
Commenting a Procedure
Sending a Message to a Client Application
Controlling Execution
Using Variables
Supplying Values for Variables
Branching
Looping
Calling Another Procedure
The -REMOTE Commands
Reading From and Writing to an External File
.EVAL Operator
Creating Expressions
Using Functions
Using Commands Specific to an Operating System
ON TABLE HOLD
ON TABLE PCHOLD
Platform-Specific Commands and Features
DYNAM Command (MVS)
Comparison of TSO Commands, JCL, and DYNAM
DDNAME Translation in User-Written Subroutines: MSODDX
FILEDEF Command Under VM
FILEDEF Command Under UNIX, Windows, IBM i, z/OS, and OpenVMS
Dialogue Manager Quick Reference
Dialogue Manager Commands
GENCPGM Usage
Using GENCPGM
Subroutine Source Examples and Runtime Testing
Launch PDF
DataMigrator Functions
Functions Overview
Function Arguments
Function Categories
Character Chart for ASCII and EBCDIC
Character Functions
ARGLEN: Measuring the Length of a String
ASIS: Distinguishing Between Space and Zero
BITSON: Determining If a Bit Is On or Off
BITVAL: Evaluating a Bit String as an Integer
BYTVAL: Translating a Character to Decimal
CHKFMT: Checking the Format of a String
CTRAN: Translating One Character to Another
CTRFLD: Centering a Character String
EDIT: Extracting or Adding Characters
GETTOK: Extracting a Substring (Token)
LCWORD: Converting a String to Mixed-Case
LCWORD2: Converting a String to Mixed-Case
LCWORD3: Converting a String to Mixed-Case
LJUST: Left-Justifying a String
LOCASE: Converting Text to Lowercase
OVRLAY: Overlaying a Character String
PARAG: Dividing Text Into Smaller Lines
PATTERN: Generating a Pattern From a String
POSIT: Finding the Beginning of a Substring
REVERSE: Reversing the Characters in a String
RJUST: Right-Justifying a Character String
SOUNDEX: Comparing Character Strings Phonetically
SPELLNM: Spelling Out a Dollar Amount
SQUEEZ: Reducing Multiple Spaces to a Single Space
STRIP: Removing a Character From a String
STRREP: Replacing Character Strings
SUBSTR: Extracting a Substring
TRIM: Removing Leading and Trailing Occurrences
UPCASE: Converting Text to Uppercase
Variable Length Character Functions
Overview
LENV: Returning the Length of an Alphanumeric Field
LOCASV: Creating a Variable Length Lowercase String
POSITV: Finding the Beginning of a Variable Length Substring
SUBSTV: Extracting a Variable Length Substring
TRIMV: Removing Characters From a String
UPCASV: Creating a Variable Length Uppercase String
Character Functions for DBCS Code Pages
DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
DEDIT: Extracting or Adding Characters
DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
DSUBSTR: Extracting a Substring
JPTRANS: Converting Japanese Specific Characters
Data Source and Decoding Functions
DB_LOOKUP: Retrieving Data Source Values
DECODE: Decoding Values
FIND: Verifying the Existence of a Value in a Data Source
LAST: Retrieving the Preceding Value
LOOKUP: Retrieving a Value From a Cross-referenced Data Source
Date Functions
Overview of Date Functions
Using Standard Date Functions
DATEADD: Adding or Subtracting a Date Unit to or From a Date
DATECVT: Converting the Format of a Date
DATEDIF: Finding the Difference Between Two Dates
DATEMOV: Moving a Date to a Significant Point
DATETRAN: Formatting Dates in International Formats
FIYR: Obtaining the Financial Year
FIQTR: Obtaining the Financial Quarter
FIYYQ: Converting a Calendar Date to a Financial Date
TODAY: Returning the Current Date
Using Legacy Date Functions
AYM: Adding or Subtracting Months
AYMD: Adding or Subtracting Days
CHGDAT: Changing How a Date String Displays
DA Functions: Converting a Legacy Date to an Integer
DMY, MDY, YMD: Calculating the Difference Between Two Dates
DOWK and DOWKL: Finding the Day of the Week
DT Functions: Converting an Integer to a Date
GREGDT: Converting From Julian to Gregorian Format
JULDAT: Converting From Gregorian to Julian Format
YM: Calculating Elapsed Months
Date-Time Functions
Using Date-Time Functions
HADD: Incrementing a Date-Time Value
HCNVRT: Converting a Date-Time Value to Alphanumeric Format
HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
HDIFF: Finding the Number of Units Between Two Date-Time Values
HDTTM: Converting a Date Value to a Date-Time Value
HGETC: Storing the Current Date and Time in a Date-Time Field
HHMMSS: Retrieving the Current Time
HINPUT: Converting an Alphanumeric String to a Date-Time Value
HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
HNAME: Retrieving a Date-Time Component in Alphanumeric Format
HPART: Retrieving a Date-Time Component as a Numeric Value
HSETPT: Inserting a Component Into a Date-Time Value
HTIME: Converting the Time Portion of a Date-Time Value to a Number
HTMTOTS: Converting a Time to a Timestamp
HYYWD: Returning the Year and Week Number From a Date-Time Value
Format Conversion Functions
ATODBL: Converting an Alphanumeric String to Double-Precision Format
EDIT: Converting the Format of a Field
FPRINT: Converting Fields to Alphanumeric Format
FTOA: Converting a Number to Alphanumeric Format
HEXBYT: Converting a Decimal Integer to a Character
ITONUM: Converting a Large Number to Double-Precision Format
ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
ITOZ: Converting a Number to Zoned Format
PCKOUT: Writing a Packed Number of Variable Length
PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
UFMT: Converting an Alphanumeric String to Hexadecimal
XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
Numeric Functions
ABS: Calculating Absolute Value
CHKPCK: Validating a Packed Field
DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
EXP: Raising e to the Nth Power
EXPN: Evaluating a Number in Scientific Notation
INT: Finding the Greatest Integer
LOG: Calculating the Natural Logarithm
MAX and MIN: Finding the Maximum or Minimum Value
NORMSDST: Calculating Standard Cumulative Normal Distribution
NORMSINV: Calculating Inverse Cumulative Normal Distribution
PRDNOR and PRDUNI: Generating Reproducible Random Numbers
RDNORM and RDUNIF: Generating Random Numbers
SQRT: Calculating the Square Root
System Functions
CLSDDREC: Closing All Files Opened by the PUTDDREC Function
FEXERR: Retrieving an Error Message
FGETENV: Retrieving the Value of an Environment Variable
FPUTENV: Assigning a Value to an Environment Variable
GETUSER: Retrieving a User ID
PUTDDREC: Writing a Character String as a Record in a Sequential File
SLEEP: Suspending Execution for a Given Number of Seconds
SQL Character Functions
CHAR_LENGTH: Finding the Length of a Character String
CONCAT: Concatenating Two Character Strings
DIGITS: Converting a Numeric Value to a Character String
EDIT: Editing a Value According to a Format (SQL)
LCASE: Converting a Character String to Lowercase
LTRIM: Removing Leading Spaces
POSITION: Finding the Position of a Substring
RTRIM: Removing Trailing Spaces
SUBSTR: Extracting a Substring From a String Value (SQL)
TRIM: Removing Leading or Trailing Characters (SQL)
UCASE: Converting a Character String to Uppercase
VARGRAPHIC: Converting to Double-byte Character Data
SQL Date and Time Functions
CURRENT_DATE: Obtaining the Date
CURRENT_TIME: Obtaining the Time
CURRENT_TIMESTAMP: Obtaining the Timestamp (Date/Time)
DAY: Obtaining the Day of the Month From a Date/Timestamp
DAYS: Obtaining the Number of Days Since January 1, 1900
EXTRACT: Obtaining a Datetime Field From Date/Time/Timestamp
HOUR: Obtaining the Hour From Time/Timestamp
MICROSECOND: Obtaining Microseconds From Time/Timestamp
MILLISECOND: Obtaining Milliseconds From Time/Timestamp
MINUTE: Obtaining the Minute From Time/Timestamp
MONTH: Obtaining the Month From Date/Timestamp
SECOND: Obtaining the Second Field From Time/Timestamp
YEAR: Obtaining the Year From Date/Timestamp
SQL Data Type Conversion Functions
CAST: Converting to a Specific Data Type
CHAR: Converting to a Character String
CHAR: Converting to a Standard Date-Time Format
DATE: Converting to a Date
DECIMAL: Converting to Decimal Format
FLOAT: Converting to Floating Point Format
INT: Converting to an Integer
SMALLINT: Converting to a Small Integer
TIME: Converting to a Time
TIMESTAMP: Converting to a Timestamp
SQL Numeric Functions
ABS: Returning an Absolute Value (SQL)
LOG: Returning a Logarithm (SQL)
SQRT Returning a Square Root (SQL)
SQL Miscellaneous Functions
COUNTBY: Incrementing Column Values Row by Row
HEX: Converting to Hexadecimal
IF: Testing a Condition
LENGTH: Obtaining the Physical Length of a Data Item
VALUE: Coalescing Data Values
SQL Operators
CASE: SQL Case Operator
COALESCE: Coalescing Data Values
NULLIF: NULLIF Operator
Launch PDF
DataMigrator User's Guide
Introduction to DataMigrator
Data Management and Migration Overview
What Is DataMigrator?
DataMigrator Architecture
DataMigrator Server
DataMigrator Data Management Console
Server Web Console
Designing Data Flows and Process Flows
Revised Functionality
Getting Help
iWay Software on the Web
Setting Up DataMigrator
DataMigrator Setup At a Glance
Remote Server Setup At a Glance
DataMigrator Setup
Initiating Server Administration Tasks
Authorizing DataMigrator Server Usage and Administration
Managing Application Directories and Configuring the Application Path
Configuring Data Adapters
Creating Metadata
Testing Sample Data and Process Flows
Performing Server Administration Tasks
Upgrading DataMigrator From Release 4.3 or 5.1
Upgrading DataMigrator from Release 5.2, 5.3, 7.1, or 7.6
Planning a DataMigrator Application
Designing Your Application
Using Synonyms for Data Sources and Data Targets
Reviewing Your Data Sources
Reviewing Your Data Targets
Establishing Security for DataMigrator
Working in the Data Management Console
Data Management Console Interface
Navigation Pane
DataMigrator Workspace
Text Editor
Main Menu
Toolbars
Synonym Editor Toolbar
Text Editor Toolbar
Console Log
Setting Flow Properties
Viewing Properties
Setting User Preferences
User Privileges
License Code
Configuring National Language Support
Ending a Data Management Console Session
Designing a Data Flow
The Data Flow Interface
Simple Data Flow at a Glance
Complex Data Flow at a Glance
Creating a Data Flow
Specifying Data Sources
Creating a Source Transformation in a Data Source Object
Joining Data Sources
Adding a SELECT to a Data Flow
Adding a UNION to a Data Flow
Selecting Columns
Testing the SQL Statement
Specifying Filters in a Data Flow
Specifying Sorts
Selecting a Data Target
Specifying Data Target Options
Mapping Transformations
Using Variables in a Flow
Using Functions
Column Formats and Mapping
Setting Properties of a Flow
Running a Data Flow
Creating a Direct Load Flow
Creating a DBMS SQL Flow
Creating a Quick ETL Copy
Designing a Process Flow
Process Flow Methodology
Process Flow Interface
Simple Process Flow At a Glance
Complex Process Flow at a Glance
Creating a Process Flow
Adding a Saved Procedure to a Process Flow
Assigning and Using Variables in a Process Flow
Maintaining Continuous Processing in a Single Agent
Executing a Process Flow That Contains Only Procedures
Adding E-Mail Messages to a Process Flow
Setting Connection Logic
Grouping and Controlling Simultaneous Execution of Flows
Running a Process Flow
Scheduling a Process Flow
Tutorial: Creating Data and Process Flows With DataMigrator
What You Are Going To Do
Startup and Setup Tasks
Exercise 1: Creating the Data Flow
Selecting and Joining Data Sources
Selecting and Managing Columns
Adding Data Targets
Submitting the Data Flow
Data Flow Review
Exercise 2: Creating the Process Flow
Starting the Process Flow
Adding a Data Flow Object to the Process Flow
Branching in the Process Flow
Submitting the Process Flow
Generating Reports, Viewing the Log File, and Printing Flows
DataMigrator Log, Statistics, and Summary Flow Reports
Scheduler Reports
Impact Analysis Reports on Synonyms, Procedures and Columns
Working With a Report
Viewing a Detailed Flow Report and Log File
Printing a Graphical Representation of a Data or Process Flow
Optimizing Performance
Improving Data Extraction Performance
Using Automatic Passthru
Improving Data Loading Performance
Improving Lookup Performance
Working With Synonyms
Synonym Editor Layout
Viewing and Editing Synonym Attributes
Using Variables in a Synonym
Variables Attribute Summary
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 Server
Loading a Star Schema
Iterating Through Multiple Tables
Using Subqueries
Change Data Capture
Tutorial: Using Change Data Capture
Enabling the Database for Logging
Change Data Capture (CDC) Configuration
Change Data Capture for VSAM on IBM z/OS
Updating Jobs
Creating Metadata for VSAM Logs
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 With Your Own API Program
Starting Flows From FOCUS
Determining the Status of an Event-Based Flow
Problems, Errors, and Troubleshooting
DataMigrator Status Codes and Server Messages
Server Run-Time Error Codes
DataMigrator Management Problem Resolution
Including Run-Time Messages in the ETL Log
Performing a Trace to Diagnose Server Problems
Customizing Your Environment
DataMigrator Parameters
Source Management
Overview of Source Management
Source Control Security Server and Client Setup
Configuring Source Management and Setting Up Source Control
Using a Source Control System to Manage Procedures and Synonyms
Launch PDF
Resource Analyzer Administrator's and User's Manual
What Is Resource Analyzer?
Resource Analyzer Overview
Resource Analyzer for Decision Support Analysis
Uses for Resource Analyzer: Performance Analysis
Introduction to Data Access and Performance Analysis With Resource Analyzer
Sample Data Access Questions
How Resource Analyzer Works
Software Prerequisites
Overview of the Web Console
Overview of Reporting With Resource Analyzer
Integrating Resource Analyzer With WebFOCUS, Managed Reporting, and ReportCaster
Configuring and Administering Resource Management From the Web Console
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Configuring a Central Relational Repository Model
Configuring Many-to-One Monitoring
Overview of Enterprise Monitoring
Configuring the Repository Server
Configuring the Non-Repository Server
Resource Analyzer Report Options
Reports Overview
Resource Analyzer Reporting
Resource Analyzer Report Options
General Reports
Usage Analysis Reports
Domain Analysis Report
Impact Analysis Report
Performance Analysis Reports
Network Analysis Reports
Graph Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Launch PDF
Resource Governor Administrator's and User's Manual
What Is Resource Governor?
Resource Governor Overview
Resource Governor Features
Resource Governor Operations
How Resource Governor Works
Resource Governor Usage Monitoring
Configuring and Administering Resource Management From the Web Console
Configuring Resource Management
Administering Resource Management From the Web Console
Migrating the Resource Management Repository
Event Routing
Configuring a Central Relational Repository Model
Configuring Many-to-One Monitoring
Overview of Enterprise Monitoring
Configuring the Repository Server
Configuring the Non-Repository Server
Creating Business Rules
Creating Business Rules
Resource Governor Administration
The Resource Governor Administrator on the Web Console
Usage Monitoring
Rule Parameters
Building Rules
Governing
Resource Governor Reports
Resource Governor Reporting
Resource Governor Report Options
General Reports
Resource Governor Reports
Getting Help
Resource Management Administration Help
Reporting Application Context-Sensitive Help From Reports
Administrative Usage Monitoring Tables Column Descriptions
Administrative Tables (RMLSYS.MAS)
Usage Monitoring Table (RMLDB.MAS)
Renamed or Moved Columns
Using DDL Statements to Create the Internal Tables
Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
Business Rule Language (BRL)
Using Business Rule Language (BRL)
BRL Factual Information
BRL Keywords
Pre-defined Variables
Internal Functions
Customized Rule Examples
Launch PDF