RE: CPY instead of CRTDUPOBJ ? (was: CD Burning software?)

[Jim Damato <jdamato@xxxxxxxxxxxxxxxxx>]

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