can anyone tell me how to verify if table exists before I issue DROP TABLE JOBS for the following statement
SET SQLENGINE=SQLMSS
SQL SQLMSS SET SERVER CONN1
SET COMMIT = ON
SQL SQLMSS
BEGIN TRANSACTION
DROP TABLE JOBS
COMMIT WORK ;
END
by the way, im getting this error message when I try to drop a table which is no longer existing.
FOC1400) SQLCODE IS 3701 (HEX: 00000E75) XOPEN: 42S02
: Microsoft OLE DB Provider for SQL Server: [42S02] Cannot drop the table
: 'JOBS', because it does not exist in the system catalog.
(FOC1414) EXECUTE IMMEDIATE ERROR.
thanks in advance
Appreciate ur help
-P
SET SQLENGINE=SQLMSS
SQL SQLMSS SET SERVER CONN1
SET COMMIT = ON
SQL SQLMSS
BEGIN TRANSACTION
DROP TABLE JOBS
COMMIT WORK ;
END
by the way, im getting this error message when I try to drop a table which is no longer existing.
FOC1400) SQLCODE IS 3701 (HEX: 00000E75) XOPEN: 42S02
: Microsoft OLE DB Provider for SQL Server: [42S02] Cannot drop the table
: 'JOBS', because it does not exist in the system catalog.
(FOC1414) EXECUTE IMMEDIATE ERROR.
thanks in advance
Appreciate ur help
-P