SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the call to the procedure:
EXEC @v_result = WsWrkAudit 'I', @p_job_name, @p_task_name, @p_sequence
, 'This is an Audit Message', NULL, NULL, @p_task_id, @p_job_id
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"EXEC WsWrkAudit 'I','Audit Msg','Audit',1,'The task has started.',NULL,NULL,0,0"
The following out is typical:
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call WsWrkAudit('I','Audit Msg','Audit',1,'This is a Message.',NULL,NULL,0,0)};