Page 1 of 1

Bind Parameters ??

PostPosted: Sun May 29, 2011 10:07 pm
by gauthamnagpur18
Hi ,

I am beginner in Db2 . I just came across bind . I understood why do we bind , but i cant able to get its parameters .

Plan (cmst01)
owner (dbucmst)
qualifier (dbucmst)
member (cmst01)
action (replace)
currentdata (no)
degree(1)
explain(no)
isolation (cs)
release (commit)
validate (Bind)

Thanks in advance .

Regards
Gautham

Re: Bind Parameters ??

PostPosted: Sun May 29, 2011 11:39 pm
by enrico-sorichetti
everything is explained here
http://publibz.boulder.ibm.com/cgi-bin/ ... 1204091348
in chapter 3.8 BIND and REBIND options
http://publibz.boulder.ibm.com/cgi-bin/ ... 1204091348

and here is the link to the whole db2 9.1 bookshelf
http://publibz.boulder.ibm.com/cgi-bin/ ... s/DSNSHKA3

but even better here is the link to the mother of all manuals
http://www-03.ibm.com/systems/z/os/zos/ ... index.html

Re: Bind Parameters ??

PostPosted: Mon May 30, 2011 1:29 am
by dick scherrer
Hello,

but i cant able to get its parameters .
The manuals will explain the syntax.

Suggest you also talk with a dba or project senior and learn the specifics of how things are done on your system.