I've worked in three shops where folks changed the CRTDUPOBJ command default
to DATA(*YES) or created a shortcut.  In each case it became a problem, and
the default was changed back to *NO.  If you meant to copy the data, but
forgot to change the parm from DATA(*NO) it's child's play to whip up a CPYF
command FRMRCD(1) (and submit it to batch).  If you meant to copy the
structure only, but the default was left at *YES you could end up
overrunning storage or bringing the system to its knees with an abusive
interactive job.  It happened often enough to annoy or frighten sys admins,
management, and peers.

My Oracle DBA's are rarely concerned with copying a table and its data in
one shot.  They lay out the structure first and import the data.  It seems
like our expectations for CRTDUPOBJ are centered around the fact that, on
the AS/400, a table is a file is an object just like any object.

-Jim


-----Original Message-----
From: rob@dekko.com [mailto:rob@dekko.com]
Sent: Thursday, December 13, 2001 9:19 AM
To: midrange-l@midrange.com
Subject: RE: CPY instead of CRTDUPOBJ ? (was: CD Burning software?)



Don't know as if I would have had that as the default.  I guess the counter
argument would be it would take less time to recopy and add the data if
that was what you meant, than it would take to stop the copy and recopy it
with only the format.

Not something I am willing to fight to the death for - I'll leave that up
to others on this list  :-)

Rob Berendt

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



                    Jim Damato
                    <jdamato@dollargene       To:
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    ral.com>                  cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     RE: CPY instead
of CRTDUPOBJ ? (was: CD Burning software?)
                    drange.com


                    12/13/2001 10:05 AM
                    Please respond to
                    midrange-l






> Rob:
> Oh wait, you have that pesky DATA(*YES) you have to remember to answer in
> CRTDUPOBJ.

How else would you distinguish between duplicating the format of a table
and
duplicating the format and contents of a table?

-Jim



As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.