SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the following to the declaration section of the stored procedure:
DECLARE @v_source_name varchar(64)
Then add the call to the procedure:
SELECT @v_source_name = dbo.WsParameterReadG('$$SOURCE_TABLE', @p_job_id, @p_task_id)
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"SELECT CAST(dbo.WsParameterReadG('$$SOURCE_TABLE',1,5) AS CHAR(30))"
The following out is typical:
------------------------------
load_customer
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
SELECT dbo.WsParameterReadG('$$TABLE_NAME',1,5);