SAP SQL Anywhere

Question

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

Accepted Answer

2

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;

permanent link

answered 03 Jan '16, 09:05

Volker Barth
39.5k●355●539●811
accept rate: 34%

edited 03 Jan '16, 09:08

flat view

Answer 2

PROPERTY only returns one value because it is a function and that's what functions do.

The sa_eng_properties() procedure returns a result set which can be manipulated in a variety of ways depending on how you like your multiple values presented...

SELECT sa_eng_properties.PropName,
       sa_eng_properties.Value
  FROM sa_eng_properties()
 WHERE sa_eng_properties.PropName IN ( 'NumPhysicalProcessors', 'NumPhysicalProcessorsUsed' )
 ORDER BY sa_eng_properties.PropName;

PropName,Value
'NumPhysicalProcessors',1
'NumPhysicalProcessorsUsed',1

SELECT LIST ( sa_eng_properties.Value, 
              ', ' 
              ORDER BY sa_eng_properties.PropName ) AS "List of Properties" 
  FROM sa_eng_properties()
 WHERE sa_eng_properties.PropName IN ( 'NumPhysicalProcessors', 'NumPhysicalProcessorsUsed' );

List of Properties
1, 1

SAP SQL Anywhere

more than one value from SELECT PROPERTY - SA 16

Follow this question

Related questions