SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the call to the procedure:
EXEC WsWrkTask @p_job_id, @p_task_id, @p_sequence
, 27, 30, 0, 0, 0, 0, 0
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"EXEC WsWrkTask 1,5,6,28,12,0,0,0,0,0"
The following out is typical:
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call WsWrkTask(62,42,60,28,12,0,0,0,0,0)};