× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.