Re: TRUNCATE

[David Donnelly <Dave@ISISBIO.COM>]

Hi Crystal,

First of all, the syntax is "truncate TABLE ps_dist_in reuse storage" .
>From the error message, I'd guess you also forgot to surround it with
begin-sql and end-sql:

begin-sql
truncate TABLE ps_dist_ln reuse storage
end-sql

and finally, this started to work sometime during version 3 (no later than
3.0.7) so the answer may depend on the version you have.

Cheers.

Dave


At 03:11 PM 8/25/1998 -0500, you wrote:
>Is it possible to use the ORACLE command truncate in SQR?  I tried the
>code below and received the error message:
>(SQR 4008) Unknown function or variable in expression: truncate
>
>
>truncate ps_dist_ln reuse storage
>
>Thanks,
>Crystal Thompson
>
>