SQL Editor with variable substitution in version 0.56 PDF Print E-mail

In the new version 0.56 Caché Monitor execute parameterized SQL queries.

 

For example:

SELECT * FROM CINEMA.Film WHERE CINEMA.Film.Category=$$MyVAR_001$$;

When executing the above query, Caché Monitor will prompt the user for input for the $$MyVAR_001$$ variable. The SQL Editor replace the value of $$MyVAR_001$$ with the value entered by the user. The entered value will be substituted for each occurrence of the variable

 

variable subsitution in sql editor

 

 

On the message panel you find the sql statements send to the database.

variable subsitution in sql editor

 

Change log details of V 0.56:

  • Reformat Code: Upper case keywords
  • reconnect button in query analyzer
    reconnect button
  • sql script execution with variable substitution support
  • better statement finder at cursor position
  • on the message panel the executed statement and execution time is listed
  • rendering of datatypes in table improved, e.g. Time
< Prev   Next >