cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
RamManickam
Level I

Define JMP Table Name where output from SQL Server

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’"

);

 

 

RamManickam_0-1587991556076.png

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: Define JMP Table Name where output from SQL Server

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

 

View solution in original post

2 REPLIES 2
pmroz
Super User

Re: Define JMP Table Name where output from SQL Server

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

 

RamManickam
Level I

Re: Define JMP Table Name where output from SQL Server

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