Sybase: enabling LIMIT

54 Views Asked by At

Which one of these three statements is the best one to enable the keyword LIMIT?

SET OPTION RESERVED_KEYWORDS = 'LIMIT';
SET OPTION PUBLIC reserved_keywords = 'LIMIT';
SET OPTION PUBLIC.reserved_keywords = 'LIMIT';
1

There are 1 best solutions below

0
sid_com On

SET OPTION RESERVED_KEYWORDS = 'LIMIT'; is in the IQ SQL documentation.

SET OPTION PUBLIC.reserved_keywords = 'LIMIT'; is in the SQL Anywhere documentation

Adaptive Server Enterprise: Limit/Offset since version ASE 16 SP02 PL05.