Interested to Buy Any Domain ? << Click Here >> for more details...
Once you create a view, where would information about the
view be stored?
- 1 Answers
- 4987 Views
- I also Faced
- E-Mail Answers
Normalization in DB2 – first normal form, second normal form
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How are write I/Os from the buffer pool executed?
What is isolation level in 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.
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is package versioning? Please give an example.
How do you do the EXPLAIN of a dynamic SQL statement?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What information is contained in a SYSCOPY entry?
How can you quickly find out the # of rows updated after an update statement?
What is the significance of DB2 free space and what parameters control it?
COBOL 
