How do you load a written SQL procedure that joins multiple tables across multiple databases and performs functions prior to output?
Jul 15, 2016 6:16 AM
| Last Modified: Aug 20, 2020 6:16 AM
In his Advanced Mastering JMP webcast on accessing databases, Chris Kirchberg chris.kirchberg described three ways to import your own custom SQL rather than use JMP Query Builder (which was first available in JMP 12) to build the SQL. He explains that for accessing MULTIPLE databases it may be best to use JMP Scripting Language (JSL) to execute your custom SQL.