Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Before closing the cursor if you give commit

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sararaju

New User


Joined: 04 May 2005
Posts: 25

PostPosted: Wed May 11, 2005 11:59 am    Post subject: Before closing the cursor if you give commit
Reply with quote

I am facing this question in an interview

!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

2)wht is exactly bind doing in compilation stage?
Back to top
View user's profile Send private message

Ashutosh Shrinet

New User


Joined: 22 Aug 2004
Posts: 10
Location: New Delhi

PostPosted: Thu May 12, 2005 5:32 pm    Post subject:
Reply with quote

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).
Back to top
View user's profile Send private message
narasimharao_koganti

New User


Joined: 26 Apr 2005
Posts: 11
Location: pune

PostPosted: Thu May 12, 2005 9:01 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
brain_s390

New User


Joined: 06 May 2005
Posts: 58
Location: Mumbai

PostPosted: Sat May 14, 2005 5:30 pm    Post subject: Re: Before closing the cursor if you give commit
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 1 Sun Mar 12, 2017 5:35 pm
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us