Iterate through current Row of EnsLib.SQL.Snapshot

Question

Question

Scott Roth · Nov 20

#JDBC #SQL #HealthShare #InterSystems IRIS for Health #InterSystems IRIS

I am using a JDBC connection to MS SQL server to execute a stored procedure to select data and bring it into InterSystems as a EnsLib.SQL.Snapshot. I loop through the EnsLib.SQL.Snapshot using a while loop, but I also want to iterate through the Columns within that Row to do logic.

Is there a way to iterate through the Columns of the current Row of the EnsLib.SQL.Snapshot so I can apply logic/rules for further processing?

Thanks

Scott

Product version: IRIS 2024.1

$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2U) Tue Apr 30 2024 16:06:39 EDT [HealthConnect:7.2.0-1.r1]

Discussion (4)2

Log in or sign up to continue

Marc Mundt · Nov 20

Yeah, so something like this:

for colnum=1:1:snapshot.GetColumnCount() {
    write snapshot.GetColumnName(colnum),"=",snapshot.GetData(colnum),!
}

0 0

Jeffrey Drumm · Nov 20

EnsLib.SQL.Snapshot has a GetData() method that takes the column number as its first argument (the second takes a row number but defaults to the current row). So that in conjunction with GetColumnCount() should allow you to iterate across columns.

Edit: And of course Marc beat me to it ... 😁

1 0

score 1 · Answer 1 · 2024-11-20T12:34:34-05:00

Are you doing this in ObjectScript or in a DTL?

You can use GetColumnCount, use a for loop to iterate through the column numbers, and request the data for each column using GetData, or get the column name using GetColumnName.

score 0 · Answer 2 · 2024-11-20T12:52:24-05:00

I already use Get("<column>") to pull the values, I was just looking for an easier way like with a Foreach loop