IBM PureData System for Analytics, Version 7.1

Call or invoke a stored procedure

To invoke or execute the sample stored procedure customer(), you can use any of the following SQL query forms:
TEST.TESTSCH(USR)=> CALL customer(); 
TEST.TESTSCH(USR)=> EXEC customer();
TEST.TESTSCH(USR)=> EXECUTE customer();
TEST.TESTSCH(USR)=> EXECUTE PROCEDURE customer();
TEST.TESTSCH(USR)=> SELECT customer();
Any of these commands cause the procedure to output the following:
NOTICE:  The customer name is alpha
 CUSTOMER
----------

(1 row)


Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28