  * configuration was loaded, and when it will be reloaded (with its frequency).
  * In the other result set, it shows the key-values from the configuration, if
  * this was already loaded, otherwise a descriptive message appears.
+ * This procedure shows the configuration, but it does not reload it, for this
+ * reason, the next refresh time could be in the past, because the get_value
+ * is the only one that refreshes the configuration.
  */
 ALTER MODULE LOGGER ADD
   PROCEDURE SHOW_CONF ()

ALTER MODULE LOGGER ADD
  VARIABLE VAL_TRUE ANCHOR LOGDATA.CONFIGURATION.VALUE CONSTANT 'true' @

/**
 * Variable for the last time the configuration was loaded.
 */

    END IF;
   END;
   -- Creates an prepares a dynamic query.
   SET STMT = 'SELECT CASE CACHE WHEN TRUE '
     || 'THEN ''true'' ELSE ''false'' END AS INTERNAL_CACHE_ACTIVATED, '
     || 'LAST_REFRESH AS LAST_REFRESH, '
     || SECS || ' AS FREQUENCY, '
     || 'CASE ' || SECS || ' '
     || 'WHEN -1 THEN ''Not defined'' '
     || 'ELSE CHAR(LAST_REFRESH + ' || SECS || ' SECONDS) '
     || 'END AS NEXT_REFRESH, '
     || '''' || CURRENT TIMESTAMP || ''' AS CURRENT_TIME '
     || 'FROM SYSIBM.SYSDUMMY1';
   PREPARE RS FROM STMT;
   OPEN REF;
