RE: Backup & Restore SQL Collection to another name?

[Mike Cunningham <mike.cunningham@xxxxxxx>]

I think it would just be a SAVLIB/RSTLIB. Isn't an SQL collection = to a library?  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David Gibbs
Sent: Monday, November 29, 2010 9:30 AM
To: Midrange Systems Technical Discussion
Subject: Backup & Restore SQL Collection to another name?

OK, file this it he potentially 'duh' category.

How do you backup a SQL collection (created using 'create collection abcd' with strsql) and then restore that collection to another name?

Every time I've tried it, I have problems with the journals.

Thanks!

david

--
IBM i on Power Systems - For when you can't afford to be out of business
--
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.