DBE_SQL_UTIL.create_hint_sql_patch
create_hint_sql_patch creates hint SQL patches on the connected CN and returns whether the execution is successful.
Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.
- SQL patches are not shared among CNs and need to be created on each CN.
- If load balancing is enabled or a CN needs to be specified, you are advised to use the DBE_SQL_UTIL.create_remote_hint_sql_patch API to create a CN.
Parameter |
Type |
Description |
---|---|---|
patch_name |
IN name |
Patch name. |
unique_sql_id |
IN bigint |
Global unique query ID. |
hint_string |
IN text |
Hint text. |
description |
IN text |
Patch description. The default value is NULL. |
enabled |
IN bool |
Specifies whether the patch takes effect. The default value is true. |
result |
OUT bool |
Specifies whether this operation is successful. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot