Answers were Sorted based on User's Feedback
Answer / rahul nittala
The precompiler does a series of operations in the
1) Identifies all the INCLUDE statements and expands them.
2) Syntax check of sql variables against the DCLGEN table
3) seperating the cobol and db2 lines and moving the db2
lines into the respective dbrm.
4) Attaching a consistency token for each set of db2 and
cobol components to be identified at a later stage.
|Is This Answer Correct ?||25 Yes||0 No|
Answer / guest
the process of precompiler is separate tha cobol,db2 staments.
|Is This Answer Correct ?||7 Yes||1 No|
What is Declaration Generator(DCLGEN)?
why we go for SPUFI for creating tables or for sql queries?
how can i pull up a query which was previously stored in qmf
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 is the maximum size of a char data type in db2?
Write a query to retrive partial string.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I optimize a query in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is db2 look?
What is a trigger in the db2 database?
How do you retrieve the data from a nullable column?