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
3.2.3 Message Language and Encoding System Used by Applications Settings
3.3 Connecting to the Database
3.4 Application Development
3.4.1 Compiling Applications
3.4.2 Creating Applications While in Database Multiplexing Mode
3.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 4 C Library (libpq)
4.1 Development Environment
4.2 Setup
4.2.1 Environment Settings
4.2.2 Message Language and Encoding System Used by Applications Settings
4.2.3 Settings for Encrypting Communication Data
4.3 Connecting with the Database
4.4 Application Development
4.4.1 Compiling Applications
4.4.2 Creating Applications while in Database Multiplexing Mode
4.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 5 Embedded SQL in C
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 Support for National Character Data Types
5.4.2 Compiling Applications
5.4.3 Bulk INSERT
5.4.4 Creating Applications while in Database Multiplexing Mode
5.4.4.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
5.4.5 Notes
Chapter 6 Python Language Package (psycopg)
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 Creating Applications while in Database Multiplexing Mode
6.4.1.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
6.4.2 Data Types
Chapter 7 SQL References
7.1 Expanded Trigger Definition Feature
7.1.1 CREATE TRIGGER
Chapter 8 Compatibility with Oracle Databases
8.1 Overview
8.2 Precautions when Using the Features Compatible with Oracle Databases
8.2.1 Notes on search_path
8.2.2 Notes on SUBSTR
8.2.3 Notes when Integrating with the Interface for Application Development
8.3 Queries
8.3.1 Outer Join Operator (+)
8.3.2 DUAL Table
8.4 SQL Function Reference
8.4.1 DECODE
8.4.2 SUBSTR
8.4.3 NVL
8.5 Package Reference
Chapter 9 Application Connection Switch Feature
9.1 Connection Information for the Application Connection Switch Feature
9.2 Using the Application Connection Switch Feature
9.2.1 Using the JDBC Driver
9.2.2 Using the ODBC Driver
9.2.3 Using a Connection Service File
9.2.4 Using the C Library (libpq)
9.2.5 Using Embedded SQL
9.2.6 Using the psql Command
9.2.7 Using the Python Language Package (psycopg)
Chapter 10 Scan Using a Vertical Clustered Index (VCI)
10.1 Operating Conditions
10.2 Usage
10.2.1 Designing
10.2.2 Checking
10.2.3 Evaluating
10.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 Quantitative Limits
Appendix E Reference
E.1 JDBC Driver
E.2 ODBC Driver
E.2.1 List of Supported APIs
E.3 C Library (libpq)
E.4 Embedded SQL in C
Appendix F DBMS_SQL Package
F.1 When using the DBMS_SQL package compatible with Fujitsu Enterprise Postgres 16 SPz or earlier
F.2 How to Migrate Applications that Use the DBMS_SQL Package
F.2.1 Differences
F.2.2 Correction Method
F.3 DBMS_SQL Package for Fujitsu Enterprise Postgres 16 SPz and earlier
F.3.1 Description
F.3.2 Example
Top
(Collapse Contents)
Title Page
