Search

MySQL

This document describes the MySQL Storage Connector and the Query block.
Index

DB Storage Connection Block

1) Create

•
Blocks that declare variables for using Storage.

2) Set to

•
Assign MySQL Storage to a variable.

3) MySQL Connector

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

Query Connection

1) MySQL Query

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

2) Query Option Block

•
The Query options block in the MySQL > Query category.
No.
Function
1
Click the button to add or delete Query Parameter items.
2
Register Query Bind Parameter.
3
Commits the transaction(saved changes)of the DB Storage connected to the Connector.
4
Roll back the transaction( revoke changes) of the DB Storage connected to the Connector.

Procedure Connection

1) MySQL Procedure

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

2) Procedure Option Block

•
Procedure option block in MySQL > Procedure category.
No.
Function
1
Click the button to add or delete Procedure Parameter items.
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