What Is SQL ?
Available as part of Simul8 Professional, SQL (Structured Query Language) is a language used to query data sources, normally databases such as Microsoft Access, but also including other SQL compatible packages, such as Microsoft Excel.
Simul8 adheres to the conventions set out in the SQL99 standards approved by the International Standards Organization (ISO).
Simul8 SQL is an extremely powerful way of reading and writing data to and from a data source. Simul8 can create new records, and update or delete existing ones.
Using an external data source reduces the memory overhead for Simul8, and allows access to huge volumes of “real” data, possibly stored on a separate machine or network drive.
Setting up the database source on your PC
Simul8 SQL requires a valid “alias” to exist in the machine running Simul8. An Alias is commonly known as a Data Source Name.
New Data Source Names can be created by using the ODBC Data Source Administrator supplied as part of Windows.
Open the Control Panel.
Open Administrative Tools / Data Sources (ODBC).
On the ODBC Data Source Administrator interface, click on “Add…”
You are now ready to activate the database import module in the simulation. See the Help file Setting Up a Database Input for instructions on how to set up the SQL Connection within Simul8.
Visual Logic Commands