Save your SQL query as a .jmpquery file to modify or run the query later. You are prompted to enter the password if the server connection string does not specify it. The .jmpquery file can also be opened and run by a JSL script.
After you build a query, click Save in the lower right corner to save the settings as a .jmpquery file. Clicking Save again overwrites the file with your latest changes. Clicking Save As saves the query in a new .jmpquery file.
A query file opens in Query Builder by default, where you modify the query and then run it as needed to import the data. After you are satisfied with the query, you can configure it to run when opened instead of opening in Query Builder.
When you are building the query, select Run on Open from the red triangle menu next to the Query Name box in the upper left corner.
To override the Run on Open setting, press Ctrl (Windows) or Command (macOS) before opening the file from the file system. On Windows, you can also right-click the query in the JMP Home Window and select Edit Query.
You can also use the .jmpquery file as a starting point for a new query. This option prevents you from overwriting your original query if you accidentally click Save. It works the same as clicking Save As after you modify the query.
1. Right-click the .jmpquery file in the JMP Home Window’s Recent Files list.
2. Select Open as Template.
3. Modify the query and click Save to create a new .jmpquery file.
Note: The .jmpquery file contains database login information. You must have set up the database connection before running the query. See Connect to a Database With Open Table.