Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

Chapter 10 177
Technical Articles
New Features in ALLBASE/SQL Version G3
• ALLBASE/SQL Database Administration Guide
• ALLBASE/SQL Message Manual
Security
Two new authorities have been added to the G2 release of
ALLBASE/SQL: MONITOR and INSTALL. These new authorities can be
granted to users using the GRANT command, or can be revoked from
users using the REVOKE command.
MONITOR Authority
MONITOR authority gives a user the ability to run SQLMON, an on-line
diagnostic tool that monitors the activity of an ALLBASE/SQL
DBEnvironment. Before this new authority, SQLMON could only be run
by the creator of the DBEnvironment (also known as the DBECreator),
someone who knows the maintenance word (maintword), or someone
who has superuser capability. See the ALLBASE/SQL Reference
Manual for more details.
INSTALL Authority
INSTALL authority gives a user the ability to use the SQL
preprocessors to create an SQL module owned by someone other than
themselves, or to use ISQL to install a module owned by someone other
than themselves. This is an important capability for those needing to
move modules from a development DBEnvironment to a production
DBEnvironment. Before this new authority, only a DBA had this ability.
See the ALLBASE/SQL Reference Manual for more details.
Year 2000 Compatibility
As the end of the century quickly approaches, there has been much
concern about dates being handled correctly in the twenty-first century.
This is particularly an issue for systems and applications that are using
a two-digit year to express dates. ALLBASE/SQL has always stored
dates in a four-digit year format which largely eliminates the year 2000
compatibility problem. ALLBASE/SQL applications can be coded using
four-digit year dates, thus avoiding any ambiguity. However, for
existing applications that may allow dates to be entered using a
two-digit year format, there is still an issue as to how these dates get
converted to the ALLBASE/SQL internal format using the TO_DATE
function or TO_DATETIME. For example, what date value would the
following functions return?
TO_DATE('12/31/35','MM/DD/YY')
TO_DATETIME('351231235959','YYMMDDHHMISS')
Would these functions evaluate the year as 1935 or 2035?