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 13884What 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 18431what 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 8781Suppose 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 6151DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 6037in 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 4749Parm 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 8050Post New IBM DB2 Interview Questions
what are the windows server 2003 keyboard shortcuts? : Windows server 2003
Tell me more about the parameters in macro? : sas-macro
What motivates you the most?
What is the use of settimeout() function in node.js?
What are the three classes of organic solvents?
What is pylintrc?
What is the chromosome number of Ginkgoes?
What the conditional statements used in sapscripts?
A non-function currency claim:- Employee while updating a non functional currency claim the system uses the period end rate i.e. any claim pertaining to the period 01Aug - 25th Aug. the system uses the period end rate as of July 31st. (2) Also, what is the basis of using the period end rate not the average rate for expenses claim. Can you please clarify my question.
How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks
How to find the difference in two configuration files?
How do I register a dll file in windows 7 64 bit?
What is a 'year shift' in sap calendar?
Why are annotations used?
Specify the port number for ftp?