261535_en-US

liliconcom

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

);

 

 

Thanks.

Data AccessRe: 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"
);

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>)</OUTPUTTABLENAME></SQL></DATA>