Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

asked 02 Jan '16, 10:29

pmiller's gravatar image

pmiller
206162024
accept rate: 37%

edited 04 Jan '16, 10:20


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%20Barth's gravatar image

Volker Barth
40.5k365556827
accept rate: 34%

edited 03 Jan '16, 09:08

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
permanent link

answered 02 Jan '16, 10:59

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050
accept rate: 20%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×261
×106
×24

question asked: 02 Jan '16, 10:29

question was seen: 2,040 times

last updated: 04 Jan '16, 10:20