How to view db2 table structure?
- 0 Answers
- 772 Views
- I also Faced
- E-Mail Answers
What is a db2 schema?
What is cursor?
What is bind package and plan in db2?
what is a collection?
What are the three DB2 date and time data types and their associated functions?
Explain various types of locks in db2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What does DML stand for and what are some examples of it?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How does DB2 use multiple table indexes?
How Plan is created while executing the query using SPUFI?
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.
COBOL 
