I have problems with configuring oracle database gateway for drda
One of the steps in this process is (according to the manuel) is (DB2
side):

- GRANT EXECUTE ON PACKAGE oraclegtw.* TO PUBLIC

If I execute this statement I receive the following error:

- An unexpected token "*" was found following "N PACKAGE
oraclegtw.".
Expected tokens may include: "<identifier>".. SQLCODE=-104,
SQLSTATE=42601, DRIVER=3.61.65

Can somebody help me with this problem

On 5 nov, 23:03, "mar... (AT) nowhere (DOT) invalid" <mar.houweni... (AT) wxs (DOT) nl>
wrote:
The grant syntax on a whole schema is - unfortunately - not supported
by DB2.

I'm not too strong with packages myself, but if you bound them using a
*.bnd file you could've granted it at that point. Right now, I assume
you'll have to grant it on each package separately.

You can work from this query to find the complete list: select PKGNAME
from syscat.packages where PKGSCHEMA = 'ORACLEGTW'

--
Frederik Engelen

Frederik Engelen <engelenfrederik (AT) gmail (DOT) com> wrote in news:0e879207-2700-
471c-b475-16ab7168d19b (AT) f13g2000...oglegroups.com:

For DB2 LUW this is true, it is supported though for DB2 z/OS.

This won't work in this case as the grant is performed during
configuration, while the packages are created/bound at first usage of the
gateway.
Luckily the Gateway documentation offers an alternative
installation/configuration procedure where the packages are bound/granted
manually, directly on the DB2 server, as I've explained in more detail in
the Oracle group where the OP also asked this question.
For those interested, the doc can be found here:

http://download.oracle.com/docs/cd/E11882_
01/gateways.112/e12013/configdrda_server.htm#OTGIS1073

(the manual procedure is described in par. 13.4.2)

Cheers!

--
Jeroen