On Wed, 17 Oct 2007, Helen Borrie wrote:

> At 10:38 AM 17/10/2007, you wrote:
> >Here is the output from ISQL for a couple of functions:
> >
> >SQL> show functions "LOWER";
> >
> >Function LOWER:
> >Function library is ib_udf
> >Entry point is IB_UDF_lower
> >Returns FREE_IT CSTRING(255) CHARACTER SET NONE
> >Argument 1: NULL CSTRING(255) CHARACTER SET NONE
> >SQL> show functions ASCII_CHAR;
> >
> >Function ASCII_CHAR:
> >Function library is ib_udf
> >Entry point is IB_UDF_ascii_char
> >Returns FREE_IT CSTRING(1) CHARACTER SET NONE
> >Argument 1: NULL INTEGER
> >
> >Note that LOWER is not shown with quotes. ASCII_CHAR does seem to be
> > correct, in that Argument 1 includes the NULL.
>
> So does LOWER, apparently...
>
> ./hb
>

But shouldn't LOWER be "LOWER"?

Anyway, I need to extract the metadata for the complete database, so would you
expect a tool like IBOConsole to do this correctly?

Regards
Tom