cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
AlbertLesire1
Level II

Run a SQL query in jsl results in the update from multiple queries slowing table creation

Hi I'm trying to troubleshoot why when I re-run a SQL script in JSL the result is the updates of different queries before the table is created. 

See outputs in print screen 

 

Note the JSL script is producing numerous tables for different attributes. The example shown is for 1 of the tables 

2 REPLIES 2
jthi
Super User

Re: Run a SQL query in jsl results in the update from multiple queries slowing table creation

Could you just remove those table scripts? If you are using concatenate it can MASSIVELY slow down due to the table scripts and this could be happening somewhere with JMP created scripts (not sure though).

-Jarmo

Re: Run a SQL query in jsl results in the update from multiple queries slowing table creation

If you're running New SQL Query, you'll want to run it in the foreground

Names Default To Here( 1 );
obj = New SQL Query(
	Connection( "ODBC:DSN=mydsn" ),
	Select(),
	From( Table( "my_table", Schema( "my_schema" ), Alias( "t1" ) ) )
);
table = obj << RunForegound;

You can also deselect "Run Queries in the Background" in JMP Preferences.

Recommended Articles