What are foreign keys in db2?
No Answer is Posted For this Question
Be the First to Post Answer
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
Define predicate?
What is cascading rollback?
How and when does the db2 enforces the unique key?
What is SPUFI?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What is a thread?
How could one combine a set of incremental image copies into a single copy?
What is db2? Explain.
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.
What happens in bind step in a db2 program?
What is the use of db2 optimizer?