Micro Focus XDBC Version 2.0 for UNIX

Users Guide

1. Introduction

Overview

Product Features

Relational Database Features

Data Access Features

System Catalog and the Role of XFDs

Universal Configuration

System Security

Multi-company Support

XDBC Client

What Is ODBC/JDBC?

Comments on the Documentation?

2. Micro Focus XDBC Architecture

Micro Focus XDBC Design

Basic Components

System Architecture

Local Processing

Remote Processing (Network or Client-Server)

Security

Network Security Layer

Database Security Layer

3. Preparing Your COBOL

Mapping COBOL Data Items and Database Fields

The Role of XFDs

Creating XFD Files

How XFDs are Formed

Defaults Used in XFD Files

KEY IS Phrase

REDEFINES Clause

Multiple Record Definitions

Group Items

FILLER Data Items

OCCURS Clause

Identical Field Names

Examples of Default Mapping

Summary of XFD Fields

Naming the XFD File

Forming the Final XFD Name

Examples of XFD Names

How Micro Focus XDBC Locates XFD Files

Using XFD Directives

Sample Files and Examples

Supported Directives

4. Configuration

Introduction

Local Configuration

Network Configuration

5. Installation and Licensing

Licensing Micro Focus XDBC

Supported Deployment Environments

Installing Micro Focus XDBC

Installation and Usage Requirements

Installing the Micro Focus XDBC Server Component

Installing on Windows

Installing on UNIX

Starting the Micro Focus XDBC Server Component

Starting the UNIX Server

Starting the Windows Server

Installing the Micro Focus XDBC Client

Installing Micro Focus XDBC Client on Windows

Installing from the Downloadable Package

Using a Silent Install

Enabling Access to the Database

Testing the Installation and Setup from ODBC

Installing on UNIX Clients

Using the unixODBC Driver

Additional Installation and Configuration

Providing JDBC Access on UNIX

Setting or Switching the COBOL Runtime on Windows

Installed Files

6. Using Micro Focus XDBC

Quick-start Demo Program

Use the Demo Program from UNIX

Using the Demo Program from Windows

Using the Demo Program from Java

General Setup Procedures

Creating and Setting up Access to a Database

Creating a System Catalog and Views

mfdbcutil Syntax

Granting Database Privileges

Loading the System Catalog with Your XFDs

Setting Up File Aliases

Multi-company Support

Setting Permissions on Your Database Tables

Starting Micro Focus XDBC on the Server (Network Only)

Pinging Micro Focus XDBC Server

Stopping Micro Focus XDBC Server

Setting Up DSNs on the Client

Copying DSNs to Other Network Machines

7. The System Catalog

Introduction

System Catalog Structure

PUBLIC

GENESIS Tables

INFORMATION_SCHEMA

INFORMATION_SCHEMA.COLUMNS

INFORMATION_SCHEMA.TABLES

INFORMATION_SCHEMA.VIEWS

DUAL

8. Using the Command-line Query Tool

Introduction

Starting xdbcquery

Starting xdbcquery from mfsql

Starting xdbcquery from the Command Line

xdbcquery Commands

Running SQL Scripts

9. Supported SQL Commands

Introduction

Conventions

Limitations and Restrictions

Object names

Constraints

Predicates

Summary of Supported SQL Commands

SQL Commands

Micro Focus XDBC Functions

10. Working with Windows and Java Applications

Working With Windows Applications

Accessing Data From Word

Accessing Data From Excel

Accessing Data From Access

Working with Java Applications

Source File and String URL Syntax Sample

sample.java

Compile the Source File

Run the Application with vortex.jar

11. Using Fileshare with Micro Focus XDBC

Overview

Configuring Micro Focus XDBC for Fileshare access

Technical Walkthrough

Setting up the initial COBOL program

Setting up Fileshare

CCI Configuration

CCI Startup

Starting Fileshare

Fileshare Testing Examples

Example 1

Example 2

Example 3

How to...

To prevent the owner of a table from being displayed

To install Micro Focus XDBC on a network (general process)

Server Procedure

Windows Client Procedure

UNIX Client Procedure

To set up a client ODBC DSN

To create a system catalog using a script

