Having used CREATE OR REPLACE with PROCEDURE, TABLE, TRIGGER and VIEW many times, today i tried to execute CREATE OR REPLACE EVENT, only to find it isn't implemented.

I'd like to see that feature being added to SQL Anywhere, it seems quite a logical step to me.

asked 25 Jul '12, 10:42

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334583
accept rate: 11%

1

I agree this would be great.

(25 Jul '12, 12:14) Siger Matt

A reasonable request. Until it is implemented you could use

DROP EVENT IF EXISTS [owner].eventname;

before the CREATE EVENT [owner].eventname ... code.

permanent link

answered 25 Jul '12, 10:47

Mark%20Culp's gravatar image

Mark Culp
23.2k9132272
accept rate: 40%

1

Thanks, Mark, that's what I'm using now. The enhanced CREATE syntax would be helpfull for a consistent usage: we often generate scripts from sources stored in an version control system. With CREATE OR REPLACE the developers won't have to remember adding the DROP statment.

(25 Jul '12, 11:04) Reimer Pods
Replies hidden
1

CREATE OR REPLACE EVENT was implemented in SQLA v17 ... but I see that the documentation did not get updated :-( I have sent a note to the doc team. http://dcx.sap.com/index.html#sa160/en/dbreference/create-event-statement.html

Oops, my mistake, I was looking at the v16 docs - the v17 docs are correct: http://dcx.sap.com/index.html#sqla170/en/html/816bb10e6ce21014b9c1ffdd3e67b36f.html*loio816bb10e6ce21014b9c1ffdd3e67b36f

(22 Jul '15, 08:54) Mark Culp
1

Well, it is - at least under the "What's New" pages:

alt text

(22 Jul '15, 10:04) Volker Barth

[NO-MOCKERY-ALLOWED] You can avoid opening the wrong docs by using the V17 CHM file instead... which requires you to uninstall the V16 CHM first... gotta love those persistent InstallShield Product Code values. [snork] [/NO-MOCKERY-ALLOWED]

(22 Jul '15, 11:49) Breck Carter

Thanks for implementing this enhancement and shareing the knowledge.

(23 Jul '15, 03:30) Reimer Pods

FWIW, I was able to install the v17 HTML help (taken form here) without messing up the v16 doc install. They do run side by side as expected.

(23 Jul '15, 07:02) Volker Barth
showing 2 of 6 show all flat view
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×107
×35

question asked: 25 Jul '12, 10:42

question was seen: 1,280 times

last updated: 23 Jul '15, 07:02