Define JMP Table Name where output from SQL Server

[#1]

Hello Team, I created the script for data preparation and connecting to SQL Server for checking the unique values based on Join function. When ever i ran the script for open database the output table name similar like "SQL Scripts 1", so i cannot use this table name for further proceedings due to new name show when ever Run. How to set common JMP table name has output from Database. I need to give SQL statement for Table name for output.

Here is the Script is use:

Open Database(
	"DSN=SQL Master_USFLI-WAS101;UID=SVC_TableauReader;PWD=***********;APP=JMP;WSID=*********",
	"SELECT DISTINCT Individual_Claim_Number_ID_Full FROM [dbo].ALL_CUSTOMERS
WHERE Inteva_Customer_Name = 'PSA'
AND Inteva_Plant_Name_1 = 'SAL'
AND Inteva_Program_Name = 'S3M'
SET ALL_CUSTOMERS = ‘Table name’"

);

Thanks.

[#2 · Accepted solution]

Look up Open Database in the scripting index.  You can supply a table name, and it will return a pointer to a table variable:

dt = open database(<data connection string>, <sql string>, <outputTableName>)

[#3]

Thanks PMROZ... It's working fine...

dt= Open Database(
"DSN=SQL Master_USFLI-WAS101;UID=SVC_TableauReader;PWD=$zehV%os3kI7;APP=JMP;WSID=INBAN-LT9P536Q2;",
"SELECT DISTINCT Individual_Claim_Number_ID_Full FROM [dbo].ALL_CUSTOMERS
WHERE Inteva_Customer_Name = 'PSA'
AND Inteva_Plant_Name_1 = 'SAL'
AND Inteva_Program_Name = 'S3M'", "ServerData"
);