<< Click to Display Table of Contents >> Current:  Create Data Set  Script Data Set

Script Data Set implements the functions provided by SQL Data Set over script language and data interface. Such a method avoids the design limitations on SQL Data Set and makes the operations on data sets more flexible. Script Data Set provides some common Javascript function interfaces in the tool library to allow for querying data by programming. Although these interfaces are limited to the set functions, they can meet the existing daily work.

 

Besides, Script Data Set provides the cross-database data set union function that is not supported by SQL Data Set. Similar to union query in SQL, this function shows the data from different tables on one table through the script join data set method as required. Script Data Set provides more powerful functions than the union query function of SQL. SQL union data set requires that all data lists must come from the same database, whereas Script Data Set can connect the data lists from different databases. Assume that the operating data of a company is saved in DB2 database and the management data of the company is saved in Oracle database. The operating data and management data can be unioned to a new data set list for analysis through Script Data Set.