i have written some query in JSL and want to save the output values in SQL data base.
Can anyone help me in doing that.
I am not very experienced in directly interfacing JMP to SQL, however, here is a response from @vince_faller Writing to an SQL database that writes multiple values.
dbc = Create Database Connection("DRIVER=SQL SERVER;SERVER=fake_database;Database=Test_DB");
sqlreturn = Execute SQL(dbc,
"INSERT INTO [Test_DB].[dbo].[fake]
close database connection(dbc);
@txnelson Thanks for Reply.
Actually i have created one table in jmp. I just want to save that table into SQL data base using JSL.
@dilipkumar Have you reviewed this thread
It seems that if you are using JMP13 or later version you may be in luck.
There are no labels assigned to this post.