Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Are tiny floating point values such as '1.28295666201E-5' and '9.46536915082E-5' meaningful for CONNECTION_PROPERTY ( 'ReqTimeBlockContention' )?

Or should such values be interpreted as zero?

Which other (if any) SQL Anywhere property values are returned as floating point string literals?

asked 23 May '20, 09:55

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050
accept rate: 20%

edited 23 May '20, 09:55

Or should such values be interpreted as zero?

So I assume you assume "yes" :)

(26 May '20, 09:51) Volker Barth
Replies hidden

Yeah, pretty much :)

(26 May '20, 11:31) Breck Carter

At a quick glance, it looks like any property that begins "ReqTime..." is a double, and any property that begins "ReqCount..." is an int. Look at sa_performance_diagnostics system procedure http://dcx.sap.com/index.html#sqla170/en/html/8176b8c76ce210149d3bb4fd6b8f4d21.html

As for other properties, that would require a bit more research.

permanent link

answered 25 May '20, 12:57

JBSchueler's gravatar image

JBSchueler
3.3k41665
accept rate: 20%

edited 25 May '20, 13:03

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:

×11

question asked: 23 May '20, 09:55

question was seen: 857 times

last updated: 26 May '20, 14:23