i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 14382What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
3 18734what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
4 9189Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
1 6339DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 6178in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
1 4904Parm 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.
3 8291Post New IBM DB2 Interview Questions
What is a component angular?
How does s/4hana relate to simple finance driven by sap hana?
What is json rpa java?
Where & How Do You Code Identifier In Jcl?
What are the predefined functions in javascript?
What do you mean by the term 'loan'?
What is meant by soap message?
Is it possible to measure correct value of earth resistance & cable insulation ristance with out disconncting earth lead & both sides of cable ends? If not, any other method to measure ER & CIR with out disconneting from the system.
Is there anybody who knows how to create a palindrome program without using string functions just conditional statements?
What is the difference between call template and apply template?
can you explain the dealer management in the auto mobile industry
Is a class an object?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What is a Built_in subprogram ?
Is mvc a layered architecture?