Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GarryTwine
- Order by date
-
Table Design - VARCHAR vs. CHAR
Does anyone have any advise on the advantages / disadvantages of either field type. When does a VARCHAR become more efficient than a CHAR? ie Is there an optimum length of CHAR when VARCHAR should be considered? What about with regard to substring searches? Is it more efficient to perform a...- GarryTwine
- Thread
- Replies: 2
- Forum: IBM: DB2
-
Parent Table for Foreign Keys
The relationship between a foreign key and the parent/child table is held in the SYSRELS system catalog table.- GarryTwine
- Post #2
- Forum: IBM: DB2
-
Parent Table for Foreign Keys
How can one use the system catalog tables to list the parent tables of foreign keys? DB2 version 6- GarryTwine
- Thread
- Replies: 1
- Forum: IBM: DB2
