Caché Monitor 0.57 is a minor update version. In this version the variable substitution in SQL scripts supports setting a default value.

Variables are used to build parameterized SQL statements whereas the values are prompted by Caché Monitor when the SQL is executed.

The new version is in download section.

Variable Syntax

$$ VarName [ || VarValue] $$

• VarName = Required. The variable name appears in the substitution dialog. The entered value will be applied to all variables of that name.
• VarValue = Optional. The default value that appears in the substitution dialog.

The variable format supports setting a default value as in the following examples:

SELECT *
FROM CINEMA.Film
WHERE CINEMA.Film.Category = $$MyVAR_002||4$$;

SELECT *
FROM CINEMA.FilmCategory
WHERE CINEMA.FilmCategory.CategoryName = $$MyVAR_003||'Action'$$;

Change log of V 0.57:

• After reconnect in query analyzer, the new pid is updated and displayed in titlebar
• SQL script execution with variable substitution supports the definition of default values