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

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 ONE Support launchpad (Login required).

Search for additional results

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