Preface

Purpose of this document

This is a guide for the developers of Fujitsu Enterprise Postgres applications.

Intended readers

This document is intended for developers of applications that use Fujitsu Enterprise Postgres. Of the interfaces provided by Fujitsu Enterprise Postgres, this guide describes the PostgreSQL extended interface.

Readers of this document are also assumed to have general knowledge of:

PostgreSQL
SQL
Linux

PostgreSQL
SQL
Windows

Structure of this document

This document is structured as follows:

Chapter 1 Overview of the Application Development Function: Provides an overview of Fujitsu Enterprise Postgres application development.

Chapter 2 JDBC Driver: Explains how to use JDBC drivers.

Chapter 3 ODBC Driver: Explains how to use ODBC drivers.

Chapter 4 .NET Data Provider: Explains how to use .NET Data Provider.

Chapter 5 C Library (libpq): Explains how to use C applications.

Chapter 6 Embedded SQL in C: Explains how to use embedded SQL in C.

Chapter 7 Embedded SQL in COBOL: Explains how to use embedded SQL in COBOL.

Chapter 8 Python Language Package (psycopg): Explains how to use Python language package (psycopg).

Chapter 9 SQL References: Explains the SQL statements which were extended in Fujitsu Enterprise Postgres development.

Chapter 10 Compatibility with Oracle Databases: Explains features that are compatible with Oracle databases.

Chapter 11 Application Connection Switch Feature: Explains the application connection switch feature.

Chapter 12 Scan Using a Vertical Clustered Index (VCI): Explains how to perform scan using a Vertical Clustered Index (VCI).

Appendix A Precautions when Developing Applications: Provides some points to note about application development.

Appendix B Conversion Procedures Required due to Differences from Oracle Database: Explains how to convert from an Oracle database to Fujitsu Enterprise Postgres, within the scope noted in "Compatibility with Oracle Databases" from the following perspectives.

Appendix C Tables Used by the Features Compatible with Oracle Databases: Explains the tables used by the features compatible with Oracle databases.

Appendix D ECOBPG - Embedded SQL in COBOL: Explains application development using embedded SQL in COBOL.

Appendix E Quantitative Limits: This appendix explains limitations.

Appendix F Reference: Provides a reference for each interface.

Appendix G DBMS_SQL Package: Explains the DBMS_SQL package.

Export restrictions

Exportation/release of this document may require necessary procedures in accordance with the regulations of your resident country and/or US export control laws.

Issue date and version

Edition 2.0: March 2025
Edition 1.0: November 2024