Re: MIDRANGE-L Digest, Vol 2, Issue 1663

I am running V5R2 with the latest cume, groups, etc.

I did
CRTLIB ROBDELME
STRSQL
CREATE TABLE ROBDELME/DELETEME (MYCHAR CHAR (10 ) NOT NULL WITH
DEFAULT)
INSERT INTO ROBDELME/DELETEME VALUES('DUH')
CRTLIB ROBDELME2
CPYLIB FROMLIB(ROBDELME) TOLIB(ROBDELME2) CRTLIB(*NO)
DSPPFM ROBDELME2/DELETEME
Looked good

Check out your joblog from the CPYLIB.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




William Washington III <w.washington3@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/23/2003 05:59 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Re: MIDRANGE-L Digest, Vol 2, Issue 1663






Hi Andy,
 
I am not aware of any ASP consideration I amviolating here.  I do have 
database triggers on the files in question.  But I had them in past runs 
of this procedure.  I make sure that I remove all triggers after I've 
copied the files into the test library (because I don't need the 
functionality of the triggers in the test environment.)

My CL program clears the target (test) library, then copies all objects 
from one library to the other.  It's almost like I'm doing a CRTDUPOBJ 
with DATA(*NO).  Very frustrating! 
 
If I have to, I can programmatically determine the physical files in the 
"from" library and do a CRTDUPOBJ or CPYF with MBROPT(*REPLACE), but I 
know I didn't have to do this last year...
 
Ideas?

 
------------------------------

message: 10
date: Thu, 23 Oct 2003 17:27:41 -0400
from: "Andy Nolen-Parkhouse" 
subject: RE: CPYLIB and no records copied

William,

I'm not aware of any changes. There are some restrictions related to
copying a library from one ASP to another. Are you doing this by any
chance?

Regards,
Andy Nolen-Parkhouse

> On Behalf Of William Washington III
> Subject: CPYLIB and no records copied
> 
> Hello all,
> 
> Has anyone noticed a change in the CPYLIB command? Last year, I would
> clear my test library, then do a CPYLIB FROMLIB(production) TOLIB(test)
> CRTLIB(*NO) to refresh my test library with new data.
> 
> Now, it seems that all of the files are brought over, but they have zero
> data records!
> 
> I'd hate to think I'll have to individually copy files from prodcution 
to
> test. Tell me I'm wrong!
> 
> William
_______________________________________________
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.