!1)before closing the cursor if you give committ then wht will be the result whether it will save the cursor changes or throw error message?pls reply for this query
hi,
i f u give the commit cursor automatically gets closed.it will save the cursor changes.
Bind is a process that builds ?access paths? to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input and produces an application plan. It also checks the user?s authority and validates the SQL statements in the DBRM(s).
hi,
before closing the cursor if u commit the cursor will be closed and all the changes made will be saved.
bind in compilation takes DBRM's or packages as input and gives the executable module for SQL statements, i.e., it consists of the access path specified by the optimizer for the SQL statements. u can see this access path by using EXPLAIN.
1)before closing the cursor if you give committ then wht will be the result whether it will save the cursor changes or throw error message?pls reply for this query
## Yes COMMIT will save the changes automatically.Additionally if you want to continue updating process after commit then specify CURSOR WITH HOLD option.This clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
2)wht is exactly bind doing in compilation stage?
## Bind is a process that builds ?access paths? to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input and produces an application plan. It also checks the user?s authority and validates the SQL statements in the DBRM(s).Mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.
