Is there a way to call an external program from EDB much like SQL Server's exec() command?

diablo908

Yes. You create an external module. EDB calls this module and can then run any program you wish or call any programming you choose to write in the external module.

For example I have a function:

CREATE FUNCTION "NextCloudUID" ()
RETURNS INTEGER
EXTERNAL NAME "UIDModule"

UIDModule is a DLL I have compiled. It calls a Unique ID from an Amazon Cloud server, so I can be sure that any user of the program has an ID in a specific range.

I can them call the NextCloudUID function in any EDB SQL statement or script, which immediately runs the UIDModule.

There is a technical article:
http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=External_Modules

Also there is a news group "EDB Extensions" specific to this area.