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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
constraint on composite foreign keys
Sorry for the mistake in my question. It should be the other way round. Any value of the field act_seq_nbr in Table B should come from the value of the field act_seq_nbr in Table A. In Table A each mht_itl_nbr can have multiple act_seq_nbr. In Table B each mht_itl_nbr has only one act_seq_nbr...- peterzh
- Post #3
- Forum: Microsoft SQL Server: Programming
-
constraint on composite foreign keys
Hi Guys, Here is my question. I have two tables A and B: Table A (mht_nbr, act_seq_nbr) and Table B (mht_nbr, act_seq_nbr, src_cde) In table B all three fields are primary keys. I want to have a constraint on field act_seq_nbr in Table A: any value of this field must come from the values of...- peterzh
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
CONTROL CENTER DOESN'T WORK PROPERLY
Ties, Thanks for your information. I will give it a try when I get the chance. Peter -
CONTROL CENTER DOESN'T WORK PROPERLY
Thank you, Juliane and Marc. I am new to DB2 and will let the DBA to handle the issue. I am connecting to a remote DB2(8.2)/AS400. I can use the Command Editor to connect to the database, see all the tables there,use the select, insert statements, but when I right click on the name of the... -
CONTROL CENTER DOESN'T WORK PROPERLY
Hi Guys, My control center is not working properly. When I click discover system name from configuration assistant, I got the following error message: Thanks. SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used...
