SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the following to the declaration section of the stored procedure:
DECLARE @v_result varchar(256)
Then add the call to the Procedure:
EXEC Ws_Api_Glossary 'Data Warehouse', 'Overview', 'A repository of business information', 'ADD', @v_result OUTPUT
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"DECLARE @res varchar(50); EXEC Ws_Api_Glossary 'Data Warehouse','Overview','A repository of business information','ADD',@res OUTPUT; SELECT @res"
The following out is typical:
--------------------------------------------------
Data Warehouse element inserted
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call Ws_Api_Glossary('Data Warehouse','Overview','A repository of business information','ADD',?)};