how to store JSL output to a SQL database

Question

Hi ,

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.

Regards,

Dilip

GM · Answer

@dilipkumar Have you reviewed this thread

https://community.jmp.com/t5/Discussions/Save-to-Database-is-too-slow-10k-records-per-minute/m-p/10264

It seems that if you are using JMP13 or later version you may be in luck.

dilipkumar · Answer

@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.

Regards,

DIlip

txnelson · Answer

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]
VALUES
          ('TestSQLinsert'
          ,1
          ,1
          ,'JMP'
          ,14.14
          ,14.14
          ,1
          ,'JMP'
          ,'JMP'
          ,'JMP'
          ,14
          ,14
              )"
);

close database connection(dbc);