Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

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

 

Article Labels

    There are no labels assigned to this post.