Executing Stored Procedures

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.


Top of page

x
Syntax: How to Execute a Stored Procedure Using Distributed Execution

You can execute stored procedures by issuing the command:

SQL EDA EX rpcnameparm1, parm2, ...
END

where:

rpcname

Is a procedure on the server.

parm1, parm2,...

Are character strings sent to the server (they are the same as parameters you can pass on the execution line of a FOCEXEC).


Top of page

x
Syntax: How to Query Adapter Settings

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

WebFOCUS