Updating Metadata Objects

Example of an UpdateMetadata Request That Appends Associations

The following UpdateMetadata request adds an association and a new Column object to PhysicalTable A53TPPVI.A4000002 using the APPEND directive:

<UpdateMetadata>
   <Metadata>
      <PhysicalTable Id="A53TPPVI.A4000002">
         <Columns Function="Append">
             <Column Id="" Name="Salary" PublicType="Column"/>
         </Columns>
      </PhysicalTable>
   </Metadata>
   <NS>SAS</NS>
   <!-- OMI_TRUSTED_CLIENT Flag -->
   <Flags>268435456</Flags>  
   <Options/>
</UpdateMetadata>

In the example, the null Id= value in the associated object definition indicates the associated object is to be created. Here is an example of the output returned by the SAS Metadata Server:

<!-- Using the UPDATEMETADATA method. -->

<PhysicalTable Id="A53TPPVI.A4000002">
<Columns Function="Append">
<Column Id="A53TPPVI.A500002U" Name="Salary">
<Table>
<PhysicalTable ObjRef="A53TPPVI.A4000002"/>
</Table>
</Column>
</Columns>
</PhysicalTable>

The association to the new Column object is added to the existing association list without affecting other associated objects. Here are the results of a GetMetadata request that lists the Column objects associated with PhysicalTable A53TPPVI.A4000002:

<!-- Using the GETMETADATA method. -->

<PhysicalTable Id="A53TPPVI.A4000002" Name="Sales Associates">
<Columns>
<Column Id="A53TPPVI.A5000005" Name="EmployeeName" Desc="Name of employee"/>
<Column Id="A53TPPVI.A5000006" Name="Address" Desc="Home Address"/>
<Column Id="A53TPPVI.A5000007" Name="Title" Desc="Job grade"/>
<Column Id="A53TPPVI.A500002U" Name="Salary" Desc=""/>
</Columns>
</PhysicalTable>

Top of Page