Embedded SQL error handling

Discussion

Evgeny Shvarov · Sep 14, 2020

#Error Handling #ObjectScript #SQL #InterSystems IRIS

Hi Developers!

How do you handle errors with &sql a.k.a. embedded SQL?
I think I found a universal error-handling template which works in any situation:

&sql(SELECT * FROM Sample.Person)

if SQLCODE < 0 throw ##class(%Exception.SQL).CreateFromSQLCODE(SQLCODE,"Context description")

What is your choice?

Discussion (4)2

Robert Cemper · Sep 14, 2020

After a lot of troubles around variable scoping in past I try to avoid embedded SQL wherever possible.

2 0

Evgeny Shvarov · Sep 14, 2020

I respect your choice. Out of curiosity, what other than SQLCODE variables you noticed being changed "without a warning"?

On contrary, I started to find it handy to copy and paste working sql into &sql(). Also, SQL code looks more readable.

1 0

Robert Cemper · Sep 14, 2020

IRIS compiles NOW embedded SQL totally different from Caché / Ensemble. (external Class)
Before you could run in all kind of problems if your host variables were not %* or declared in the global variable scope.

1 0

Eduard Lebedyuk · Sep 29, 2020

$$$ERROR($$$SQLError, SQLCODE, %msg)

0 0