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.CONSTDE P" is an undefined name.
SQLSTATE=01532

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

[PM \(pm3iinc-nospam\)]

Re: Problems when binding DBConnect against OS/390

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

search : PTF

Check the links with ...prereq... and DatabaseMetaDat a
(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+group%3Acomp.databases.ibm-db2&hl=en&lr=&ie=ISO-8859-1&scoring=d

PM

"Johan Hellstrom" <xtrnjot@nospam .hotmail.com> a écrit dans le message de
news:bqphg9$hj8 $1@newstree.wis e.edt.ericsson. se...[color=blue]
> 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[/color]
have[color=blue]
> 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
> ------ ------------------------------------------------------------------[/color]
--[color=blue]
> SQL0061W The binder is in progress.
>
> LINE MESSAGES FOR db2ueiwi.bnd
> ------ ------------------------------------------------------------------[/color]
--[color=blue]
> 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.CONSTDE P" is an undefined name.
> SQLSTATE=01532
>
> LINE MESSAGES FOR ddcsmvs.lst
> ------ ------------------------------------------------------------------[/color]
--[color=blue]
> SQL0091N Binding was ended with "0" errors and "3" warnings.
>
>
>[/color]