Adapter Enhancements
Topics:
DEFINE FUNCTION Optimization
SQL.Function Syntax for Direct DBMS Function Calls
Optimizing Non-Equality WHERE-based Left Outer Joins
Optimization of SUBSTR and SUBSTV Functions
Optimization of DATEADD and HADD Functions for YEAR and MONTH
IF-THEN-ELSE Optimization Enhancement
Optimizing IF-THEN-ELSE Using CASE
Passing the Exact Number of Trailing Blanks to the DBMS
Capturing Rows Affected by Direct SQL Passthru Commands as Dialogue Manager Variables
Passing the Equivalent of FOCUS PCT to the SQL Engine
Using the DPART Function in SQL Generation
Optimization of the HPART, DPART, HDIFF, HDATE, and DATEDIF Functions
Passing Virtual Fields Defined as Constants to an SQL Engine
Improved Error Diagnostics in Expression Generation
DB2 DSN3SATH Support for CA-ACF2
CAF Support for SQL Statements With Lengths Greater Than 32K
Support for DB2 Change Data Capture on z/OS
Passing the SUBSTR Character Function to SQL
Support of Multirow-Fetch for DB2 (CAF)
Support for Oracle BIGINT Data Type
Support for Oracle Change Data Capture (CDC)
Enhanced DECIMAL Data Type Support for Oracle
This chapter describes new features that affect FOCUS adapters (Interfaces).
Information Builders