Problems when binding DBConnect against OS/390

[Johan Hellstrom]

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.

[PM \(pm3iinc-nospam\)]

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" <xt*****@nospam.hotmail.com> a écrit dans le message de
news:bq**********@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.