Modifies the SQL script that is submitted by using a data change ticket.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes ModifyDataCorrectExecSQL

The operation that you want to perform. Set the value to ModifyDataCorrectExecSQL.

OrderId Long Yes 4328****

The ID of the data change ticket.

ExecSQL String Yes update tb set id = 1 where id = 1;

The new SQL script.

Tid Long No 4****

The ID of the tenant. You can call the GetUserActiveTenant operation to query the tenant ID.

RegionId String No cn-hangzhou

The region in which DMS is activated. For more information, see RegionID parameter.

Response parameters

Parameter Type Example Description
RequestId String 0C1CB646-1DE4-4AD0-B4A4-7D47DD52****

The ID of the request.

Success Boolean true

Indicates whether the request was successful. Valid values:

  • true: The request was successful.
  • false: The request failed.
ErrorMessage String Specified parameter OrderId is not valid.

The error message returned.

ErrorCode String InvalidOrderId

The error code returned.

Examples

Sample requests

http(s)://dms-enterprise.aliyuncs.com/?Action=ModifyDataCorrectExecSQL
&OrderId=4328****
&ExecSQL=update tb set id = 1 where id = 1;
&Tid=4****
&Common request parameters

Sample success responses

XML format 

HTTP/1.1 200 OK
Content-Type:application/xml

<ModifyDataCorrectExecSQLResponse>
    <RequestId>0C1CB646-1DE4-4AD0-B4A4-7D47DD52****</RequestId>
    <Success>true</Success>
</ModifyDataCorrectExecSQLResponse>

JSON format 

HTTP/1.1 200 OK
Content-Type:application/json

{
  "RequestId" : "0C1CB646-1DE4-4AD0-B4A4-7D47DD52****",
  "Success" : true
}

Error codes

For a list of error codes, visit the API Error Center.