Hi Pierre, The syntax is
CLEANUP TABLE <tablename>; I just noticed that it's not documented in the Trafodion SQL Reference. Not sure why. (I looked for it here: http://trafodion.apache.org/docs/1.3.0/sql_reference/index.html#data_definition_language_statements) We'll have to fix that. Dave -----Original Message----- From: Pierre Smits [mailto:[email protected]] Sent: Monday, March 28, 2016 5:59 AM To: [email protected] Subject: Cleanup Trafodion 1.3 Sandbox Hi all, I recently used the VirtualBox image provided by Amanda to establish a PoC. While performing a drop schema cascade some tables are not removed and thus the execution fails. This is the message I get: GIFT_CARD has invalid state and cannot be accessed. Use cleanup command to drop it. The question is: how do I execute the cleanup command (and from where)? Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/
