home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT03683 Status: Geschlossen

IN DB2CC, SQL0104N AN UNEXPECTED TOKEN "VARCHAR" WAS FOUND WHEN
REVOKING EXECUTE PRIVILEGE ON A PROCEDURE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
I you REVOKE EXECUTE on a procedure containing a VARCHAR as 
input parameter using Control Center, it may result in producing 
an incorrect SQL statement to run resulting in a SQL0104N error. 
 
 
Here is an example on how you could get this error: 
 
    1. Open the 'Control Center'. 
    2. Expand the SAMPLE database and go to: 'Application 
Objects --> User Defined Functions' 
    3. Right-click on 'MON_GET_BUFFERPOOL' from schema SYSPROC 
and select 'Privileges...' to open the dialog box. 
    4. Click 'Add User...', choose a username and click 'OK'. 
    5. Select the added user and choose 'YES' from the fly-out 
menu under 'Privileges: EXECUTE'. 
    6. Click 'Apply' to apply the changes to the user. 
    7. Leave the dialog box with 'Cancel'. 
    8. Right-click on 'MON_GET_BUFFERPOOL' and select 
'Privileges...' to  open the dialog box again. 
    9. Select the added user and choose 'NO' from the fly-out 
menu under  'Privileges: EXECUTE' to revoke the previously 
granted privilege. 
   10. Click 'Apply' to apply the changes to the user and you 
will receive above mentioned SQL0104N: 
 
[IBM][CLI Driver][DB2/NT64] SQL0104N  An unexpected token 
"VARCHAR" was found following "BUFFERPOOL("SYSIBM".".  Expected 
tokens may include:  "LONG".  SQLSTATE=42601 
 
If you do not take steps 7. and 8. (which means as long as you 
don't close the dialog box) then the SQL0104N will not occur. 
The 'Show SQL' button returns different results for these two 
cases. 
 
Working SQL: 
REVOKE EXECUTE ON FUNCTION 
SYSPROC.MON_GET_BUFFERPOOL(VARCHAR(),INTEGER)FROM USER DB2TEST 
RESTRICT; 
 
Non-working SQL: 
REVOKE EXECUTE ON FUNCTION 
"SYSPROC".MON_GET_BUFFERPOOL("SYSIBM".VARCHAR,"SYSIBM".INTEGER)F 
ROM USER DB2TEST RESTRICT;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 10.1 Fix Pack 5                           * 
****************************************************************
Local-Fix:
Lösung
First fixed in version 10.1 Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.08.2014
13.07.2015
13.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList