cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
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"
);