DB2 Truncate



IBM's flagship relational database management system

DB2 Truncate

Postby vkumarg3 » Wed Oct 17, 2012 6:17 pm

Hi all,

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.


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.
vkumarg3
 
Posts: 29
Joined: Fri Jan 06, 2012 9:29 am
Has thanked: 10 times
Been thanked: 0 time

Re: DB2 Truncate

 

Re: DB2 Truncate

Postby BillyBoyo » Wed Oct 17, 2012 6:46 pm

Have a look at the manual for your version of DB2. They are all available on the web.

These users thanked the author BillyBoyo for the post:
vkumarg3 (Wed Oct 17, 2012 7:02 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: DB2 Truncate

Postby GuyC » Wed Oct 17, 2012 7:09 pm

or google DB2 z/OS truncate wuld get you this link (2nd hit on my google):
http://db2portal.blogspot.be/2007/04/me ... r-zos.html
I can explain it to you, but i can not understand it for you.

These users thanked the author GuyC for the post:
vkumarg3 (Thu Oct 18, 2012 10:48 am)
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2