cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
dilipkumar
Level II

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

3 REPLIES 3
txnelson
Super User

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);
Jim
dilipkumar
Level II

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

GM
GM
Level III

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/102...

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