SAP Knowledge Base Article - Preview

2126553 - Under UTF8, sp_spaceusage raises error 19537 "Invalid syntax or illegal use of the USING clause" - ASE

Symptom

  • Execution of sp_spaceusage:

sp_spaceusage 'archive using dbname = mydb', 'table','dbo.%', 'where ID>100 and TableName NOT LIKE "rs_%"

  • Procedure execution fails with Error 19537, citing sp_spaceusage_paramcheck:

Msg 19537, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_spaceusage_paramcheck', Line 341:
Invalid syntax or illegal use of the USING clause. 

  • ASE default character set is UTF8
     
  • ASE default sort order is the general purpose case insensitive sort order:

server 'nocase' (ID = 52)
server on top of default character set:
server 'utf8' (ID = 190).


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , sqlloc , charindex , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.