DB2 Examples:
1. DB2 example of a call from a Stored Procedure:
Add the call to the procedure:
CALL [METABASE].WsWrkTask(p_job_id, p_task_id, p_sequence
, 27, 30, 0, 0, 0, 0, 0);
2. DB2 example of a call from the DB2 Command Line Processor (db2.exe):
Enter the following after connecting (the metadata is in a schema called QAD Data Warehouse Designer):
call Data Warehouse Designer.WsWrkTask(62,42,60,28,12,0,0,0,0,0)
The following out is typical:
Return Status = 0
3. DB2 example of a call from QAD SQL Admin (the metadata is in a schema called QAD Data Warehouse Designer):
{Call Data Warehouse Designer.WsWrkTask(62,42,60,28,12,0,0,0,0,0)}