1
vote
0answers
17 views
Why doesn’t “CREATE OR REPLACE” just ALTER existing objects?
Hi all,
I like the new CREATE OR REPLACE clause for views, procedures and the like introduced with SA 11.0.1. My thought was that in case of an already existing object, the behavi …
0
votes
2answers
60 views
When NOT is necessary…
It appears that iAnywhere 9.0.2 has some issues using NOT.
Here is the statement that’s working for me now:
SELECT DISTINCT contact.contact_id FROM contact WHERE ( ('
' + categ …
2
votes
1answer
68 views
Is “KEY JOIN” going to be a standard SQL feature?
Besides the known pros and cons of KEY JOIN, I like this clause because it saves me coding (and reading) time by using semantics I have already put into my table's FK definitions.
…
