|
Problem IC80870
|
Status: Closed |
SQL0270N RETURNED WHEN GRANT OR REVOKE IS USED WITH ARRAY FUNCTION TYPE |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When a array type is created, cast function of array type is
created to convert from
base type to array type and vice versa. However, grant or revoke
against the array function would fail
with the following error:
SQL0270N Function not supported (Reason code = "16").
SQLSTATE=42997
The problem only affects grant or revoke statement which specify
an array data-type in the function-designator. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 95fp9 *
****************************************************************
* PROBLEM DESCRIPTION: *
* When a array type is created, cast function of array type is *
* created to convert from *
* base type to array type and vice versa. However, grant or *
* revoke *
* against the array function would fail *
* with the following error: *
* *
* SQL0270N Function not supported (Reason code = "16"). *
* SQLSTATE=42997 *
* *
* The problem only affects grant or revoke statement which *
* specify *
* an array data-type in the function-designator. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V95fp10 *
**************************************************************** |
| Local Fix: |
Grant / Revoke can be used with "SPECIFIC FUNCTION' designator |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.01.2012
27.08.2012
27.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.10
|
 |
