How to wrap %SQLCODE into %Status

Question

Question

CJ H · Oct 17, 2017

#Caché

I have a method would return %Status,

this method would run some sql queries and if the execution of these queries fail, I would like to return asap.

So how could I wrap the %SQLCODE into a %Status variable?

Thank for your help.

Discussion (5)0

Log in or sign up to continue

Vitaliy Serdtsev · Oct 18, 2017

Another variants:

#Dim sc As %Status = $$$OK
s:SQLCODE sc = ##class(%Exception.SQL).CreateFromSQLCODE(SQLCODE,%msg).AsStatus()
s:SQLCODE sc = $system.Error.FromSQLCode(SQLCODE,%msg).Status

It should also be noted the %sqlcontext, so final code will look as follows:

if SQLCODE {
 set:$IsObject($get(%sqlcontext)) %sqlcontext.%SQLCODE=SQLCODE, %sqlcontext.%Message=$get(%msg)
 set sc=$$$ERROR($$$SQLCode,SQLCODE,$g(%msg))
} else { set sc=$$$OK }

0 0

score 3 · Answer 1 · 2017-10-17T09:06:03-04:00

Eduard Lebedyuk · Oct 17, 2017

#Dim sc As %Status =  $$$ERROR($$$SQLError, SQLCODE, $g(%msg))

3 0

score 0 · Answer 2 · 2017-10-17T09:12:37-04:00

CJ H · Oct 17, 2017

Thanks.

0 0

score 0 · Answer 3 · 2017-10-18T09:22:23-04:00

set status = $$$ERROR($$$SQLError, $System.SQL.SQLCODE(SQLCODE))

Would return a %Status value with the text of the SQLCODE error available.

The previous answer would give the SQLCODE error number.

Use whichever is appropriate

score 0 · Answer 4 · 2017-10-18T09:42:00-04:00

Vitaliy Serdtsev · Oct 18, 2017

SQLCODE and %msg are closely related.

Instead of $$$SQLError, you can use $$$SQLCode.

0 0