Undocumented options of dbinfo
Reinhard Habichtsberg asked about undocumented dbinfo options such as utc_current, utc_to_datetime and get_tz. Richard Harnden ran strings on oninit and listed the dbinfo arguments found, including sessionid, dbhostname and the version options, and quoted error -728's list. Scottishpoet warned IBM may change undocumented behaviour without notice; Rob Konikoff joked about it.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
While searching for away to determine the start time of a session I found
some undocumented options of dbinfo in this list:
dbinfo( 'utc_current')
dbinfo('utc_to_datetime', <some_utc_int>)
dbinfo( 'get_tz')
(thanx to Michael Mueller, thread: Access to UTC time with servers running
in local time, 2003-08-26).
Nothing found of this in the complete ;-) documentation of IDS 10.
Do exist any other usefull but hidden options of dbinfo and where could be
found a list?
Reinhard.
Habichtsberg, Reinhard wrote:
> While searching for away to determine the start time of a session I found
> some undocumented options of dbinfo in this list:
>
> dbinfo( 'utc_current')
> dbinfo('utc_to_datetime', <some_utc_int>)
> dbinfo( 'get_tz')
> (thanx to Michael Mueller, thread: Access to UTC time with servers running
> in local time, 2003-08-26).>
> Nothing found of this in the complete ;-) documentation of IDS 10.
>
> Do exist any other usefull but hidden options of dbinfo and where could be
> found a list?
>
> Reinhard.
>
# strings $INFORMIXDIR/bin/oninit | grep DBINFO
DBINFO ('dbspace',
DBINFO ('sqlca.sqlerrd1')
DBINFO ('sqlca.sqlerrd2')
DBINFO ('utc_to_datetime',
DBINFO ('utc_current')
DBINFO ('get_tz')
DBINFO ('sessionid')
DBINFO ('dbhostname')
DBINFO ('version', 'server-type')
DBINFO ('version', 'major')
DBINFO ('version', 'minor')
DBINFO ('version', 'os')
DBINFO ('version', 'level')
DBINFO ('version', 'full')
and
# finderr 728
-728 Unknown first argument of dbinfo(<argument>).
Check that the first argument to dbinfo() is a quoted string that
corresponds
to one of the following values: 'dbspace', 'version', 'sqlca.sqlerrd1',
'sqlca.sqlerrd2', 'sessionid', 'coserverid', 'utc_to_datetime',
'utc_current', 'get_tz', or 'dbhostname'.
-728 Unknown first argument of dbinfo argument-name.
The valid arguments to the dbinfo() function are the quoted string
'dbspace' followed by the number of a valid tablespace, or one of the
following two values: 'sqlca.sqlerrd1' or 'sqlca.sqlerrd2'. Check that
you supplied one of these values and enclosed the string in quotes.
--
rh
use undocumented info at your own risk IBM will reserve the right to change or remove the behaviour without any notification that they have done so.
> use undocumented info at your own risk > IBM will reserve the right to change or remove the behaviour without any notification that they have done so. It's not a bug... it's an undocumented feature!