the dd name for ksds is dest1 and what is the dd name for
alternate index of ksds ?
a.dest b.dest1 c.dest1a d.dd1
Answers were Sorted based on User's Feedback
what is differnece between DROP TABLE & DELETE TABLE .
what is plan? is plan executable or package?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is ALTER ?
What is the difference between Where and Having Clause
Can we update view in db2?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is dbrm?
What is subquery ?
Q4. How will you get the count of record without using COUNT verb in query?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is the difference between primary key & unique index ?