Multi-dataset design

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

2.Enter Multi Dataset Name in the Add Multi Dataset dialog.

3.Design the query using the query window in the Manual mode.

4.The written query statement is as follows.

SELECT * FROM Customers

SELECT * FROM Employees

5.To execute SQL statement, select [Run] > [Run Query] from the menubar or click the [Run Query icon] on the toolbar.

Writing multi-dataset query

Enter  procedure or multiple queries in the query window of the multi dataset.

•Ex 1. Separate queries by a blank.

SELECT * FROM Customers SELECT * FROM Employees

•Ex 2. Separate queries by a newline.

SELECT * FROM Customers

SELECT * FROM Employees

Note

The master set property of the sub dataset is not configurable and one of the multi dataset is inherited.

Multi dataset is supported only in the manual mode for MSSQL and SYBASE.