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.


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.
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)
Global moderator
Posts: 3736
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 254 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)
Posts: 313
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2