Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answers were Sorted based on User's Feedback
Answer / abhisek
No,it is not mandatory to use DCLGEN,it is used by the pre-
compiler to validate the table names,view names and column
names during pre-compile.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / guest
Just an addition to the above answer. By using the DCLGEN,
the program would use correct data types and column lengths
which avoids stage 2 processing of predicates, if the data
types and lengths mismatched.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is runstats utility in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the purpose of rollback and commit?
How can you count the number of rows from a table tab?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What can the Locate option of the Repair Utility accomplish?
Return code 100 means?
What is the difference between static and dynamic SQL?
What is an asychronous write?
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
how can i pull up a query which was previously stored in qmf
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?