| Feedback |
This manual describes how to use the FOCUS® DB2®, DB2 for VM™, Teradata®, Oracle®, and CA-IDMS® relational data adapters. It applies to FOCUS Version 7.2 and to all RDBMS releases, except where noted. References to MVS® also apply to OS/390® and z/OS™. References to VM or VM/CMS also apply to z/VM™. You should use this manual in conjunction with the FOCUS for S/390® Documentation Set (DN1001080.1101).
With one or more of the FOCUS relational data adapters installed, you can use FOCUS to update, analyze, and report from data stored in tables and views of the Relational Database Management System (RDBMS).
To use the data adapter effectively, you must be familiar with basic FOCUS reporting and database maintenance procedures. You must also have access to relational table information, including the data within the tables and views themselves, and descriptive information about them (table names, column names, and data types). Check with your RDBMS database administrator (DBA) about table descriptions, storage, and other site-specific considerations.
Chapter/Appendix |
Contents |
|
1 |
Describes how the data adapters function and how to use them. |
|
2 |
Explains how to invoke the data adapters with sample CLISTs, EXECs, and JCL. |
|
3 |
Describes how to connect to relational data sources and discusses security. |
|
4 |
Describes single-table Master and Access Files. |
|
5 |
Describes multi-table Master and Access Files. |
|
6 |
Describes the AUTODB2, AUTOSQL, and AUTODBC facilities that generate Master and Access Files for existing RDBMS tables and the FOCUS CREATE FILE command that creates RDBMS tables given a Master and Access File. |
|
7 |
Discusses how the data adapters pass certain data manipulation operations to the RDBMS for processing. It also describes the FOCUS EXPLAIN Utility. |
|
8 |
Describes advanced reporting topics such as the TABLEF command, the HOLD command, and the JOIN command. |
|
9 |
Describes how to issue data adapter and SQL commands using the Direct SQL Passthru facility and how to include parameter markers in Direct SQL Passthru commands. |
|
10 |
Describes commands for connecting to and disconnecting from the RDBMS, automatically issuing COMMIT WORK commands, and opening and closing DB2 threads. |
|
11 |
Lists environmental commands that display and change the parameters that govern your FOCUS session and the Dialogue Manager variables that store the values of those parameters. |
|
12 |
Describes table maintenance, RDBMS-managed integrity and concurrency, FOCUS-managed integrity and concurrency, and error handling within a maintenance procedure. |
|
13 |
Describes how to compile and run procedures that contain SQL statements. |
|
A |
Describes problem-solving aids (such as the RDBMS return code), standard FOCUS and data adapter differences, long field name considerations, default DATE considerations, and remote segment descriptions. Also contains topics specific to individual data adapters. |
|
B |
Lists common SQL return codes and describes how to access data adapter messages. |
|
C |
Contains Master and Access Files for the examples included throughout the manual. |
|
D |
Discusses data adapter trace facilities. |
|
The following conventions apply throughout this manual:
|
Convention |
Description |
|---|---|
THIS TYPEFACE or this typeface |
Denotes syntax that you must enter exactly as shown. |
this typeface
|
Represents a placeholder (or variable) in syntax for a value that you or the system must supply. |
underscore
|
Indicates a default setting. |
|
this typeface |
Represents a placeholder (or variable), a cross-reference, or an important term. It may also indicate a button, menu item, or dialog box option that you can click or select. |
|
Key + Key |
Indicates keys that you must press simultaneously. |
{ }
|
Indicates two or three choices. Type one of them, not the braces. |
[ ] |
Indicates a group of optional parameters. None are required, but you may select one of them. Type only the parameter in the brackets, not the brackets. |
| |
Separates mutually exclusive choices in syntax. Type one of them, not the symbol. |
... |
Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...). |
|
. . . |
Indicates that there are (or could be) intervening or additional commands. |
See the Information Builders Technical Publications Catalog for the most up-to-date listing and prices of technical publications, plus ordering information. To obtain a catalog, contact the Publications Order Department at (800) 969-4636.
You can also visit our World Wide Web site, http://www.informationbuilders.com, to view a current listing of our publications and to place an order.
The following summarizes standard terminology used throughout this manual:
Do you have questions about FOCUS, FOCUS products, or iWay™?
Call Information Builders Customer Support Service (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your MSO questions. Information Builders consultants can also give you general guidance regarding product capabilities and documentation. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.
You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our World Wide Web site, http:// www.informationbuilders.com. It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of www.informationbuilders.com also provides usage techniques, diagnostic tips, and answers to frequently asked questions.
To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.
To help our consultants answer your queries most effectively, please be ready to provide the following information when you call:
Your six digit site code number (xxxx-xx).
The FOCEXEC procedure (preferably with line numbers).
Master file with picture (provided by CHECK FILE).
Run sheet (beginning at login, including call to FOCUS), containing:
? RELEASE.
? FDT.
? LET.
? LOAD.
? COMBINE.
? JOIN.
? DEFINE.
? STAT.
? SET/? SET GRAPH.
? USE.
? TSO DDNAME OR CMS QFI
The exact nature of the problem: for example, are the results or is the format incorrect; does an abend occur; are the text or calculations missing or misplaced; is this related to any other problem?
Has the procedure ever worked in its present form? Has it been changed recently?
What release of the operating system are you using? Has it, FOCUS, or a data adapter system changed?
Is this problem reproducible?
Information Builders consultants can also give you general guidance on FOCUS capabilities and documentation.
You can also FAX your questions to CSS at (212) 564-1881, or upload them to the FOCWIZARD or FOCSERVICES forums on Compuserve.
In an effort to produce effective documentation, the Documentation Services staff at Information Builders welcomes any opinion you can offer regarding this manual. Please use the Reader Comments form at the end of this manual to relay suggestions for improving the publication or to alert us to corrections. You can also use the Document Enhancement Request Form on our Web site, http://www.informationbuilders.com.
Thank you, in advance, for your comments.
Interested in training? Information Builders Education Department offers a wide variety of training courses for this and other Information Builder products.
For information on course descriptions, locations, and dates, or to register for classes, visit our World Wide Web site (http://www.bib.com) or call (800) 969-INFO to speak to an Education Representative.