Re: CLRPFM and DB2 Tables

----- Original Message -----
From: "Weatherly, Howard" <Howard.Weatherly@dlis.dla.mil>
To: "Midrange Mailing List (E-mail)" <midrange-l@midrange.com>
Sent: Tuesday, July 02, 2002 10:52 AM
Subject: CLRPFM and DB2 Tables


> table was implemented (not a DB2 issue) I am not permitted to use DDL in
the
> job stream. My thought is to use CLRPFM to clear the table and reload it
> using CPYF however something strange happened in testing the program
(before
> I decided to use CPYF) it took forever using Exec SQL Insert.... and I
> eventually killed the job.
>
> Is there some reason that I should not use CLRPFM to clean out this table
> for a reload?


There is no real reason that you could not, unless there are constraints on
the file. Then the clear may fail.

You said no DDL, so use DML... delete * from table
Again, if the constraints are honored (or non-existant) this will work. I
have seen tables with foreign key constraints that have rejected the clear,
but taken the delete *, but I have not investigated them further.

Maybe suspending the constraints, clearing and then reloading and reapplying
the constraints would work in that situation if you can't use the delete for
some reason.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"There is a crack in everything,
  that's how the light gets in.
    - Leonard Cohen