more than one value from SELECT PROPERTY - SA 16

[Former Member]

Hi again,

is it possible to select more than one value (like this:)

SELECT PROPERTY ( 'value1','value2' );

Source http://dcx.sap.com/index.html#1201/en/dbadmin/server-properties-perfapp.html

[VolkerBarth · Accepted solution]

As Breck has stated, PROPERTY() is a function, so if you want to call it with several arguments, you simply have to call it once for each argument, such as

SELECT PROPERTY ('NumPhysicalProcessors'), PROPERTY('NumPhysicalProcessorsUsed');

and if you really need only one resulting value, you can concat the values as you like, say

SELECT PROPERTY ('NumPhysicalProcessors') || '/' || PROPERTY('NumPhysicalProcessorsUsed') AS myResult;