889447_en-US

liliconcom

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 

Automation and ScriptingRe: 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).

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.