ProDBI
ODBC Interface for Quintus Prolog
V4.0, January 1997

supplied by

Keylink Computers Ltd
keylink@dial.pipex.com

CONTENTS

1 INTRODUCTION
2 USING THE INTERFACE
2.1 Connecting to a DBMS
2.2 Disconnecting from a Database
2.3 Ending a Prolog session
2.4 Accessing a database table
2.4.1 Augmenting queries for attached tables
2.4.2 Specifying connection for db_attach
2.5 Type conversions
2.5.1 From Prolog to DBMS
2.5.2 From DBMS to Prolog
2.6 Joins
2.7 Relational Operators
2.8 Retrieving partial tables
2.9 Alternative access to DBMS tables
2.10 Cursor based access
2.11 Long fields
3 DATA DICTIONARY
3.1 Data sources
3.2 Database tables
3.3 Table arity
3.4 Table columns
3.5 Table tuples
3.6 Data dictionary tables
4 OTHER DATABASE OPERATIONS
4.1 Creating tables and indexes
4.2 Deleting tables, views and indexes
4.3 Adding and deleting records
4.4 Other SQL commands
4.5 Seeing the SQL for a generated query
4.6 Seeing DBMS error messages
4.7 Setting default connection
4.8 Matching constants with nulls
4.9 Selecting date representation
5 TRANSACTION MANAGEMENT
5.1 Transactions
6 SUMMARY OF PREDICATES
6.1 Introduction
6.2 The predicates