CODEWITHSUNDEEP
sqlintersystems-cacheintersystems
O.O
O.O

Reputation: 11317

How to read a class parameter using Caché SQL?

How do I read a class parameter using Caché SQL?

select * from table does not list any class parameters.

Upvotes: 2

Views: 593

Answers (1)

Brandon Horst
Brandon Horst

Reputation: 2070

Parameters are specific to the class definition, not specific to the object or row. Therefore, you cannot find them by querying the class table. Rather, you need to query the Class Definition tables. These reside in the %Dictionary classes.

For this particular query, you can use

SELECT * FROM %Dictionary.ParameterDefinition WHERE parent='Sample.Person'

In the SAMPLES namespace, this should yield results for all Parameters that are a part of Sample.Person - in this case, only EXTENTQUERYSPEC.

Upvotes: 4

Related Questions