Search

MSSQL

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

DB Storage Connection Block

1) Create

•
Blocks that declare variables for using Storage.

2) Set to

•
Assign MSSQL Storage to a variable.

3) MSSQL Connector

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

Query Connection

1) MSSQL Query

•
Enter the MSSQL 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 MSSQL > 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) MSSQL Procedure

•
Enter the MSSQL 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 MSSQL > Procedure category.
No.
Function
1
Click the button to add or delete Procedure Parameter item.
2
Set the 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