Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
How can I achieve altering the 2 columns to be foreign keys?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
vaibhav_pal

New User


Joined: 20 Jan 2007
Posts: 4
Location: Mumbai
PostPosted: Mon May 12, 2008 3:45 pm    Post subject: How can I achieve altering the 2 columns to be foreign keys?
 Reply with quote
Hi,

I created a table thru spufi.However,I realised that couple of fields/columns need to be foreign keys.How can I achieve altering the 2 columns to be foreign keys? Another question is can I have a table with only foreign key and not a primary key? If yes how to create such table?
Back to top
View user's profile Send private message
References
PostPosted: Mon May 12, 2008 3:45 pm    Post subject: Re: How can I achieve altering the 2 columns to be foreign keys? Reply with quote
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 8022
Location: 221 B Baker St
PostPosted: Tue May 13, 2008 10:59 am    Post subject:
Reply with quote
Hello,

Look here: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.11?

and here: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/1.5.2?

I recommend you become famiar with the documentation available via the "IBM Manuals" link at the top of the page.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1