Oninit cdi / Archive
Talk to an expert →

Truncate on Informix

Posted in 2004

Topics: Server Administration, Platform-Specific Issues

Srinivas Sreekumar — — source: Usenet: comp.databases.informix

Hi DBAs, Scenario: --------- Used the following sql statement on Informix 7.3 as well on Informix 9.3 (both on HP-UX 11.0 and 11i): "Truncate only table <table-name>" But Informix gives me syntax error: "201: A syntax error has occurred." Want to know: ------------- - The correct usage of truncate working for above IDS versions or is there any limitation with truncate statements not working with Informix? Best Regards, Srinivas Sreekumar Infosys Technologies Ltd. Pune Ph : 91-20-22971591 M : 98225-09326 sending to informix-list

↪ replying to Srinivas Sreekumar
Enor P — — source: Usenet: comp.databases.informix

Srinivas Sreekumar wrote: > > Hi DBAs, > > Scenario: > --------- > Used the following sql statement on Informix 7.3 as well on Informix 9.3 > (both on HP-UX 11.0 and 11i): > > "Truncate only table <table-name>" > > But Informix gives me syntax error: "201: A syntax error has occurred." > > Want to know: > ------------- > - The correct usage of truncate working for above IDS versions or is > there any limitation with truncate statements not working with Informix? It only work on version 8 - xps. -- Enor

↪ replying to Srinivas Sreekumar
Andrew Hamm — — source: Usenet: comp.databases.informix

Srinivas Sreekumar wrote: > > "Truncate only table <table-name>" > > But Informix gives me syntax error: "201: A syntax error has > occurred." Informix doesn't have TRUNCATE (hmmmm - XPS engine might have it) but I believe it's coming in the next version.

Glossary