>>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?
>
>YOur NewKey routine is not a part of your table, it is part of the dbc, and so does not go with the table. You will have to recreate the routine in the new database. There are ways you can do this programmatically, but they are not easier than cut and paste...

Thanks, I needed to do it programmatically and even figured out how to do it. Howsomeever, I decided to take a different approach altogether and even shaved a couple of hours off the runtime!