14data work.drop_scope work.drop_a work.drop_b work.drop_keep1
22%mp_assertscope(SNAPSHOT)
23%mp_dropmembers(list=drop_scope)
24%mp_assertscope(COMPARE,
25 desc=Checking that mp_dropmembers does not leak scope,
26 outds=work.test_results
29%mp_dropmembers(list=drop_a)
32 iftrue=(%mf_existds(work.drop_a)=0),
33 desc=Checking that a listed dataset is dropped,
34 outds=work.test_results
38 iftrue=(%mf_existds(work.drop_b)=1),
39 desc=Checking that an unlisted dataset is kept,
40 outds=work.test_results
46 create view work.drop_view as select * from work.drop_b;
49%mp_dropmembers(list=drop_view)
53 iftrue=(%mf_existds(work.drop_view)=0),
54 desc=Checking that a listed view is dropped,
55 outds=work.test_results
59%mp_dropmembers(list=drop_keep1,iftrue=(1=0))
61 iftrue=(%mf_existds(work.drop_keep1)=1),
62 desc=Checking that a false iftrue condition drops nothing,
63 outds=work.test_results
67%mp_dropmembers(list=drop_keep2,iftrue=(1=1))
69 iftrue=(%mf_existds(work.drop_keep2)=0),
70 desc=Checking that a true iftrue condition drops the member,
71 outds=work.test_results