![]() This is the opclassid from the entry for this operator class in the sysopclasses system catalog table. ![]() ' S' = sbspace (smart-large-object space)ĭefault-operator class identifier. ![]() Type of space in which the access method can live: Value corresponds to the am_id in the systables system catalog table and to the am_id in the sysindices and sysopclasses system catalog tables. The sysams table shows the following columns. The sysams system catalog table shows information needed to use built-in access methods as well as those created by the Create Access Method SQL statement described in the Virtual-Table Interface Programmer's Manual. For information about NCHAR and CHAR data types, see Chapter 3 of the Guide to GLS Functionality and Chapter 2 of this guide. For more information on collation orders, see Chapter 1 of the Guide to GLS Functionality. If your locale has localized collation, these character columns are NCHAR. This manual assumes that the locale has code-set collation and lists character columns with the CHAR data type. However, for those databases where the collation order is code-set dependent (including the default locale), all character information in the system catalog tables is stored in CHAR columns. ![]() In a database whose collation order is locale dependent, all character information in the system catalog tables is stored in NCHAR rather than CHAR columns. For more information about the sysmaster tables, see the INFORMIX-Universal Server Administrator's Guide. The information in the sysmaster tables is primarily useful for Universal Server DBAs. The system catalog tables give information regarding a particular database on any Informix database server, while the sysmaster tables contain information about an entire Informix database server, which might manage many individual databases. The following system catalog tables describe the structure a database on an Informix database server.ĭo not confuse the system catalog tables of a database with the tables in the sysmaster database of Universal Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |