Micro Focus XDBC Version 2.0 for Windows

Micro Focus XDBC Version 2.0 for Windows

Users Guide

1. Introduction

Product Features

Relational Database Features

Data Access Features

System Catalog and the Role of XFDs

Universal Configuration

System Security

Multi-company Support

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

REDEFINES Clause

Multiple Record Definitions

FILLER Data Items

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

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

Starting the Micro Focus XDBC Server Component

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

Additional Installation and Configuration

Setting or Switching the COBOL Runtime on Windows

Installed Files

6. Using Micro Focus XDBC

Quick-start Demo Program

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

System Catalog Structure

INFORMATION_SCHEMA

INFORMATION_SCHEMA.COLUMNS

INFORMATION_SCHEMA.TABLES

INFORMATION_SCHEMA.VIEWS

8. Using the Command-line Query Tool

Starting xdbcquery

Starting xdbcquery from mfsql

Starting xdbcquery from the Command Line

xdbcquery Commands

Running SQL Scripts

9. Supported SQL Commands

Limitations and Restrictions

Summary of Supported 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

11. Using Fileshare with Micro Focus XDBC

Configuring Micro Focus XDBC for Fileshare access

Technical Walkthrough

Setting up Fileshare

CCI Configuration

Starting Fileshare

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

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

2. Forming the Final XFD Name

3. Possibly Nondeterministic Queries

4. Sample Configuration File

Sample Micro Focus XDBC File

5. Sample net.ini File

6. Clauses and Statements

FROM Clause (SELECT Statement)

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

CREATE VIEW command

Inserting, Updating, and Deleting Values in Views

DELETE command

Searched Deletions

Positioned Deletions

Prepared DELETE Statements

DROP INDEX command

DROP SYNONYM command

DROP TABLE command

DROP VIEW command

GRANT (Database Privileges) command

GRANT (Object Privileges) command

Privileges Cascade

REVOKE (Database Privileges) command

REVOKE (Object Privileges) command

SELECT command

SET OPTION command

SET PASSWORD statement

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

Directive Syntax

ALPHA directive

BINARY directive

COMMENT directive

CREATEXFD directive

DATE directive

Example 1 - Elementary Data Item, DATE Directive

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

FY and RY Date Formats

HIDDEN directive

NUMERIC directive

READ-ONLY directive

SUBTABLE directive

USE GROUP directive

VAR_LENGTH directive

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

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

Data truncation (max: number)

End of buffer reached

Ending quote missing

Function name not implemented yet

GENESIS_HOME environment variable not 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

Notify tech support

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

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 error code

Unknown node (type: name)

Copyright and Trademarks

Notations and Conventions