Call Statement—Call an Ingres Tool or Operating System
The embedded SQL and OpenSQL call statement enables your applications to call an Ingres tool (such as QBF) or the operating system.
The syntax to call an Ingres tool is as follows:
exec sql call subsystem (database = dbname {, parameter = value});
The syntax to call the operating system is as follows:
exec sql call system (command = command_string);
The value for a particular parameter can be specified with or without quotes or within a string variable. If there is no value for a particular parameter name, specify an empty, quoted string.
Examples
Following are sample calls to Ingres tools from embedded SQL and OpenSQL:
exec sql call qbf (database = 'empdb',
table = 'employee');
exec sql call rbf (database = 'empdb',
flags = '-s -mblock emptable');
exec sql call report (database = :dbvar,
name = :namevar, mode = :modevar);
exec sql call system (command = 'mail');
In the third example, dbvar, namevar, and modevar are host language string variables.