Page History

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1c7b7f62e182d33b-f151f81b-405a4080-a35ea7ab-9c70aa2a7083598d6fb5bacb"><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="527fb052-e8a6-4627-b2d5-405aa7f9a18d"><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="f7d9148c-29da-41d1-9bf3-ba96e7525176"><ac:plain-text-body><![CDATA[

@USE[<statementName>]

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

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 variableNAME variable NAME has the string value MyMonitor.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="49614ceb-4a89-4d43-98c9-e6761ae6ef22"><ac:plain-text-body><![CDATA[

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

Replace the tag with the statement with name
]]></ac:plain-text-body></ac:structured-macro>
Example: <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.

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 DATATYPEif the MIB Explorer variablesNAME variables NAME and DATATYPE are not null.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8ae2cdbb20c6ff86-75685bfa-486a41d0-88d0aad0-65a750f3640be0869efec47e"><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 name="monitor.dataset.by.id">
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f163602ca5418b4f-6081b382-463c4b79-899d80b1-e8c2a49b8d27ec7bd741e90c"><ac:plain-text-body><![CDATA[SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = @VALUE[ID]
]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="46b504ca4fa53ea8-88c0edfd-459d466a-882ea581-c96472be8db4584fe019bf20"><ac:plain-text-body><![CDATA[@IFELSE[dataTypeNotNull,dataTypeNull,not-null,DATATYPE]
]]></ac:plain-text-body></ac:structured-macro>
</statement>
<statement name="dataTypeNull">
AND DATATYPE IS NULL
</statement>
<statement name="dataTypeNotNull">
AND DATATYPE IS NOT NULL
</statement>will be rendered toSELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = ? AND DATATYPE IS NOT NULLif the MIB Explorer variablesDATATYPE is not null. Otherwise, the statement would be rendered as: SELECT * FROM MXP.MXP_MONITORDATASET WHERE MONITOR_ID = ? AND DATATYPE IS NULL