226198_en-US

liliconcom

how to store JSL output to a SQL database

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

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

 

Re: how to store JSL output to a SQL database

@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

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