What is host variable in db2 cobol? 0 Answers what is the maximum number of tables that can be joined ? 8 Answers IBM, TCS, If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do...
like Pro*COBOL, interpret PL/SQL blocks as single, embedded SQL statements. This enables users to place PL/SQL blocks anywhere in a host program where they might normally place an SQL statement. When embedding PL/SQL blocks into host programs, be sure to declare the variables that will be ...
Condition supplement is the group of conditions that should be applied every time a certai condition is found.eg in a material pricing one should enter all the the condition records for all the materials.Now if you wants to add material discount when each time a material pricing is doen you...
Eg for in out parameterBellow the parameter having x (eg x_return_status)as suffix is OUT,p (eg p_calling_fn)as suffix is IN and px (px_trans_rec)as suffix is INOUT.Initializing In parameter is mandatory to get desired output,OUT will be the result of procedure execution and INOUT w...
Parameters which are in calling subprogram are actual parameters. Parameters which are in called subprogram are formal parameters. If any subprogram was called, once the call was completed then the values of formal Related Answered Questions
Executing any RETURN statement completes the subprogram immediately.In procedures, a RETURN statement does not return a value and so cannot contain an expression. The statement returns control to the caller before the end of the procedure.In functions, a RETURN statement must contain an expression,...
When there is PARM passed from JCL, we need Linkage Section in COBOL program even when there is no called program. Was this answer useful? Yes ReplyRishi Sharma Jun 11th, 2014 You can certainly declare the variables in Linkage section even if you are not using them to call any exte...
Function can use in the SQL query while procedure can't thats the major Difference between procedure and functionPackage is the fastest because For standalone function & procedure if you call means each and every time it will complie but for the package once if you complied it means when ...
Subprogram is a named PL/SQL block and will be stored in server. This is avaialble for reference. Procedure can be called from anonymous block and reverse is not possible. Regards,Ravi Was this answer useful? Yes ReplyCulver_lake Mar 28th, 2006 dont confuse subprogram with stored ...
The 2nd parameter is used to return the code of the status of the concurrent programThe possibl;e values are 0 -> successful execution(no error)1 -> completed with warnings2 -> Completed with error Was this answer useful? Yes Reply...