Example 1: Setting the view characteristics from SQLV40 to SQL99

    SQL> ATTACH 'ALIAS ENV1 FILENAME ENVIRONMENT';
    SQL> CONNECT TO 'ALIAS ENV1 FILENAME ENVIRONMENT' AS 'TEST';
    SQL> SHOW CONNECTIONS TEST
    Connection: TEST
    Default alias is RDB$DBHANDLE
    Default catalog name is RDB$CATALOG
    Default schema name is SMITH
    Dialect: SQLV40
    Default character unit: OCTETS
    Keyword Rules: SQLV40
    View Rules: SQLV40
    Default DATE type: DATE VMS
    Quoting Rules: SQLV40
    Optimization Level: DEFAULT
    Hold Cursors default: WITH HOLD PRESERVE NONE
    Quiet commit mode: OFF
    Compound transactions mode: EXTERNAL
    Default character set is DEC_MCS
    National character set is DEC_MCS
    Identifier character set is DEC_MCS
    Literal character set is DEC_MCS
    Display character set is UNSPECIFIED

    Alias ENV1:
            Identifier character set is DEC_MCS
            Default character set is DEC_MCS
            National character set is KANJI
    SQL> --
    SQL> -- Change the environment for view rules from SQLV40 to SQL99
    SQL> --
    SQL> SET VIEW UPDATE RULES 'SQL99';
    SQL> SHOW CONNECTIONS TEST
    Connection: TEST
    Default alias is RDB$DBHANDLE
    Default catalog name is RDB$CATALOG
    Default schema name is SMITH
    Dialect: SQLV40
    Default character unit: OCTETS
    Keyword Rules: SQLV40
    View Rules: ANSI/ISO
    Default DATE type: DATE VMS
    Quoting Rules: SQLV40
    Optimization Level: DEFAULT
    Hold Cursors default: WITH HOLD PRESERVE NONE
    Quiet commit mode: OFF
    Compound transactions mode: EXTERNAL
    Default character set is DEC_MCS
    National character set is DEC_MCS
    Identifier character set is DEC_MCS
    Literal character set is DEC_MCS
    Display character set is UNSPECIFIED

    Alias ENV1:
            Identifier character set is DEC_MCS
            Default character set is DEC_MCS
            National character set is KANJI