So I have created a JSL script to open a csv file and analyze the data. I also created an SQL script that actually generates the csv file that JSL calls. I know there is a way to join these scripts together so I don't have to run one, wait for the csv file to generate, then call the JSL script once it's finished. Right now I have a batch file that calls the SQL file then calls the JSL file (which I put a Wait(300) delay at the top of to give the SQL script enough time to generate the csv file).
There has to be a better way then having the cmd line open two different files. And I don't know how to access the SQL database via JMP. It doesn't show up anywhere.