To create a system catalog using mfdbcutil

To grant database privileges

To modify privileges for existing users

To load XFDs using a script

To load XFDs using the mfdbcutil utility

To set up a multi-company DSN with wildcard substitution

To set up multi-company with separate schemas (table ownership)

To set permissions on your database tables

To start Micro Focus XDBC on the server

To add a DSN to the ODBC Data Source Administrator

Micro Focus XDBC Setup: General Tab

Micro Focus XDBC Setup: Advanced Tab

Micro Focus XDBC Setup: Logging Tab

To access data from Word

Choose Your Data Source

Add Your Tables

Finish Preparing Your Document

To access data from Excel

Choose Your Data Source

Add Your Tables

To access data from Access

Choose Your Data Source

Add Your Tables

Reference

1. Data Types

2. Forming the Final XFD Name

3. Possibly Nondeterministic Queries

Examples

4. Sample Configuration File

Sample Micro Focus XDBC File

5. Sample net.ini File

6. Clauses and Statements

FROM Clause (SELECT Statement)

Joins

Outer Joins

GROUP BY Clause (SELECT Statement)

HAVING Clause (SELECT Statement)

ORDER BY Clause (SELECT Statement)

SELECT List (SELECT Statement)

WHERE Clause (SELECT statement)

7. Commands

CREATE INDEX command

CREATE SYNONYM command

CREATE TABLE command

NULL or NOT NULL Designation

Default Values and Collations

Ownership and Access Control

Example

CREATE VIEW command

Inserting, Updating, and Deleting Values in Views

Example

DELETE command

Searched Deletions

Positioned Deletions

Prepared DELETE Statements

GRANT (Database Privileges) command

GRANT (Object Privileges) command

REVOKE (Database Privileges) command

REVOKE (Object Privileges) command

SELECT command

SELECT Clauses

SET OPTION command

SET PASSWORD statement

UPDATE command

8. Configuration Variables

DEBUG_LOGFILE configuration variable

DEBUG_LOGLEVEL configuration variable

DICTSOURCE configuration variable

FILE_CASE configuration variable

FILE_PREFIX configuration variable

FILE_SUFFIX configuration variable

FILENAME_WILDCARD configuration variable

IGNORE_OWNER configuration variable

INVALID_NUMERIC_DATA configuration variable

JULIAN_BASE_DATE configuration variable

KEY_CONNECT configuration variable

NULL_ALPHA_READ configuration variable

NULL_ALPHA_WRITE configuration variable

NULL_NUMERIC_READ configuration variable

NULL_NUMERIC_WRITE configuration variable

PACKETSIZE configuration variable

READ_ONLY configuration variable

READ_TIMEOUT configuration variable

RETURN_ERRNO configuration variable

WRITE_TIMEOUT configuration variable

9. Directives

DATE directive

Example 1 - Elementary Data Item, DATE Directive

Example 2 - Group Data Item, DATE and USE GROUP Directives

FY and RY Date Formats

WHEN directive

WHEN Directive with TABLENAME Clause

10. Error Messages

Cannot open file filename

Catalog table name corrupted or out of date

Character array too big (max: number)

Column name already defined

Column name undefined

CONFIG

Create view column count mismatch (create: number, select number)

CURDUP

Data truncation (max: number)

End of buffer reached

Function name not implemented yet

GENESIS_HOME environment variable not found

GENONLY

HOSTNOT FOUND

Identifier too long

If any numeric operand is NULL then only '==' and '!=' are valid

Illegal character

Illegal number of parameters for built-in function

Invalid parameter

Invalid password

Invalid predicate result (NULL or invalid datatype)

No data source specified

No locks available on UPDATE

Non aggregates require a GROUP BY expression

NULL not allowed for column

Number of columns does not match number of values

Operation requires named authorization

Sort column name out of range (1 - number)

String too long

Sub-query must return a single column

Table name undefined

TIDUSED

to_char/date/ number's format mask must be a constant string

Too many columns number (max: number)

Too many columns specified

Too many cursors opened

Too many sort columns (max: number)

Too many sub-queries at level number(max: number)

Too many tables in SELECT (max: number)

Unknown node (type: name)

Notations and Conventions