cancel
Showing results for 
Search instead for 
Did you mean: 

SYBASE Update statics fail

Former Member
0 Kudos

Hi,

I try to run update statics in my DB system.

I did that with note 1757691 - SYB: How to manually update index statistics of a table using isql.

But after successfully run the programe its show bellow error. The sql also attached. Please help.

Msg 102, Level 15, State 181:

Server 'DEV', Line 2:

Incorrect syntax near 'go'.

Msg 102, Level 15, State 181:

Server 'DEV', Line 5:

Incorrect syntax near 'go'.

Msg 102, Level 15, State 181:

Server 'DEV', Line 9:

Incorrect syntax near 'go'.

Msg 102, Level 15, State 181:

Server 'DEV', Line 24:

Incorrect syntax near 'go'.

Msg 102, Level 15, State 181:

Server 'DEV', Line 26:

Incorrect syntax near 'go'.

Msg 102, Level 15, State 181:

Server 'DEV', Line 33:

Incorrect syntax near 'go'.

Msg 134, Level 15, State 1:

Server 'DEV', Line 35:

The variable name '@cmd' has already been declared.  Variable names must be

unique within a query batch or stored procedure.

Msg 102, Level 15, State 181:

Server 'DEV', Line 48:

Incorrect syntax near 'go'.

[10] %

Accepted Solutions (0)

Answers (1)

Answers (1)

Sriram2009
Active Contributor
0 Kudos

Hi

You can use the transaction code DBACOCKPIT and then update the statistics, Kindly refer the SAP link

http://help.sap.com/saphelp_nw73/helpdata/en/59/875ca7afbc4aea951b03070f41e776/content.htm

Regards

Sriram

Former Member
0 Kudos

Hi Sriram,

Thanks for your reply. Can you please guide me how to schedule update statics from dbacockpit ?? I am new in SYBASE.