How does db2 sample database connect?
What is check constraint. Explain with example.
List down the data types in the db2 database.
What is sqlca?
What are the different types of base tables?
How are write I/Os from the buffer pool executed?
What is the use of predicate?
what's the error code for Unique Index Violation?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is cobol db2?
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.
Outputs of explain are with matchcols = 0. What does this signify?
Which transaction use a command thread ?