|
Someone on another list send me a CL program he used on that exact same schema and it worked. Apparenly, in this case at least a mass copy (using CPYF) worked. On 4/13/05, Carel Teijgeler <coteijgeler@xxxxxxxxx> wrote: > > Mike, > > Have you looked at the Generate Data Definition Language API? It can > retrieve the DDL of a table, view, index, triggers, scheme (or library) in a > source member and recreate it as well. > > Ted Holt at IT Jungle wrote a utility for this API. Searching Google will > give some hits. > > The API is not that dif ficult to use in a CLP, either. > > I think passing a library name and objecy type SCHEME you can retrieve all > the SQL commands to create it all, I think even with constraints and such. > > Just a thought. > > Regards, > Carel Teijgeler > > *********** REPLY SEPARATOR *********** > > On 12-4-05 at 13:34 Mike Wills wrote: > > >I know there was some discussion on this a week or two ago with David. We > >are trying to create a duplicate SQL COLLECTION as a test DB. I know I > can't > >save and restore as a new name. So how would I go about copying all of > the > >data to the new DB? I have the tables setup, I just need to copy the > data. > > > >My vendor has a utility to do this, but it takes forever. It first > creates a > >dump of the DB (about a 17 GB file) onto the IFS, then they have me do an > >import. Problem is this import ran for over 24 hours and wasn't complete > >yet. I let it run over 36 hours before I cancelled it. That is not really > >acceptable timeline for me. Plus you need to basically have three copies > of > >the DB on your server at once. That isn't exactly ideal when we have > limited > >amount of disk space. > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > -- Mike Wills Midrange Programmer/Lawson Software Administrator koldark@xxxxxxxxx http://mikewills.name Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.