what actually done by EXECUTE COMMAND in dynamic sql?
Posted: Tue Dec 14, 2010 7:27 pmfor fetching record by using cursor in dynamic sql sometime we dont need the execute command.why?
IBM Mainframe Forum
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
what actually done by EXECUTE COMMAND in dynamic sql?
Page 1 of 1
Posted: Tue Dec 14, 2010 7:27 pmRe: what actually done by EXECUTE COMMAND in dynamic sql?
Posted: Tue Dec 14, 2010 7:43 pma fetch doesn't need a prepare because it is done during cursor declare/prepare/open
Re: what actually done by EXECUTE COMMAND in dynamic sql?
Posted: Wed Dec 29, 2010 4:50 pmThe SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time. The EXECUTE IMMEDIATE statement must be placed in the PROCEDURE DIVISION.
Re: what actually done by EXECUTE COMMAND in dynamic sql?
Posted: Wed Dec 29, 2010 8:10 pmchandrababun wrote:The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time. The EXECUTE IMMEDIATE statement must be placed in the PROCEDURE DIVISION.
Unless, of course, one is using PL/I, Rexx, C/370, Java, or some language other than COBOL.