Needed Class Parameter specification and use that works SQLComputeCode

Question

Question

Chip Gore · Jan 12, 2023

In trying to define a Class Parameter that I can use in SQLComputeCode I can't seem to get any of the syntaxes for the using of the parameter where the SQL compute code will actually evaluate the parameter values. There is nothing specific that I can find in the docs about SQLCompute Code and Parameter usage.

Is there some specific syntax for accessing a class defined parameter in the SQL Compute Code that works?

This is on: IRIS for Windows (x86-64) 2022.1.1 (Build 374U) Tue Oct 18 2022 17:37:34 EDT

Discussion (4)3

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-12T12:07:51-05:00

SQL Compute Code runs outside the class context, in that circumstance you can use:

##class(YourPkg.YourClassName).#YourParamName

Enrico

score 0 · Answer 2 · 2023-01-13T05:12:04-05:00

Benjamin De Boe · Jan 13, 2023

Or try $parameter("classname", "paramname")

0 0

score 0 · Answer 3 · 2023-01-13T16:14:09-05:00

I tried this and it worked:

Parameter TestParam = "Test";

Property TestCalc As %String [ SqlComputeCode = { Set {*} = ..#TestParam}, SqlComputed ];

[SQL]SAMPLES>>select * from DC.SQLCompute
1.      select * from DC.SQLCompute

ID      TestCalc
1       Test

score 0 · Answer 4 · 2023-01-14T13:44:45-05:00

Often SqlComputed is used for properties that are also calculated like:

Property TestCalc As %String [ Calculated, SqlComputeCode = { Set {*} = ..#TestParam }, SqlComputed ];

but in that case ..#ParamName does not work, this works:

Property TestCalc As %String [ Calculated, SqlComputeCode = { Set {*} = ##class(test.CalcParm).#TestParam }, SqlComputed ];

Enrico