PHP MySql Web Hosting

,ch05.13852 Page 195 Wednesday, November 29, 2000 4:43 PM Table 5-1: Unimplemented SQL99 Commands (continued) Commands ALTER DOMAIN CREATE ASSERTION CREATE CHARACTER SET CREATE COLLATION CREATE TRANSLATION DEALLOCATE DESCRIPTOR DEALLOCATE PREPARE DESCRIBE DROP ASSERTION DROP CHARACTER SET DROP COLLATION DROP TRANSLATION GET DESCRIPTOR GET DIAGNOSTICS Description A domain is generally a user-defined datatype. According to the SQL99 standard, the ALTER DOMAIN command allows the definition of a domain to be changed by adding or dropping a default or constraint. Typically, only the owner of the schema that contains the domain may alter it. Any changes specified with the command instantly affect all columns based on the domain. An assertion is a generic CHECK constraint that may be applied over and over again. Thus, a check constraint that controls the emp_id column can be applied as an assertion in every table that holds emp_id. This command is not supported by the database vendors covered in this book; however, Microsoft SQL Server supports the CREATE RULE statement, which is functionally equivalent. This statement creates individualized character sets for improved internationalization of a database platform. However, most vendors ship their products with a wide range of character sets. Although some make it possible to create or change character sets, they do not support this command. A collating sequence determines the order in which text strings are sorted. Like character sets, the database platform normally ships with one or more collations. This command creates new sorting sequences for a given character set. A translation is a descriptor that translates strings from one character set to another. Character strings then can be translated using the TRANSLATE command. New translations based upon old ones can be built using this command. This statement removes a previously declared descriptor created using ALLOCATE DESCRIPTOR. This statement destroys a previously prepared SQL statement created using the PREPARE statement. This command stores parameterized information about a SQL statement held in the named descriptor area created using the ALLOCATE DESCRIPTOR statement. Note: Oracle possesses a DESCRIBE command that is used to report information on a table, describing its columns, datatypes, and so on. This statement removes an assertion from the database that was previously created using the CREATE ASSERTION statement. This command removes a character set from the database that was previously created using the CREATE CHARACTER SET statement. This statement removes a collation from the database that was previously created using the CREATE COLLATION statement. This command removes a translation from the database that was previously created using the CREATE TRANSLATION statement. The GET DESCRIPTOR statement retrieves information from the descriptor areas, primarily about input and output parameters used in Dynamical SQL statements. The GET DIAGNOSTICS command provides information (taken from the diagnostics area) about the last SQL statement executed or about a specific error message encountered while processing a SQL statement. NewCommands Unimplemented SQL99 Commands 195

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