We can execute procedure in Teradata as shown below:-
CALL PROCEDURE PROCEDURE_NAME;
If you have procedure called PROC_UPSERT then:-
CALL PROCEDURE PROC_UPSERT;
If your procedure is parameterize then:-
CALL PROCEDURE PROCEDURE_NAME(PARAMETER (S)) ;
CALL PROCEDURE PROCEDURE_NAME;
If you have procedure called PROC_UPSERT then:-
CALL PROCEDURE PROC_UPSERT;
If your procedure is parameterize then:-
CALL PROCEDURE PROCEDURE_NAME(PARAMETER (S)) ;
No comments:
Post a Comment