IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How can I achieve altering the 2 columns to be foreign keys?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vaibhav_pal

New User


Joined: 20 Jan 2007
Posts: 4
Location: Mumbai

PostPosted: Mon May 12, 2008 3:45 pm
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
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue May 13, 2008 10:59 am
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Increase the number of columns in the... IBM Tools 3
No new posts Use input file with OMIT rcd keys? DFSORT/ICETOOL 15
No new posts DB2 Views with Multiple SQL & Col... DB2 8
No new posts SORT - To repeat a string in same col... SYNCSORT 3
Search our Forums:

Back to Top