Procedure dataset design

Multiple sub datasets can be created using procedures.

1.Select [Add Store] from the right mouse click popup menu on the [DATABASE] in the data window.

2.Add database store using the Add Database Connection Information dialog.

3.Select [Add Procedure Dataset] from the right mouse click popup menu on the database store you have created.

4.Enter your dataset name, select schema, and click [Search] in Stored Procedure dialog. Select your procedure from the result list and click [Next].

5.Enter value of the input parameter, select the output parameter and click [Finish]. The dataset appears under store.

Naming rule of sub dataset

The sub dataset name of the procedure dataset is automatically set to the procedure dataset name with appendix "_#" where "#" represents a serial number. For example, if set the procedure dataset name to "MULTISET" in the Stored Procedure dialog, The sub dataset name will be "MULTISET_1", "MULTISET_2", etc. To change the dataset name, select [Modify] from the right mouse click popup menu on the dataset.

Auto mapping

Click the [Auto mapping] automatically set the input parameter to the value in the form of "#OZParam.parametername#".

Setting input and output

If you want to set the parameters of the procedure to enter the parameter values in the Input option. The parameter values can be entered directly, or you can set a user-defined parameter. If the "Apply Null" is True, you can not directly enter the parameter value.

The parameters to get the procedure execution result is set in the Output option.