ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Dropping a field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dropping a field

    Hi,
    I want to drop a field from with in my rpg. So i do this;
    PHP Code:
    C/exec sql                                                  
    C
    ALTER TABLE QTEMP/SVAUD4REA DROP COLUMN BREAKLVL CASCADE 
    C
    /end-exec 

    When the program runs i get this;
    PHP Code:
    Change to field BREAKLVL may result in data loss.          
    Change of file SVAUD4REA may cause data to be lost. (C I
    CPD32CC and CPA32B2 .

    I found this http://www.dbforums.com/archive/index.php/t-648757.html

    But I just wanted to see if anyone else had a solution to use. I played around with the "WHENEVER ERROR CONTINUE" in the exec , but I cant find any good examples.

    Thanks.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply
Working...
X