Hi,
I want to drop a field from with in my rpg. So i do this;
When the program runs i get this;
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.
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)
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.