SAP Knowledge Base Article - Preview

2513776 - Error 156 when update index statstics on table named 'start' having 'with clause' - SAP ASE 16 SP03

Symptom

  • You are running update index statistics on ASE 16 SP03 release
  • "start" is not a reserved word.  Create a table named "start", getting error 156 on the table "start" when updating index statistics using "with clause".
       
    1> create table start (a int)
    2> go
    1> update index statistics start with sampling = 25 percent
    2> go
    Msg 156, Level 15, State 2:
    Server 'sp03', Line 1:
    Incorrect syntax near the keyword 'start with'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR810074, CR#810074, 810074, update index statistics, start with, with sampling, partial_hashing, print_progress , KBA , 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.