Examples of Parameter Values

Example 1 is an example of a parameters grid specification that sends data from an input link to the stored procedure:

Table 1. Example 1
Parameter name	Maps to Column	Parameter marker/literal	Parameter Type
EMPNOP	EMPNO	?	Input
JOBP	JOB	?	Input/Output
DEPTNOP	DEPTNO	99	Input
ENAMEP	ENAME	#ename#	Input

In Example 1, 99 is a literal, and #ename# is a job parameter.

Example 2 is an example of a parameters grid specification that sends and returns data from a stored procedure and initiates the execution of a function. It works this way because one and only one Parameter Type is Function:

Table 2. Example 2
Parameter name	Maps to Column	Parameter marker/literal	Parameter Type
FUNCSTATP	FUNCSTAT	?	Function
DNAMEP	DNAME	?	Output
LOCP	LOC	#city#	Input