I am trying to copy a table from one DBC to another DBC. The table has a default value on the Primary Key of NEWKEY('mytable'). When I do the copy: COPY TO tablename DATABASE newdb WITH PRODUCTION I thought that would do it. Am I going to have to recreate the DEFAULT after I copy the table, or is their a better way?
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me