My problem is, could not use TRUNCATE command in DB2-COBOL program.
EXEC SQL
TRUNCATE TABLE SELL_DB_UPLD
REUSE STORAGE
IGNORE DELETE TRIGGERS
IMMEDIATE
END-EXEC.
TRUNCATE TABLE SELL_DB_UPLD
REUSE STORAGE
IGNORE DELETE TRIGGERS
IMMEDIATE
END-EXEC.
This was my code it shows two errors when compling.
First Error : "IS" required
Second Error: Illegal symbol SELL_DB_UPLD, some symbol that is legal are "IS".
We are using DB2 version 8. Whether TRUNCATE command work above DB2 9.7 version or it will run in all version?
Please help.
Thanks in advance.