generic Questions

Here are 4 questions about DBMS, some of these questions are perhaps not relevant with Informix. 1/ What is the maximum number of columns allowed in the following SQL cases : - in an index. - in an ORDER BY clause. - in a select list. - in a TABLE. 2/ I would like to know how the 'qualifiers' works in informix Could you tell me : - the position of the qualifier in a qualified table name : END or START. - the character or the characters that the data source defines as the separator between a qualifier name and the qualified name taht follows it. - the qualifier term : A character string with the data source vendorUs name for a qualifier; for example, RdatabaseS or RdirectoryS. - the qualifier usage : 1 - Qualifiers are supported in all Data Manipulation Language statements: SELECT, INSERT, UPDATE, DELETE, and, if supported, SELECT FOR UPDATE and positioned update and delete statements. 2 - Qualifiers are supported in the ODBC procedure invocation statement. 3 - Qualifiers are supported in all table definition statements: CREATE TABLE, CREATE VIEW, ALTER TABLE, DROP TABLE, and DROP VIEW. 4 - Qualifiers are supported in all index definition statements: CREATE INDEX and DROP INDEX. 5 - Qualifiers are supported in all privilege definition statements: GRANT and REVOKE. 3/ I would like to know which predicats subqueries support. 4/ I would like to know how quoted identifiers reacts in the following DBMS : 1- Quoted identifiers in SQL are case insensitive and are stored in upper case in system catalog. 2- Quoted identifiers in SQL are case insensitive and are stored in lower case in system catalog. 3- Quoted identifiers in SQL are case sensitive and are stored in mixed case in system catalog. 4- Quoted identifiers in SQL are case insensitive and are stored in mixed case in system catalog. Fred, +------------------------------------+--------------------------+ | Frederic BOUQUET | Phone : (33) 77 93 57 46 | | Cornut Informatique | Fax : (33) 77 92 51 39 | | 24, rue de la Telematique - BP 702 | AppleLink : CORNUT.INF | | 42950 St Etienne cedex 9 FRANCE | Compuserve: 100303,1061 | | frederic_bouquet@ascus.com | | +------------------------------------+--------------------------+ -------------------------------------------------------------------------- U.S.A. | AppleLink : ASCUS About Software Corporation | eWorld : ASC.US 10601, South De Anza Blvd. |America Online : ASCUS Suite 105 | Compuserve : 73243,36 Cupertino, CA 95014 | Internet : info@ascus.com general phone : (408) 725 4242 | Anonymous FTP : ftp.ascus.com sales : (800) 55 SOFTWARE | ARA Server : (408) 725 4250 tech support : (408) 725 4240 |FirstClass BBS : (408) 725 4252 fax : (408) 725 4243 | bbs.ascus.com -------------------------------------------------------------------------- FRANCE | AppleLink : ADV.SOFT ASC | Compuserve : 76034,2123 9551, route de St Laurent du Var | Internet : euro_info@ascus.com F-06610 La Gaude | Anonymous FTP : ftp.ascus.com general phone : +33 93 24 76 00 | ARA Server : +33 93 24 76 03 fax : +33 93 24 76 06 |FirstClass BBS : +33 93 24 76 13 --------------------------------------------------------------------------