topic how to store JSL output to a SQL database in Discussions

how to store JSL output to a SQL database

dilipkumar — Wed, 18 Sep 2019 06:57:26 GMT

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

Re: how to store JSL output to a SQL database

txnelson — Wed, 18 Sep 2019 12:59:21 GMT

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

Re: how to store JSL output to a SQL database

dilipkumar — Thu, 26 Sep 2019 06:34:18 GMT

@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

Re: how to store JSL output to a SQL database

GM — Thu, 26 Sep 2019 14:44:27 GMT

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