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

When V17 was introduced, the default for the new parameterization_level was "Simple".

The default has since been changed to 'Off'... why is that?

Is parameterization_level is unsafe to use? :)

asked 28 Jul '19, 11:49

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

The change in the default value was a side effect of a change made for IQ. It was not because it was unsafe.

There was one defect with parameteritization_Level that was not in the release notes - it will be documented in the future SP. That issue:

================(Build #4919  - Engineering Case #817663)================

If statement was automatically parameterized (parameterization_level Simple 
or Forced) and a parameter value was larger than 250 bytes, it is possible 
that a SQLE_COMMUNICATION_ERROR would be incorrectly reported.  A workaround 
is to set parameterization_level to Off.  This has been fixed.
permanent link

answered 29 Jul '19, 06:41

Chris%20Keating's gravatar image

Chris Keating
accept rate: 32%

Thank you for the information it was very useful..

(01 Aug '19, 06:27) Asmitasant10
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 28 Jul '19, 11:49

question was seen: 888 times

last updated: 01 Aug '19, 06:27