SAP Knowledge Base Article - Preview

2716728 - Incorrectly states about the changed behavior for the BYTE_SUBSTR, INSERTSTR and STUFF Functions - SAP IQ 16.1 What's New doc

Symptom

The SAP IQ What's New in SAP IQ 16.1 document incorrectly states about the changed behavior of the below functions.

What's New in SAP IQ 16.1 SP 03 > Support Package 01 > Reference > Stored Procedures and Functions (New and Changed)

BYTE_SUBSTR

(Changed) Returns only BINARY or LONG BINARY. Previously, this function returned BINARY, LONG BINARY, VARCHAR, LONG VARCHAR, NVARCHAR, or LONG NVARCHAR, depending on the type of the input string expression.

See BYTE_SUBSTR function in SAP IQ SQL Reference.

INSERTSTR

(Changed) If all of the input expressions are BINARY, then this function returns LONG BINARY. Previously, the INSERTSTR function returned LONG NVARCHAR or LONG VARCHAR, even if the input expressions were BINARY.

See INSERTSTR function in SAP IQ SQL Reference.

STUFF

(Changed) If all of the input expressions are BINARY, this function returns LONG BINARY. Previously, this function returned LONG NVARCHAR or LONG VARCHAR, even if the input expressions were BINARY.

See STUFF Function [String] in SAP IQ SQL Reference.


Read more...

Environment

  • SAP IQ 16.1 SP01
  • SAP IQ 16.1 SP02
  • SAP IQ 16.1 SP03

Product

SAP IQ 16.1

Keywords

CR817345, CR#817345, 817345, Doc, Doc bug, Document bug,   , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.