Search

PostgreSQL

This document describes PostgreSQL Storage Connector and Query blocks.
Index

DB Storage Connection Block

1) Create

•
Blocks that declare variables for using Storage.

2) Set to

•
Assign PostgreSQL Storage to a variable.

3) PostgreSQL Connector

•
Select PostgreSQL Storage from the drop-down list to connect.

Query Connection

1) PostgreSQL Query

•
Enter the PostgreSQL Query ID registered in Query Manager to pair.
•
Click the button to add or delete Query Parameter item.

2) Query Option Block

•
Query option block in PostgreSQL > Query category.
No.
Function
1
Click the button to add or delete Query Parameter item.
2
Register Query Bind Parameter.
3
Commit (save changes) the DB Storage's transactions connected to the Connector.
4
Roll back (revoke changes) the transaction of the DB Storage connected to the Connector.

Procedure connection

1) PostgreSQL Procedure

•
Enter the PostgreSQL Procedure ID registered in Query Manager to pair.
•
Click the button to add or delete Procedure Parameter item.

2) Procedure Option Block

•
Procedure option block in PostgreSQL > Procedure category.
No.
Function
1
Click the button to add or delete Procedure Parameter item.
2
Set parameters of the Procedure input mode.
3
Set parameters of the Procedure output mode.
4
Set the parameters of Procedure input, output mode.
5
Set the datatype of the Procedure parameter. - Configurable types string, integer, Boolean, null, cursor