,ch05.13852 Page 196 Wednesday, November 29, 2000 4:43
,ch05.13852 Page 196 Wednesday, November 29, 2000 4:43 PM Table 5-1: Unimplemented SQL99 Commands (continued) Commands PREPARE SET CATALOG SET CONSTRAINTS MODE SET DESCRIPTOR SET NAMES SET SESSION AUTHORIZATION SET SESSION CHARACTERISTICS Description The PREPARE statement creates a Dynamic SQL from a text variable so that it can be executed many times using the EXECUTE command. This command defines the current catalog, which holds the current schema, used by the current session. This statement determines whether constraints are checked immediately upon completion of a transaction or deferred until the end of the transaction. Constraints also might be checked immediately, meaning after each statement. Many vendors offer alternative methods for achieving this sort of functionality. For example, Oracle offers this functionality through the command ALTER SESSION SET CONSTRAINTS. Research the vendor documentation for other possible alternatives. The SET DESCRIPTOR statement places values into previously allocated cursors or alters the behavior of a descriptor. This command sets the default character set for a session. The SET SESSION AUTHORIZATION statement alters the authorization under which statements are processed. The SET SESSION CHARACTERISTICS statement allows the same properties to be set for all of the transactions processed in an entire session, just like using other SET statements for a single transaction. 196 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 Web Hosting services