Unanswered: If table not exists create else delete from
I am looking to check to see if a table exists. If it does, I want to delete every row in it. If the table does not exist, I want to create the table. This is all preparation to use the table.
When I put the pieces together, it does not work. As three separate statements, they work assuming that the table is created or is not created as needed. Together they fail. Any ideas? I must have something rather simple wrong.
TABSCHEMA = 'TEST_SCHEMA'
AND TABNAME = 'TEST_TABLE'