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
 

 

To fetch records from different tables, FORIEGN Key must?

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

New User


Joined: 03 May 2005
Posts: 4

PostPosted: Thu May 05, 2005 12:47 pm    Post subject: To fetch records from different tables, FORIEGN Key must?
Reply with quote

Hi Guys,

To fetch records from different tables, whether we want to set foreign key or not.
Back to top
View user's profile Send private message

brahmanandareddy

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Thu May 05, 2005 12:52 pm    Post subject:
Reply with quote

Hi,

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

Thanks,
Brahmananda Reddy
Back to top
View user's profile Send private message
nandakumar
Warnings : 2

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Sat May 07, 2005 11:56 pm    Post subject: question
Reply with quote

in db2 what is the use of spufi
Back to top
View user's profile Send private message
narasimharao_koganti

New User


Joined: 26 Apr 2005
Posts: 11
Location: pune

PostPosted: Tue May 10, 2005 9:59 pm    Post subject:
Reply with quote

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

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Fri May 13, 2005 10:33 am    Post subject: questions about db2
Reply with quote

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

Any bodyplease explain me
Back to top
View user's profile Send private message
vasanthanc

New User


Joined: 01 Apr 2005
Posts: 58

PostPosted: Fri May 13, 2005 4:14 pm    Post subject:
Reply with quote

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

New User


Joined: 12 May 2005
Posts: 32
Location: Chennai

PostPosted: Fri May 13, 2005 5:02 pm    Post subject: Re: questions about db2
Reply with quote

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

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Sat May 14, 2005 8:25 am    Post subject: About locks in db2
Reply with quote

hi,
can anybody please tell about the difference between exclusive lock and shared lock DB2 ?( with a small example)
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 4:46 pm    Post subject: Re: To fetch records from different tables, FORIEGN Key must
Reply with quote

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.
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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am


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