Data Integration

is there a command or file that indicates the refresh loader path for an instance  without shutting down the instance ?

if the instance is down we can use dmconfigurets - edit instance - refresh loader path   and we prompted with the current path

can it be retrieved from pointbase db : table ?

Hello Guy

The undocumented dmmdcommander command can be used to open a read-only connection to the metadata database. dmmdcommander -I <instance>

This opens a CLI in which you can run SQL select commands and some other commands to set some options.

All commands are terminated with a semi-colon ;

The command help; displays basic information

The structure of the database is liable to change between different builds, but the following has been valid for all the Java-based CDC instances AFAIK, apart from the schema which also changes between various builds.

In the CLI enter the following commands

show system;    -- note the schema name (e.g. V244)

set screenwidth 300;

select name, value from V244.PROPERTIES;  - this will display the properties of the instance including the refresh loader path

exit;

The command dmmdconsole -I <instance name> will display a GUI interface to the database, on Windows or *nix systems with a suitable graphical environment

Regards

Robert

You can try this command:

echo "SET SCREENWIDTH 300; SELECT NAME,VALUE FROM $(echo "SELECT SCHEMANAME FROM POINTBASE.SYSSCHEMATA WHERE SCHEMANAME LIKE  'V%';" |  ./dmmdcommander -I <instance_name> | grep V2).PROPERTIES;" | ./dmmdcommander -I <instance_name>

many thanks - this is giving what we need .....