SQL | InterSystems Developer Community

Article

Timothy Leavitt · Jul 24 4m read

Table-valued function example: querying the Application Error Log

Let's start with a simple motivating question: over the past 14 days, what are my most common errors in the Application Error Log?

#Error Handling #Management Portal #ObjectScript #SQL #InterSystems IRIS

9 2

2 93

Question

John Hotalen · Jul 25

Cache SQL - Cached Query error

Hello to all the Cache Experts out there and Happy Friday!

The company I work for uses Cache 2017.1.3 and we have been seeing intermittent errors in the Cache Error Trap when an SQL query runs. The error message looks like the error is occurring within the cached query routine that Cache auto-generates. Unfortunately, when I pulled up the routine in the SMP System Explorer, I only found an obj version, so was unable to look at any code.

#SQL #Caché

0 3

0 38

Question

Stephane Devin · Jul 29

WHat is the difference between tsql method and querry

Hi, I'm wondering what are the diferences between a method or classmethod with the language set at tsql and a querry writen in sql.
If anyone know if there is some difference and what they are, I would be glad to learn. 😊

#Databases #Database Transaction Processing #SQL #Documentation

0 3

0 22