× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. September 2001

Re: SQL Drop Column?

-----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

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-2024 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.