Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
gail_massari
Community Manager Community Manager

How do you load a written SQL procedure that joins multiple tables across multiple databases and performs functions prior to output?

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.

 

Article Tags
Contributors