Page History

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9bf47bdbfcef1b3e-7c8cc987-498d42e2-9f7e8d18-bfeb62c82dd6a1bd07d4bc52"><ac:plain-text-body><![CDATA[

@VALUE[<param>]

Replace the tag by
]]></ac:plain-text-body></ac:structured-macro>
Example:? in the statement and set the value of the prepared parameter to the value of the MIB Explorer variable with name <param>.

SELECT ID FROM MXP.MXP_MONITOR WHERE NAME = @VALUE\[NAME\]

will be rendered to

SELECT ID FROM MXP.MXP_MONITOR WHERE NAME = ?

where ? is assigned with the value of the MIB Explorer variable NAME when the statement is being executed.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b27edb20d10c43d2-ba211ef0-473c45d0-83ae9278-155928fefdc01fde8ed32d3a"><ac:plain-text-body><![CDATA[

@INSERT[<param>]

Replace the tag by the value of MIB Explorer variable with name <param>
]]></ac:plain-text-body></ac:structured-macro>
Example:

SELECT ID FROM MXP.MXP_MONITOR WHERE NAME = '@INSERT[NAME]'

will be rendered to

SELECT ID FROM MXP.MXP_MONITOR WHERE NAME = 'MyMonitor'

if the variable NAME has the string value MyMonitor.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ae615a9c6ae89ad2-33c02e4e-4b244154-81d3978b-43a9c0f1bba8b348e7a26192"><ac:plain-text-body><![CDATA[

@USE[<statementName>]

Replace the tag with the rendered content of the statement with name <statementName> of the same context.
]]></ac:plain-text-body></ac:structured-macro>
Example:

<statement name="select.id"> \\
SELECT ID \\
</statement> \\
<statement name="select.monitor.id.by.name"> \\
@USE[select.id] FROM MXP.MXP_MONITOR WHERE NAME = @VALUE[NAME] \\
</statement>

will be rendered to

SELECT ID FROM MXP.MXP_MONITOR WHERE NAME = 'MyMonitor'

if the variable NAME has the string value MyMonitor.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="90af5f974ac391f4-ef424cd1-40b243b1-bcc292b5-f371984fbebe6789b1227548"><ac:plain-text-body><![CDATA[

@IF[<stmt>,<test>,<value>,..]

Replace the tag with the statement with name <stmt> if the condition <test> is true for the MIB Explorer variable references <value1> through <valueN>. The supported tests are listed in table Table 16 on page 144.
]]></ac:plain-text-body></ac:structured-macro>
Example:

<statement name="monitor.dataset.by.id"> \\
SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = @VALUE\[ID\] \\
@IF\[and.nameOrDataType,not-null,NAME,DATATYPE\] \\
ORDER BY MONITOR_ID,DATATYPE \\
</statement> \\
<statement name="and.nameOrDataType"> \\
AND (NAME = @VALUE\[NAME\] OR DATATYPE = @VALUE\[DATATYPE\]) \\
</statement>

will be rendered to

SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = ? AND (NAME = ? OR DATATYPE = ?) ORDER BY MONITOR_ID,DATATYPE

if the MIB Explorer variables NAME and DATATYPE are not null.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ce79c03e6559d48a-b286d7b4-47fd441e-96e5acc5-467b199074732b84d463283c"><ac:plain-text-body><![CDATA[

@IFELSE[<stmtTrue>, <stmtFalse>,<test>, <value>..]

Replace the tag with the statement with name
]]></ac:plain-text-body></ac:structured-macro>
Example: <stmtTrue> if the condition <test> is true for the MIB Explorer variable references <value1> through <valueN>. Otherwise, replace the tag with the statement with name <stmtFalse>. The supported tests are listed in table Table 16 on page 144. <statement
]]></ac:plain-text-body></ac:structured-macro>
Example:

<statement name="monitor.dataset.by.id">

 \\
SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = @VALUE\[ID

\] \\
@IFELSE\[dataTypeNotNull,dataTypeNull,not-null,DATATYPE

\] \\
</statement>

 \\
<statement name="dataTypeNull">

 \\
AND DATATYPE IS NULL

 \\
</statement>

 \\
<statement name="dataTypeNotNull">

 \\
AND DATATYPE IS NOT NULL

 \\
</statement>

will statement>will be rendered toSELECT * FROM to

SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = ? AND DATATYPE IS NOT NULL

if NULLif the MIB Explorer variablesDATATYPE variables DATATYPE is not null. Otherwise, the statement would be rendered as:

SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = ? AND DATATYPE IS NULL