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
User avatar
ibmlearner
Member
Posts: 13
Joined: Sat Dec 02, 2006 5:57 pm

FOREIGN KEY

Post by ibmlearner » Thu Mar 08, 2007 7:54 pm

HI ALL ,,,,

1 ) HOW MANY PRIMARY KEYS AND FOREIGN KEYS ARE POSSIBLE

FOR ONE TBALE ???


2) THE MAX NO COLUMS IN ONE TABLE IS 224 IS IT CORRECT ???



TIA.
Thanks & Regards
-------------------------
Learner

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Sat Mar 10, 2007 12:03 am

A table may have multiple foreign keys

A table cannot have more than one set of attributes specified as the primary key, and the columns of a primary key cannot contain null values.

The max number of columns in a table is 750

The max number of tables in a join is 225

Normally this is depended on the max page size and max length of the row in DB2.

NOTE : THESE NUMBERS ALTER AS PER THE DB2 VERSION THIS INFO IS AS PER VER 8.0 I BLIVE.

Thanks
Veera

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