SAP Knowledge Base Article - Preview

3351573 - Reorg command returns Msg 102 "Incorrect syntax near..." when running from isql - SAP ASE for Business Suite and Business Warehouse

Symptom

  • You want to execute manually a reorg on a table with "/" character in name, and error Msg 102 is returned, ie:

            1> reorg reclaim_space '/BI0/XXXX'
            2> go
            Msg 102, Level 15, State 181:
            Server 'SLQ', Line 2:
            Incorrect syntax near 'reclaim_space'.

  • Note that reorgs are executed/scheduled from DBACockpit by ATM and can also be scheduled specifically for a table running from menu Space > Tables and Indexes > Single Table Analysis > Enter the table_name and click on "Apply Selection", you'll see the button "Reorganization" on top menu.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.