topic Re: Define JMP Table Name where output from SQL Server in Discussions

Define JMP Table Name where output from SQL Server

RamManickam — Fri, 09 Jun 2023 23:27:04 GMT

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.

Re: Define JMP Table Name where output from SQL Server

pmroz — Mon, 27 Apr 2020 14:16:57 GMT

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>)

Re: Define JMP Table Name where output from SQL Server

RamManickam — Mon, 27 Apr 2020 15:45:43 GMT

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"
);