Enable/Disable Trigger in Sybase

sybase-asa
Mauro picture Mauro · Jun 27, 2011 · Viewed 9.9k times · Source

What's wrong with that query?

alter table TableName enable trigger 'TriggerName'

Error is

Line 1, column 30
Could not execute statement.
ASA Error -131: Syntax error nera 'enable' on line 1

Answer

martin clayton picture martin clayton · Jun 27, 2011

The error message is from Sybase SQL Anywhere (ASA), but the syntax you're trying to use is not valid in ASA, it would be in Adaptive Server (ASE) though. I don't think there is an equivalent in ASA.

Related questions

How to output data from iSQL to csv file _with_ headings?

I'm trying to query a Sybase ASA 8 database with the iSQL client and export the query results to a text file in CSV format. However the column headings are not exported to the file. There is no special option to …

Read More
Get records from last hour

I have this query: SELECT Field1, OrderFor, Writeback, Actshipdate, Orderstatus, receivedate, receivetime FROM orderinfo, shippinginfo WHERE orderinfo.orderid = shippinginfo.orderid AND shippinginfo.custid = '37782' AND receivedate = DATE(NOW()) AND receivetime = ??????? I am using Sybase adaptive server anywhere and trying …

Read More
Sybase IQ - how to show stored procedure without wrapping text?

Using Sybase IQ v12.7. Executing sp_helptext ProcedureName shows the text of the stored procedure which is fine. However it wraps lines at 80 characters. The question is, how to show text text of a stored procedure without wrapping? In Sybase …

Read More