Question Guillaume Rongier · Sep 23, 2022 Store Procedure Returning a ResultSet with Embedded Python Hello, I'm looking for a way to write a stored procedure or something to return a ResultSet with Embedded Python. My goal is the following: I have a Goal table with a Text field that is free text. #Embedded Python #SQL #InterSystems Natural Language Processing (NLP, iKnow) #InterSystems IRIS 1 5 0 350
Question Guillaume Rongier · Dec 2, 2020 SOAP DataSet with DiffGrams Hi everyone, I need to call a SOAP service using IRIS Interoperability and this SOAP service returns a Microsoft DataSet with a DiffGrams payload. Do you know how to handle this kind of Objects ? SOAP Payload Response : #InterSystems IRIS 0 3 0 564
Question Guillaume Rongier · Jun 17, 2019 iFind Index With Relationship RowID Specification Hi,I try to implement an iFind index.Here is my definition class : #iFind #InterSystems Natural Language Processing (NLP, iKnow) #InterSystems IRIS 3 1 0 526
Question Guillaume Rongier · Jan 21, 2019 JDBC batch insert Hi, I'm looking for a way to implement the JDBC pattern "executeBatch" in ObjectScript: https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htmSince Ensemble 2017.2.2 there is a new method called executeParametersBatch : https://docs.intersystems.com/ens20172/csp/docbook/relnotes/index.html#D... #JDBC #SQL #Ensemble 1 4 0 785
Question Guillaume Rongier · Sep 20, 2018 JDBC Large query optimisation Hi, We recover a large amount of data from an external database (SQLServer, about 1 million rows in JDBC).However, we have treatment time issue.This process takes more than 30 minutes whereas on a "classic" SQL Server Management Studio type request takes less than a minute. #Database Transaction Processing #Ensemble #Business Operation #JDBC 1 7 1 1.5K
Questions