update_qr_definition

This command updates an existing query rewrite definition.

This API is available in Guardium V10.1.4 and later.

REST API syntax

This API is available as a REST service with the PUT method. Call this API as follows: 
PUT https://[Guardium hostname or IP address]:8443/restAPI/qr_definition

GuardAPI syntax

update_qr_definition parameter=value

Parameters

Parameter Value type Description
dataBaseType String Required. The type of database this query rewrite definition is associated with. For valid values, call update_qr_definition from the command line with --help=true.
definitionName String Required. A unique name for this query rewrite definition condition.
description String Textual description
isNegateQrCond Boolean Specify if there is a NOT flag on the set of query rewrite conditions that are associated with this definition. Valid values:
  • 0 (false)
  • 1 (true)
newName String Specifies a new unique name.
sampleSql String Specifies a sample SQL statement. In most cases, you will not use this unless you want to use the inputted sample SQL later in the UI.

Examples

grdapi update_qr_definition dataBaseType="DB2" definitionName="case 15" sampleSql="select EMPNO from EMP where ENAME = (select ENAME from EMP where SAL = (select SAL from EMP where HIREDATE = to_date('06/09/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS')))" newName="DB2_case 15"