Bind Parameters ??



IBM's flagship relational database management system

Bind Parameters ??

Postby gauthamnagpur18 » Sun May 29, 2011 10:07 pm

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
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: Bind Parameters ??

Postby enrico-sorichetti » Sun May 29, 2011 11:39 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times

Re: Bind Parameters ??

Postby dick scherrer » Mon May 30, 2011 1:29 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post