On 11.05.10 01:38, Mamta Satoor wrote:
Hi,
With DERBY-3809, it is nice that one can now list the functions just
like procedures through SHOW PROCEDURES.
While buddy testing, I noticed that (this is also pointed out by
Sylvain Leroux in DERBY-3809) is that the last column, REMARKS, is too
narrow. I thought using ij's maximumdisplaywidth would help with that
but the REMARKS column's display didn't change with
maximumdisplaywidth setting. May be this is expected but I thought I
would share it. Thanks.
Hi Mamta,
I experienced the same issue when using DESCRIBE - I just couldn't get
ij to display the the full, or at least more of the values.
Regards,
--
Kristian
eg ij session
$ java org.apache.derby.tools.ij
ij version 10.6
ij> connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true';
WARNING 01J01: Database 'c:/dellater/buddytest10_6_1' not created, connection ma
de to existing database instead.
ij> show functions;
FUNCTION_SCHEM|FUNCTION_NAME |REMARKS
-------------------------------------------------------------------------------
APP |PADSTRING |org.apache.derbyTesting.functionTe&
SYSCS_UTIL |SYSCS_CHECK_TABLE |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_DATABASE_PROPERTY |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_RUNTIMESTATISTICS |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_USER_ACCESS |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_XPLAIN_MODE |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_XPLAIN_SCHEMA |org.apache.derby.catalog.SystemPro&
SYSIBM |BLOBCREATELOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETBYTES |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETLENGTH |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETPOSITIONFROMBYTES |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETPOSITIONFROMLOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBCREATELOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETLENGTH |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETPOSITIONFROMLOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETPOSITIONFROMSTRING |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETSUBSTRING |org.apache.derby.impl.jdbc.LOBStor&
17 rows selected
ij> maximumdisplaywidth 4500;
ij> show functions;
FUNCTION_SCHEM|FUNCTION_NAME |REMARKS
-------------------------------------------------------------------------------
APP |PADSTRING |org.apache.derbyTesting.functionTe&
SYSCS_UTIL |SYSCS_CHECK_TABLE |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_DATABASE_PROPERTY |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_RUNTIMESTATISTICS |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_USER_ACCESS |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_XPLAIN_MODE |org.apache.derby.catalog.SystemPro&
SYSCS_UTIL |SYSCS_GET_XPLAIN_SCHEMA |org.apache.derby.catalog.SystemPro&
SYSIBM |BLOBCREATELOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETBYTES |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETLENGTH |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETPOSITIONFROMBYTES |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |BLOBGETPOSITIONFROMLOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBCREATELOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETLENGTH |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETPOSITIONFROMLOCATOR |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETPOSITIONFROMSTRING |org.apache.derby.impl.jdbc.LOBStor&
SYSIBM |CLOBGETSUBSTRING |org.apache.derby.impl.jdbc.LOBStor&
17 rows selected
ij> exit;
