How to execute stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
Why do we need reorg in db2?
What is a synonym? How is it used?
Comment whether the cursor is closed during commit or not.
select 100 records from million records ?
How does DB2 use multiple table indexes?
what is the role of the cursor in db2?
What do you mean by rollback?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
how to take the back up of the DB2 table.