[
https://issues.apache.org/jira/browse/DERBY-28?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden resolved DERBY-28.
---------------------------------
Resolution: Cannot Reproduce
I cannot reproduce this issue.
ij> execute statement sysibm.getTableTypes;
TABLE_TYPE
------------
SYNONYM
SYSTEM TABLE
TABLE
VIEW
4 rows selected
> Execute Statement of a SYSIBM sps gives java linkage error and class not
> found exception.
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-28
> URL: https://issues.apache.org/jira/browse/DERBY-28
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.0
> Reporter: Ramandeep Kaur
> Priority: Minor
>
> Opening this bug on behalf of Mamta Satoor.
> ------------------------------------------------------
> Execute/Create/Drop statement is not supported anymore in
> Derby but we do have internal sps in the database.
> When I try to do say execute statement sysibm.getTableTypes;
> I get 2 exceptions
> Drop statement behaves more gracefully
> ij> drop statement sysibm.getTableTypes;
> ERROR 42X62: 'DROP STATEMENT' is not allowed in the 'SYSIBM'
> schema.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
