Hi! newbie here in Teradata. How can I call and use a stored procedure inside another stored procedure??

Database
yam
Teradata Employee

Hi! newbie here in Teradata. How can I call and use a stored procedure inside another stored procedure??

Here's my sample query.

CREATE PROCEDURE sp2(OUT z INT)

BEGIN

BEGIN 

CALL sp1(110,y);

END;

SELECT employeeid INTO z FROM employees

WHERE firstname=y;

END ;