UD6 Commands from SQL Workbench

The Uniface SQL workbench or the 'sql' proc statement can be used to dynamically alter the state of the driver (e.g. to remove a file lock).

The following table lists common UD6 commands that can be used from the SQL workbench.

OptionPossible
values
Description
CLEANMMFDEBUG, HARDThis command forces the driver to release all cached open file handles. SCM tools like PVCS require that a file not be open, even for READ-ONLY access before they can be checked back in. Use this command from the SQL workbench with the data path set to UD6 to release these open files.

If you have just made changes to a component, and want the file ‘unlocked’, the correct sequence should be:

  1. close current component
  2. open another component
  3. open SQL workbench and set path to UD6 and enter the SQL/DML command CLEANMMF and press the 'SQL' button.

Alternatively the command CLEANMMF HARD can be used to force open files closed. The CLEANMMF DEBUG command places a detailed list of the action taken in the message frame.


RELOAD LIST This command is only intended to be used from the SQL workbench or the sql "reload list","$ud6" proc statement.

This command forces the driver to reload the list of currently renamed files (useful for when a configuration manager is being used to specify that a file is ‘checked out’).


FONTMAP This command forces the driver to reload the default font mapping from the nls0 configuration file.

This command is only intended to be used from the SQL workbench or the sql "fontmap","$ud6" proc statement.

 

$Revision: 1.11 $ $Date: 2011/02/28 02:56:33 $[go to top]