How to: |
In addition to making data available to the client, a server can store procedures, which are called remote procedures or stored procedures.
The CREATE SYNONYM (and/or DROP SYNONYM) command can be executed using a stored procedure on either the Hub or Full-Function Server.
You can execute stored procedures by issuing the command:
SQL EDA EX rpcnameparm1, parm2, ... END
where:
Is a procedure on the server.
Are character strings sent to the server (they are the same as parameters you can pass on the execution line of a FOCEXEC).
To view the adapter parameter settings, issue the command:
SQL EDA ?
The output is:
> sql eda ? (FOC1450) CURRENT EDA INTERFACE SETTINGS ARE : (FOC1446) DEFAULT DBSPACE IS - : IBIEDA (FOC1449) CURRENT SQLID IS - : USER1 (FOC1444) AUTOCLOSE OPTION IS - : ON FIN (FOC1496) AUTODISCONNECT OPTION IS - : ON FIN (FOC1499) AUTOCOMMIT OPTION IS - : ON COMMAND (FOC1441) WRITE FUNCTIONALITY IS - : OFF (FOC1445) OPTIMIZATION OPTION IS - : ON (FOC1484) SQL ERROR MESSAGE TYPE IS - : DBMS (FOC1552) INTERFACE DEFAULT DATE TYPE - : NEW
iWay Software |