For the latest version of JMP Help, visit JMP.com/help.

Scripting Guide > Extending JMP > Database Access
Publication date: 09/28/2021

Database Access

Run Query Builder Queries

Query Builder is the preferred method for selecting and importing data from a SQL database without writing SQL statements. You can preview the data before importing it into a data table. Share your queries so that other users can customize and run the queries.

After you create the query, you can run the query with a JSL script. Use Include() to include the query in your script without opening it.

query = Include( "$DOCUMENTS/Airline.jmpquery" );
query << Run Foreground( );

Instead of running the query in the foreground, you can use Run Background() to run the query in the background or Run() to use the Query Builder preference for running queries. By default, queries run in the background.

See SQL in the JSL Syntax Reference for more information about query messages.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).