What is Declaration Generator(DCLGEN)?
Answer / ms. stanley
DCLGEN, as it is called, Contains the table Description and
the Field Names for the program to access the DB2 table
| Is This Answer Correct ? | 2 Yes | 0 No |
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
how to check the table is empty or not?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
wht displays the number of times a query modified ?
Where do you specify them?
What is reorg and runstats in db2?
Are views updatable ?
If I have a view which is a join of two or more tables, can this view be updateable?
What if we fail to give values in columns declared as NOT NULL ?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
what is consistency token
What are the advantages of using a PACKAGE?