Interested to Buy Any Domain ? << Click Here >> for more details...
Is it mandatory to use DCLGEN? If not, why would you use it
at all?
- 2 Answers
- 8992 Views
- I also Faced
- E-Mail Answers
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 |
Do we need cursor for Count(*)?
How is a typical DB2 batch program executed ?
how will you retrieve first record in table
What is a db2 package?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is EXPLAIN?
Mention the various locks that are available in db2.
How can you quickly find out the number of rows updated after an update statement?
What is the difference between bind and rebind in db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What's The Percentage Free Space ?
Which component is responsible for db2 startup and shutdown?
COBOL 
