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.