#SQL

SQL is a standard language for storing, manipulating and retrieving data in relational databases.

Month

Question

Jean Millette · Jun 3

What's this odd behavior with "select count()" and a Unique Index?

Hello,

I have a class with a "Unique" index (pxfactidIndex) on a %Numeric property (pxfactid) (partially-edit code snippet below):

#Indexing #ObjectScript #SQL #InterSystems IRIS

0 8

0 108

Question

Andrew McCrevan · Jun 5

SQL Procedure - Equivalent to "IN LIKE"

How would you go about creating an SQL Stored Procedure that would result in the same output as "IN LIKE"?
For example...

CustomersTable

#SQL #Caché #InterSystems IRIS

0 5

0 74

Question

Scott Roth · Jun 4

End of EnsLib.SQL.Inbound Query

Is there a way in a EnsLib.SQL.InboundAdpapter that you can tell when you have reached the end of the Results of the Query?

#Business Service #SQL #HealthShare #InterSystems IRIS for Health #Health Connect

0 3

0 43

Question

Scott Roth · Jun 4

SQL Query - HL7 Message/HL7 ACK

Does anyone have a query that I could run to show a Vendor the time difference between when a message was sent out a BO, and when we received the HL7 ACK back that is associated with the message sent?

I am trying to prove to this vendor of the delay we are seeing getting the ACK back because of a Timeout

I know how to pull Ens.MessageHeader, and EnsLib.HL7.Message but not sure how to match up the Message with the HL7 Acknowledgement received.

#HL7 #SQL #HealthShare #InterSystems IRIS for Health #Health Connect

0 1

0 31