Re: SQL Drop Column?

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: David Gibbs <dgibbs@mks.com>
To: 'RPG400 Mailing List' <RPG400-L@midrange.com>
Date: Tuesday, September 18, 2001 1:16 PM
Subject: SQL Drop Column?


>If I want to do an "ALTER TABLE <tablename> DROP COLUMN <columnname>" on a
>SQL table, is there a way to programmatically ignore the CPD32CC - "Change
>to field <columnname>may result in data loss" message?
>

HMMMMM....

You know, I've never put DDL in an RPG program. Always used a script....

so shot in the dark... have you tried using WHENEVER WARNING CONTINUE and
WHENEVER ERROR CONTINUE?


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman