kgumraj2
New User
Joined: 01 Aug 2007 Posts: 42 Location: Hyderabad
|
|
|
|
Hi,
This is the Main Logic
Code: |
0030-CALL-ST-PROCEDURE.
EXEC SQL
CONNECT TO PHX_DEV
END-EXEC.
EXEC SQL
CALL PHOENIXR.SP_SUB_SELECT
( :WS-SOURCE-NAME,
:WS-DATE,
:WS-RETURN-CODE:WS-NULL-RETURN-CODE,
:WS-ERROR-MESSAGE:WS-NULL-ERROR-MESSAGE
)
END-EXEC. |
here ws-source-name and ws-date we pass through parm
and ws-return code and error message are the variable we get from stored procedure.. |
|