SAP Knowledge Base Article - Preview

1965517 - [SAP IQ] Error : "Large Objects Management functionality is not licensed on this server"

Symptom

When the query includes some functions like below  in "select.... into... from", error such as "Large Objects Management functionality is not licensed on this server" must have.

  • AES_ENCRYPT()
  • CONVERT()
  • GRAPHICAL_PLAN()
  • HTML_DECODE() 
  • HTML_ENCODE() 
  • HTTP_HEADER()
  • INSERTSTR()
  • LCASE()
  • LEFT()
  • LIST()
  • LOWER()
  • LTRIM()
  • NEXT_HTTP_VARIABLE()
  • REPEAT()
  • REPLACE()
  • REVERSE()
  • RIGHT()
  • RTRIM()
  • SPACE()
  • SQLFLAGGER()
  • STRING()
  • SUBSTRING()
  • SUSER_NAME()
  • TRIM()
  • UCASE()
  • UPPER()
  • USER_NAME()

Example)  select repeat('X',13) into #test from iq_dummy


Read more...

Environment

  • IQ15.x all version
  • IQ16
  • IQ16.0  SP01, SP02, SP03

Product

SAP IQ all versions

Keywords

CAST , REPEAT , , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.