Chapter 5. Unimplemented SQL99 Commands

The SQL92 and SQL99 standards specify many commands. However, RMBDS vendors are not able to implement all of them immediately. In fact, many commands specified in the new SQL99 standard are nowhere near being implemented by any of the database vendors covered in SQL in a Nutshell. In effect, these commands exist because the standard says they exist, but they cannot currently be executed anywhere. As a result, these commands are described only briefly in Table 5.1.

Nonetheless, it should be noted that although these commands are not implemented yet, they could be eventually. Consequently, it is important to check vendor documentation to see if the newest version has implemented any of these commands.

Table 5-1. Unimplemented SQL99 Commands




The ALLOCATE CURSOR statement is used in Dynamic SQL to link a SELECT statement initialized with the PREPARE statement. This statement differs from DECLARE CURSOR in that ALLOCATE CURSOR creates multiple precompiled cursor statements while DECLARE CURSOR is created and compiled dynamically each time it is run.


This statement prepares a dynamic area that stores information about the parameters in a dynamically generated SQL statement. In effect, this command allows the amount of space set aside for dynamic SQL statements to be controlled precisely.


A domain is generally a user-defined datatype. According to the SQL99 standard, ...

Get SQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.