PHP MySql Web Hosting

,ch05.13852 Page 194 Wednesday, November 29, 2000 4:43 PM 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 Commands ALLOCATE CURSOR ALLOCATE DESCRIPTOR Description 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. 194 Chapter 5 Unimplemented SQL99 Commands

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost PHP MySQL Web Hosting services