updateSqlTable
Update the definition of a SQL Table resource.
Location
/services/webservices/system/admin/resource/operations/
Request Elements
path: A fully qualified path to the resource.
• detail: The level of detail about the resources to include in the response. Valid values are NONE, SIMPLE, and FULL.
sqlText: The SQL source text.
sqlModel (optional): A model for the display of the SQL. If this element is not provided, the model is cleared.
• version: Version of the SQL model.
• type: SQL model type.
• proprietaryModel (optional)
isExplicitDesign (optional): TRUE if the parameters were provided by the resource designer; FALSE if they were derived from the resource.
columns (optional): The column definitions of the table. This element is ignored (even if provided) unless isExplicitDesign is present and TRUE. See
Column Element.
annotation (optional): A description of the resource. If not provided, the annotation is left unaltered.
attributes (optional): List of resource-specific attributes. Sets the specified attributes but does not alter the values of unspecified attributes. See
Attributes Element.
Response Elements
resources: List of the updated resources. See
Resources Element.
Faults
IllegalArgument: If the path is malformed, or the detail or attributes are illegal.
NotFound: If the resource or any portion of path does not exist.
Security: If the user does not have READ access on all items in path other than the last one.
Security: If the user does not have WRITE access to the last item in path.
Security: If the user does not have the ACCESS_TOOLS right.