truncate table stmt question

Hello, We recently upgraded to 94fc8. Per TFM, I am attempting to use the truncate table sql. It is generating the illuminating 201 error. The table has no constraints or views. It's data is generated via a trigger from a master table.
syntax to date:
truncate table yadda;
truncate yadda;
truncate only yadda;

I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction.

Thanks in advance,
Doug

.

Relevant Pages

  • Re: truncate table stmt question
    ... Art S. Kagel escribió: ... syntax to date: truncate table yadda; ... I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction. ...
    (comp.databases.informix)
  • Re: truncate table stmt question
    ... Art S. Kagel wrote: ... truncate table yadda; ... I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction. ...
    (comp.databases.informix)
  • Re: truncate table stmt question
    ... Doug Fossmeyer wrote: syntax to date: truncate table yadda; ... I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction. ...
    (comp.databases.informix)
  • Re: truncate table stmt question
    ... Doug Fossmeyer wrote: syntax to date: truncate table yadda; ... I saw a reference to this functionality being available only in XPS; however Syntax manual for 94 does not give that restriction. ...
    (comp.databases.informix)
  • Re: truncate tables in my tablespace
    ... tablename have the same restriction with constraints as truncate? ... DELETE will also have issues with foreign keys. ... SQL> -- Add primary key to emp ...
    (comp.databases.oracle.server)