METADATA_DELASSN Function
Deletes all objects that make up the specified
association.
Syntax
rc=METADATA_DELASSN(uri,assn);
Required Arguments
- uri (in)
-
specifies a Uniform
Resource Identifier.
- assn (in)
-
specifies an association
name.
Return Values
| 0 |
Successful completion. |
| -1 |
Unable to connect to the metadata server. |
| -2 |
The deletion was unsuccessful; see the SAS log for
details.
|
| -3 |
No objects match the URI. |
Example
options metaserver="a123.us.company.com"
metaport=8561
metauser="myid"
metapass="mypassword"
metarepository="myrepos";
data _null_;
length uri $256
curi $256
curi1 $256
curi2 $256;
rc=0;
/* Create a PhysicalTable object. */
rc=metadata_newobj("PhysicalTable",
uri,
"My Table");
put rc=;
put uri=;
/* Create a couple of columns on the new PhysicalTable object. */
rc=metadata_newobj("Column",
curi,
"Column1",
"myrepos",
uri,
"Columns");
put rc=;
put curi=;
rc=metadata_newobj("Column",
curi1,
"Column2",
"myrepos",
uri,
"Columns");
put rc=;
put curi1=;
rc=metadata_newobj("Column",
curi2,
"Column3",
"myrepos",
uri,
"Columns");
put rc=;
put curi2=;
/* Delete association between table and columns, remove Column objects. */
rc=metadata_delassn(uri,"Columns");
put rc=;
/* Delete PhysicalTable object. */
rc=metadata_delobj(uri);
put rc=;
run;