SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the call to the procedure:
EXEC @v_result = WsWrkAuditBulk 'I', @p_job_name, @p_task_name, @p_sequence
, 'Message1~Message2~Message3~', NULL, NULL, @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"EXEC WsWrkAuditBulk 'I','Audit Msg','Audit',1,'Message1~Message2~Message3',NULL,NULL,0,0"
The following out is typical:
(1 rows affected)
(1 rows affected)
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call WsWrkAuditBulk('I','Audit Msg','Audit',1,'Message1~Message2~Message3~',NULL,NULL,0,0)};