In order to expand and collapse the table of contents, you must enable JavaScript in the browser.
(Collapse Contents)
Title Page
Preface
Chapter 1 Overview of the Application Development Function
1.1 Support for National Characters
1.1.1 Literal
1.1.2 Data Type
1.1.3 Functions and Operator
1.2 Compatibility with Oracle Database
1.3 Application Connection Switch Feature
1.3.1 Integration with Database Multiplexing
1.4 Notes on Application Compatibility
1.4.1 Checking Execution Results
1.4.2 Referencing System Catalogs
1.4.3 Using Functions
Chapter 2 JDBC Driver
2.1 Development Environment
2.1.1 Combining with JDK or JRE
2.2 Setup
2.2.1 Environment Settings
2.2.2 Message Language and Encoding System Used by Applications Settings
2.2.3 Settings for Encrypting Communication Data
2.3 Connecting to the Database
2.3.1 Using the DriverManager Class
2.3.2 Using the PGConnectionPoolDataSource Class
2.3.3 Using the PGXADataSource Class
2.4 Application Development
2.4.1 Relationship between the Application Data Types and Database Data Types
2.4.2 Creating Applications while in Database Multiplexing Mode
2.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 3 ODBC Driver
3.1 Development Environment
3.2 Setup
3.2.1 Registering ODBC Drivers
3.2.2 Registering ODBC Data Sources(for Windows(R))
3.2.2.1 Registering Using GUI
3.2.2.2 Registering Using Commands
3.2.3 Registering ODBC Data Sources(for Linux)
3.2.4 Message Language and Encoding System Used by Applications Settings
3.3 Connecting to the Database
3.4 Application Development
3.4.1 Compiling Applications (for Windows (R))
3.4.2 Compiling Applications (for Linux)
3.4.3 Creating Applications While in Database Multiplexing Mode
3.4.3.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 4 .NET Data Provider
4.1 Development Environment
4.2 Setup
4.2.1 Setting Up .NET Data Provider
4.2.2 Setting Up .NET Data Provider Type Plugins
4.2.3 Setting Up Entity Framework Core
4.2.4 Setting Up Npgsql.OpenTelemetry
4.3 Connecting to the Database
4.3.1 Using NpgsqlConnection
4.3.2 Using NpgsqlConnectionStringBuilder
4.3.3 Connection String
4.4 Application Development
4.4.1 Data Types
4.4.2 Relationship between Application Data Types and Database Data Types
4.4.3 Creating Applications while in Database Multiplexing Mode
4.4.3.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
4.4.4 Notes
4.5 Uninstallation
4.5.1 Uninstalling Npgsql
4.5.2 Uninstalling .NET Data Provider Type Plugins
4.5.3 Uninstalling Entity Framework Core
4.5.4 Uninstalling Npgsql.OpenTelemetry
Chapter 5 C Library (libpq)
5.1 Development Environment
5.2 Setup
5.2.1 Environment Settings
5.2.2 Message Language and Encoding System Used by Applications Settings
5.2.3 Settings for Encrypting Communication Data
5.3 Connecting with the Database
5.4 Application Development
5.4.1 Compiling Applications
5.4.2 Creating Applications while in Database Multiplexing Mode
5.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 6 Embedded SQL in C
6.1 Development Environment
6.2 Setup
6.2.1 Environment Settings
6.2.2 Message Language and Encoding System Used by Applications Settings
6.2.3 Settings for Encrypting Communication Data
6.3 Connecting with the Database
6.4 Application Development
6.4.1 Support for National Character Data Types
6.4.2 Compiling Applications
6.4.3 Bulk INSERT
6.4.4 Creating Applications while in Database Multiplexing Mode
6.4.4.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
6.4.5 Notes
Chapter 7 Embedded SQL in COBOL
7.1 Development Environment
7.2 Setup
7.2.1 Environment Settings
7.2.2 Message Language and Encoding System Used by Applications
7.2.3 Settings for Encrypting Communication Data
7.3 Connecting with the Database
7.4 Application Development
7.4.1 Support for National Character Data Types
7.4.2 Compiling Applications
7.4.3 Bulk INSERT
7.4.4 DECLARE STATEMENT
7.4.5 Creating Applications while in Database Multiplexing Mode
7.4.5.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 8 Python Language Package (psycopg)
8.1 Development Environment
8.2 Setup
8.2.1 Environment Settings
8.2.2 Message Language and Encoding System Used by Applications Settings
8.2.3 Settings for Encrypting Communication Data
8.3 Connecting with the Database
8.4 Application Development
8.4.1 Creating Applications while in Database Multiplexing Mode
8.4.1.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
8.4.2 Data Types
Chapter 9 SQL References
9.1 Expanded Trigger Definition Feature
9.1.1 CREATE TRIGGER
9.1.2 How to Define Triggers in pgAdmin
Chapter 10 Compatibility with Oracle Databases
10.1 Overview
10.2 Precautions when Using the Features Compatible with Oracle Databases
10.2.1 Notes on search_path
10.2.2 Notes on SUBSTR
10.2.3 Notes when Integrating with the Interface for Application Development
10.3 Queries
10.3.1 Outer Join Operator (+)
10.3.2 DUAL Table
10.4 SQL Function Reference
10.4.1 DECODE
10.4.2 SUBSTR
10.4.3 NVL
10.5 Package Reference
Chapter 11 Application Connection Switch Feature
11.1 Connection Information for the Application Connection Switch Feature
11.2 Using the Application Connection Switch Feature
11.2.1 Using the JDBC Driver
11.2.2 Using the ODBC Driver
11.2.3 Using a .NET Data Provider
11.2.4 Using a Connection Service File
11.2.5 Using the C Library (libpq)
11.2.6 Using Embedded SQL
11.2.7 Using the psql Command
11.2.8 Using the Python Language Package (psycopg)
Chapter 12 Scan Using a Vertical Clustered Index (VCI)
12.1 Operating Conditions
12.2 Usage
12.2.1 Designing
12.2.2 Checking
12.2.3 Evaluating
12.3 Usage Notes
Appendix A Precautions when Developing Applications
A.1 Precautions when Using Functions and Operators
A.1.1 General rules of Functions and Operators
A.1.2 Errors when Developing Applications that Use Functions and/or Operators
A.2 Notes when Using Temporary Tables
A.3 Implicit Data Type Conversions
A.3.1 Function Argument
A.3.2 Operators
A.3.3 Storing Values
A.4 Notes on Using Index
A.4.1 SP-GiST Index
A.5 Notes on Using Multibyte Characters in Definition Names
A.6 How to Build and Run an Application that Uses Shared Libraries
A.6.1 Setting DT_RUNPATH for Applications
A.6.2 Direct Linking of Indirectly Used Libraries to Applications
Appendix B Conversion Procedures Required due to Differences from Oracle Database
B.1 Outer Join Operator (Perform Outer Join)
B.1.1 Comparing with the ^= Comparison Operator
B.2 DECODE (Compare Values and Return Corresponding Results)
B.2.1 Comparing Numeric Data of Character String Types and Numeric Characters
B.2.2 Obtaining Comparison Result from more than 50 Conditional Expressions
B.2.3 Obtaining Comparison Result from Values with Different Data Types
B.3 SUBSTR (Extract a String of the Specified Length from Another String)
B.3.1 Specifying a Value Expression with a Data Type Different from the One that can be Specified for Function Arguments
B.3.2 Extracting a String with the Specified Format from a Datetime Type Value
B.3.3 Concatenating a String Value with a NULL value
B.4 NVL (Replace NULL)
B.4.1 Obtaining Result from Arguments with Different Data Types
B.4.2 Operating on Datetime/Numeric, Including Adding Number of Days to a Particular Day
B.4.3 Calculating INTERVAL Values, Including Adding Periods to a Date
B.5 DBMS_OUTPUT (Output Messages)
B.5.1 Outputting Messages Such As Process Progress Status
B.5.2 Receiving a Return Value from a Procedure (PL/SQL) Block (For GET_LINES)
B.5.3 Receiving a Return Value from a Procedure (PL/SQL) Block (For GET_LINE)
B.6 UTL_FILE (Perform File Operation)
B.6.1 Registering a Directory to Load and Write Text Files
B.6.2 Checking File Information
B.6.3 Copying Files
B.6.4 Moving/Renaming Files
B.7 DBMS_SQL (Execute Dynamic SQL)
B.7.1 Searching Using a Cursor
Appendix C Tables Used by the Features Compatible with Oracle Databases
C.1 UTL_FILE.UTL_FILE_DIR
Appendix D ECOBPG - Embedded SQL in COBOL
D.1 Precautions when Using Functions and Operators
D.2 Managing Database Connections
D.2.1 Connecting to the Database Server
D.2.2 Choosing a Connection
D.2.3 Closing a Connection
D.3 Running SQL Commands
D.3.1 Executing SQL Statements
D.3.2 Using Cursors
D.3.3 Managing Transactions
D.3.4 Prepared Statements
D.4 Using Host Variables
D.4.1 Overview
D.4.2 Declare Sections
D.4.3 Retrieving Query Results
D.4.4 Type Mapping
D.4.5 Handling Nonprimitive SQL Data Types
D.4.6 Indicators
D.5 Dynamic SQL
D.5.1 Executing Statements without a Result Set
D.5.2 Executing a Statement with Input Parameters
D.5.3 Executing a Statement with a Result Set
D.6 Using Descriptor Areas
D.6.1 Named SQL Descriptor Areas
D.7 Error Handling
D.7.1 Setting Callbacks
D.7.2 sqlca
D.7.3 SQLSTATE vs. SQLCODE
D.8 Preprocessor Directives
D.8.1 Including Files
D.8.2 The define and undef Directives
D.8.3 ifdef, ifndef, else, elif, and endif Directives
D.9 Processing Embedded SQL Programs
D.10 Large Objects
D.11 Embedded SQL Commands
D.11.1 ALLOCATE DESCRIPTOR
D.11.2 CONNECT
D.11.3 DEALLOCATE DESCRIPTOR
D.11.4 DECLARE
D.11.5 DESCRIBE
D.11.6 DISCONNECT
D.11.7 EXECUTE IMMEDIATE
D.11.8 GET DESCRIPTOR
D.11.9 OPEN
D.11.10 PREPARE
D.11.11 SET AUTOCOMMIT
D.11.12 SET CONNECTION
D.11.13 SET DESCRIPTOR
D.11.14 TYPE
D.11.15 VAR
D.11.16 WHENEVER
D.12 PostgreSQL Client Applications
D.12.1 ecobpg
Appendix E Quantitative Limits
Appendix F Reference
F.1 JDBC Driver
F.2 ODBC Driver
F.2.1 List of Supported APIs
F.3 .NET Data Provider
F.4 C Library (libpq)
F.5 Embedded SQL in C
Appendix G DBMS_SQL Package
G.1 When using the DBMS_SQL package compatible with Fujitsu Enterprise Postgres 16 SPz or earlier
G.2 How to Migrate Applications that Use the DBMS_SQL Package
G.2.1 Differences
G.2.2 Correction Method
G.3 DBMS_SQL Package for Fujitsu Enterprise Postgres 16 SPz and earlier
G.3.1 Description
G.3.2 Example
Top
(Collapse Contents)
Title Page
