BIND NOT SUCCESSFUL

HARBRY ARIZA

BIND NOT SUCCESSFUL
Hi guys:


I got a question. I just trying to execute a bind but failed because
it try to reference one csect DSNHSMS1 and it couldn't find it. Please if
someone has seen this problem before I would appreciate your help about it.
Thanks and regards,

harbry


DSNT201I # BIND FOR PLAN DSQ6BSQL NOT SUCCESSFUL
DSN
BIND PLAN(DSQ6BINS) MEMBER(DSQ0BINS) ISOLATION(CS)
DSNX200I # BIND SQL ERROR
USING DBAMHA AUTHORITY
PLAN=DSQ6BINS
DBRM=DSQ0BINS
STATEMENT=1188
SQLCODE=-104
SQLSTATE=42601
TOKENS=QSTRING :
CSECT NAME=DSNHSMS1
RDS CODE=0
DSNT201I # BIND FOR PLAN DSQ6BINS NOT SUCCESSFUL


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Shaun LOMBARD

Re: BIND NOT SUCCESSFUL
(in response to Rob Wright)
Harbry,

What this message is trying to tell you is that you got an SQLCODE -104. So
statement number 1188 in DBRM DSQOBINS has an illegal symbol "QSTRING" and
DB2 is expecting the ":" symbol. I would say you have a program that does
not have a colon(:) before the host variable name.

Shaun

-----Original Message-----
From: HARBRY ARIZA [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 13:56
To: [login to unmask email]
Subject: BIND NOT SUCCESSFUL


Hi guys:


I got a question. I just trying to execute a bind but failed because
it try to reference one csect DSNHSMS1 and it couldn't find it. Please if
someone has seen this problem before I would appreciate your help about it.
Thanks and regards,

harbry


DSNT201I # BIND FOR PLAN DSQ6BSQL NOT SUCCESSFUL
DSN
BIND PLAN(DSQ6BINS) MEMBER(DSQ0BINS) ISOLATION(CS)
DSNX200I # BIND SQL ERROR
USING DBAMHA AUTHORITY
PLAN=DSQ6BINS
DBRM=DSQ0BINS
STATEMENT=1188
SQLCODE=-104
SQLSTATE=42601
TOKENS=QSTRING :
CSECT NAME=DSNHSMS1
RDS CODE=0
DSNT201I # BIND FOR PLAN DSQ6BINS NOT SUCCESSFUL


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.








Sanjeev (CTS) S

Re: BIND NOT SUCCESSFUL
(in response to Shaun LOMBARD)
It is simply the Sql Syntax error for the sql written in statement
number 1188. Please check the sql for its syntax.

HTH
Regards
Sanjeev
> -----Original Message-----
> From: HARBRY ARIZA [mailto:[login to unmask email]
> Sent: Wednesday, 20 December 2000 13:56
> To: [login to unmask email]
> Subject: BIND NOT SUCCESSFUL
>
>
> Hi guys:
>
>
> I got a question. I just trying to execute a bind but failed because
> it try to reference one csect DSNHSMS1 and it couldn't find it. Please if
> someone has seen this problem before I would appreciate your help about
> it.
> Thanks and regards,
>
> harbry
>
>
> DSNT201I # BIND FOR PLAN DSQ6BSQL NOT SUCCESSFUL
> DSN
> BIND PLAN(DSQ6BINS) MEMBER(DSQ0BINS) ISOLATION(CS)
> DSNX200I # BIND SQL ERROR
> USING DBAMHA AUTHORITY
> PLAN=DSQ6BINS
> DBRM=DSQ0BINS
> STATEMENT=1188
> SQLCODE=-104
> SQLSTATE=42601
> TOKENS=QSTRING :
> CSECT NAME=DSNHSMS1
> RDS CODE=0
> DSNT201I # BIND FOR PLAN DSQ6BINS NOT SUCCESSFUL
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
> the
>
>
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------



Rob Wright

Re: BIND NOT SUCCESSFUL
(in response to HARBRY ARIZA)
Did your pre-compile work successfully, or did you get SQL errors?





HARBRY ARIZA <[login to unmask email]> on 12/20/2000 02:56:12 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Rob Wright/ham/LIC)

Subject: BIND NOT SUCCESSFUL



Hi guys:


I got a question. I just trying to execute a bind but failed because
it try to reference one csect DSNHSMS1 and it couldn't find it. Please if
someone has seen this problem before I would appreciate your help about it.
Thanks and regards,

harbry


DSNT201I # BIND FOR PLAN DSQ6BSQL NOT SUCCESSFUL
DSN
BIND PLAN(DSQ6BINS) MEMBER(DSQ0BINS) ISOLATION(CS)
DSNX200I # BIND SQL ERROR
USING DBAMHA AUTHORITY
PLAN=DSQ6BINS
DBRM=DSQ0BINS
STATEMENT=1188
SQLCODE=-104
SQLSTATE=42601
TOKENS=QSTRING :
CSECT NAME=DSNHSMS1
RDS CODE=0
DSNT201I # BIND FOR PLAN DSQ6BINS NOT SUCCESSFUL


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.








HARBRY ARIZA

Re: BIND NOT SUCCESSFUL
(in response to Sanjeev (CTS) S)
Hi Guys:


Thanks for your help but I found the reason why my bind was failing.I'm
installing QMF (one of the older version v2r4) on one of my db2 subsystem
(v6r1) and now you must specify colon(:) on all your host variables. Before
v6 you would be able to do it but since db2 version 6 and version 7 you must
use colon with your host variables. Thanks and regards ,

harbry
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.