Preface

Purpose of this document

This is a guide for the developers of Symfoware Server applications.

Intended readers

This document is intended for developers of applications that use Symfoware Server. Of the interfaces provided by Symfoware Server, 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 Symfoware Server 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 SQL References: Explains the SQL statements which were extended in Symfoware Server development.

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

Chapter 10 Java Applications using PL/extJava: Explains the development of Java applications using PL/extJava.

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

Chapter 12 Performance Tuning: Explains how to tune application performance.

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 Symfoware Server, 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.

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

Third edition : November 2014
Second edition: January 2014
First edition : November 2013