foreign key

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
chintu
Member
Posts: 9
Joined: Thu Oct 18, 2007 8:41 pm

foreign key

Post by chintu » Wed Oct 24, 2007 8:59 pm

Hai,

Iam a beginner.Can anybody explain me about the foreign key i.e.

when we use references what is on delete set null

and what is on delete restrict

thanks in advance .

User avatar
DavidatK
Active Member
Posts: 65
Joined: Tue Mar 27, 2007 8:41 am
Location: Troy, MI USA

Post by DavidatK » Thu Oct 25, 2007 2:05 am

chintu,

Not sure exactly what your question is, but check out the link below and see if this answers it.

Delete Set Null

If this does not answer your question, please come back

Dave

immanuel
Member
Posts: 4
Joined: Wed Mar 12, 2008 3:35 pm

Post by immanuel » Wed Jun 18, 2008 1:42 pm

actually , other than primary key u should select another key which is the primary key for next table. that other key of first table is referred as foreign key

academyindia4

Topic deleted by Admin

Post by academyindia4 » Fri Jan 15, 2016 10:08 pm

<< Content deleted By Admin >>

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Fri Jan 15, 2016 11:17 pm

Pictures of your family members are not approved of here, however dear they are to you.

User avatar
guru
Member
Posts: 24
Joined: Fri Apr 20, 2007 7:17 pm

Post by guru » Sun Jan 17, 2016 5:52 pm

whats happening here, why this spam posts are still exists? where is the site admin?

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others