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: email@example.com [mailto:firstname.lastname@example.org] Sent: Thursday, December 13, 2001 9:19 AM To: email@example.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: "'firstname.lastname@example.org'" <email@example.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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.