To fetch records from different tables, FORIEGN Key must?

kathir · New User Joined: 03 May 2005 Posts: 4

Hi Guys,

To fetch records from different tables, whether we want to set foreign key or not.

brahmanandareddy · New User Joined: 16 Dec 2004 Posts: 48 Location: Hyderabad

Hi,

To fetch the records from a table there is no complusion that u should set a foreign key

Thanks,
Brahmananda Reddy

nandakumar · New User Joined: 05 May 2005 Posts: 49

in db2 what is the use of spufi

narasimharao_koganti · New User Joined: 26 Apr 2005 Posts: 11 Location: pune

hi, nandakumar
spufi means SQL Processing Using File Input. it is used to check the execution of sql queries. For spufi input must be a PS or PDS, the output will be a PS.

nandakumar · New User Joined: 05 May 2005 Posts: 49

what is the use of isolation level (cs/rr) in db2bind?

Any bodyplease explain me

vasanthanc · Active User Joined: 01 Apr 2005 Posts: 59

But Nandakumar, why are you raising your doubts under foreign key topic? Instead better you post as new topic, with subject line related to the topic

ajay_dheepak · New User Joined: 12 May 2005 Posts: 33 Location: Chennai

CS means Cursor Stability. When the bind optionis set to CS; DB2 takes care that only one process gets the update privilege at one point. For example when a process executes a select on a particular table, it gets S (Share) lock is obtained on that table. When an update is executed, initially a U (Update) lock is issued and once on the process of updation an X (Exclusive) lock is issued so that no user gets even S lock so that it ensures that all users gets the latest data.

RR means Repeatable Read. The process gets the last updated data when it transfers back to the page. Where in the last inserted record is not shown.

nandakumar · New User Joined: 05 May 2005 Posts: 49

hi,
can anybody please tell about the difference between exclusive lock and shared lock DB2 ?( with a small example)

brain_s390 · Active User Joined: 06 May 2005 Posts: 59 Location: Mumbai

Hey Dude !!

Shared locks allow two or more programs to read simultaneously but not change the locked space.

An exclusive lock bars all other users from accessing the space.

An update lock is less restrictive; it allows other transactions to read or acquire shared locks on the space.