SQL | InterSystems Developer Community

Announcement

SQLTools for VS Code release (version 0.28.2)

We're excited to announce a new version release of the SQLTools VS Code extension.

SQLTools connects VS Code users to the most commonly used databases using drivers, including InterSystems IRIS. With over 3.5 million downloads, it is helping users work with their data much more easily.

#Databases #George James Software #SQL #InterSystems IRIS #VSCode

2 0

0 59

Question

Padmaja Konduru · Apr 11

Select View throwing Error "References to an SQL connection must constitute a whole subquery"

Hi,

I have created view from External table joins internal persistent table. Create VIEW worked but Select * from Viewxxx throwing error.

"References to an SQL connection must constitute a whole subquery"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...(SELECT%20*%20FROM%20Mylink.

#SQL #InterSystems IRIS

0 2

0 42

Question

Parameshwaran M... · Apr 11

Dynamically Generating SQL queries Based on Incremental Column values

I'm facing a challenge in dynamically generating SQL queries based on incremental q_ids for a project I'm working on. Here's the scenario:

#SQL #InterSystems IRIS

0 5

0 106

Article

Robert Cemper · Apr 9 2m read

Foreign Tables with CSV in action

FOREIGN TABLES is a rather fresh feature in IRIS (2023.?)
So I was motivated to try something new by own hands.
Documentation of Foreign Table from File is a good starting point.
Also the related promotional video is fine to start with.

#CSV #SQL #InterSystems IRIS

Open Exchange app

7 0

0 121

Article

Eyal Levin · Apr 8 1m read

using Procedure Parameters with ODBC/JDBC

Hi,

I was struggling with a procedure that was meant to receive a string and use it as a filter, I've found that since I want the procedure to do some data transformation and return a dataset, I needed to use objectScript language.

I've created the procedure using the SQL GUI in the portal, and everything works fine when calling the procedure from the SQL GUI but not through a JDBC connection here is the call "call spPatientOS('2024-04-07T12:35:32Z')"

#JDBC #ObjectScript #ODBC #SQL #InterSystems IRIS

3 2

0 114