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 for Me (Login required).

Search for additional results

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