|
Problem IC80870
|
Status: Geschlossen |
SQL0270N RETURNED WHEN GRANT OR REVOKE IS USED WITH ARRAY FUNCTION TYPE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.01.2012
27.08.2012
27.08.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.10
|
 |
