SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the call to the procedure:
EXEC @v_result = WsWrkErrorBulk 'I', @p_job_name, @p_task_name, @p_sequence
, 'MessageW1~MessageW2~MessageW3~', NULL, NULL, @p_job_id, @p_task_id, NULL
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"EXEC WsWrkErrorBulk 'I','Error Msg','Error',1,'Message1~Message2~Message3',NULL,NULL,0,0,NULL"
The following out is typical:
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call WsWrkErrorBulk('I','Error Msg','Error',1,'Message1~Message2~Message3~',NULL,NULL,0,0,NULL)};