I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?
No Answer is Posted For this Question
Be the First to Post Answer
What does runstats do in db2?
How do you select a row using indexes in db2?
What is the command used by TSO users to invoke DB2?
What is the difference between TYPE 1 index & TYPE 2 index
How many sub queries can you combine together ?
How many buffer pools are there in DB2?
How can the duplicate values be eliminated from db2 select?
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 is dclgen (declaration generator)?
define clustering index.
what is dynamic cursor?gives syntax for this?
Name some fields from SQLCA