cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
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