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 14162What 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 18597what 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 8992Suppose 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 6256DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 6100in 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 4820Parm 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 8176Post New IBM DB2 Interview Questions
why diodes are not operated in the breakdown region in rectifiers?
different type of cursor?
Mention what are the different layers in r/3 system?
What is protected in oop?
What is meant by UGAI Collection?
What is the first line in a shell script?
What is progress actional?
Why did you choose to work with ibm mainframe cobol programming?
What you know in mapping of erd to dfd?
If concern supply garments from outside purchase to movie producer for their production then is it maintain Service Tax if yes then how and at first what steps I have to take?
Does node.js run on windows? Yes!
What is the advantages of using c band for satellite communication?
Must I use multiple devices to take advantage of partitions in sybase?
Describe microsoft power bi and its features?
explain the methodologies / ways to create the test cases for QA