Hi,

Have installed the latest 8.1.4 fixpack for DB2 Connect EE/DB2 Application
Development Client and am trying to access a DB2 OS/390 7.1.1 system.

The binding process from Windows 2000:

connect to <host> user <whatever> using <whatever>
bind @ddcsmvs.lst blocking all sqlerror continue messages mvs.msg grant
public
connect reset

... works fairly well, but comes up with a couple of warning messages. I have
noted some odd behaviors from applications trying to find out what
schemas/tables that exist and even though basic table access works I would
appreciate if anybody could shed any light on the messages below:

LINE MESSAGES FOR ddcsmvs.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2ueiwi.bnd
------ --------------------------------------------------------------------
1426 SQL0440N No authorized routine named "FUNCTION" of type
"TABLE_NAME " having compatible arguments was found.
SQLSTATE=58020
2306 SQL0206N "NAME " is not valid in the context where it is
used. SQLSTATE=01533
2328 SQL0204N "SYSCAT.CONSTDEP" is an undefined name.
SQLSTATE=01532

LINE MESSAGES FOR ddcsmvs.lst
------ --------------------------------------------------------------------
SQL0091N Binding was ended with "0" errors and "3" warnings.

http://publib.boulder.ibm.com/infoce...help/index.jsp
search : PTF

Check the links with ...prereq... and DatabaseMetaData
(maybe also others)

Not sure if you need to do something with db2schema.bnd when using
db2 connect to go to a host.

You can revise some related threads in this list :
http://groups.google.ca/groups?q=ptf...59-1&scoring=d


PM

"Johan Hellstrom" <xtrnjot@nospam.hotmail.com> a écrit dans le message de
news:bqphg9$hj8$1@newstree.wise.edt.ericsson.se...
> Hi,
>
> Have installed the latest 8.1.4 fixpack for DB2 Connect EE/DB2 Application
> Development Client and am trying to access a DB2 OS/390 7.1.1 system.
>
> The binding process from Windows 2000:
>
> connect to <host> user <whatever> using <whatever>
> bind @ddcsmvs.lst blocking all sqlerror continue messages mvs.msg grant
> public
> connect reset
>
> .. works fairly well, but comes up with a couple of warning messages. I
have
> noted some odd behaviors from applications trying to find out what
> schemas/tables that exist and even though basic table access works I would
> appreciate if anybody could shed any light on the messages below:
>
> LINE MESSAGES FOR ddcsmvs.lst
> ------ ------------------------------------------------------------------
--
> SQL0061W The binder is in progress.
>
> LINE MESSAGES FOR db2ueiwi.bnd
> ------ ------------------------------------------------------------------
--
> 1426 SQL0440N No authorized routine named "FUNCTION" of type
> "TABLE_NAME " having compatible arguments was found.
> SQLSTATE=58020
> 2306 SQL0206N "NAME " is not valid in the context where it is
> used. SQLSTATE=01533
> 2328 SQL0204N "SYSCAT.CONSTDEP" is an undefined name.
> SQLSTATE=01532
>
> LINE MESSAGES FOR ddcsmvs.lst
> ------ ------------------------------------------------------------------
--
> SQL0091N Binding was ended with "0" errors and "3" warnings.
>
>
>