Hi, that approach should work as long as the table you are dropping is loaded at the time. The message you mentioned suggests that the table was not loaded. A colleague of mine ran code based on your example and it ran as expected.
80 proc cas ;
81 loadActionSet 'fedSql' ;
82 _dp_inputCaslib='dm' ;
83 queryCode='drop table "' || _dp_inputCaslib || '"."ORDER_FACT" {options force=true}' ;
84 print queryCode ;
85 ExecDirect / query=queryCode ;
86 quit ;
NOTE: Active Session now MYSESSION.
NOTE: Added action set 'fedSql'.
drop table "dm"."ORDER_FACT" {options force=true}
NOTE: The FedSQL action was successful.
NOTE: PROCEDURE CAS used (Total process time):
real time 0.12 seconds
cpu time 0.01 seconds
You could also try an alternative approach such as:
80 proc cas ;
81 table.droptable / caslib="dm" name="order_fact" ;
82 quit ;
NOTE: Active Session now MYSESSION.
NOTE: Cloud Analytic Services dropped table order_fact from caslib DM.
NOTE: PROCEDURE CAS used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
Hope that helps.
... View more
