There's no way to zap or replace table w/o exclusive access.
>Hi all
>
>I have this DBC containing a table. This table is basically a cursor and is a structure replica of a working table in the same DBC. I have to keep it as a dbc table for ODBC purposes and I don't want to make special DSN for this temp table.
>
>This table as it will be opened in a shared environment cannot be zapped so I DELETE ALL the table. This makes the table unnecessarily large.
>
>I would like to issue a command, in fact I tried, COPY TO (mytablepath) DATABASE (mydbc) FOR iID = 342342423
>
>342342423 is basically a non-existant number so I get the plain structure. But the table already belongs to the DBC error shows and this command is not executed.
>
>Hope I have been able to convey my idea.
>
>Please advise.
--sb--