Undocumented options of dbinfo

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!