Re: TRUNCATE

["Korbel Gordon E." <GEKORBEL@NORSTAN.COM>]

I have used truncate successfully -- but I did not add the reuse storage
arguments.

eg..

BEGIN-SQL
        truncate table-name
END-SQL

-Gordon Korbel

> -----Original Message-----
> From: Thompson,Crystal [SMTP:THOMPSCD@AGEDWARDS.COM]
> Sent: Tuesday, August 25, 1998 3:11 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      TRUNCATE
>
> 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