Interested to Buy Any Domain ? << Click Here >> for more details...
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
- 1 Answers
- 3672 Views
- Danske, I also Faced
- E-Mail Answers
Which component is responsible for db2 startup and shutdown?
What are the various data types available in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is the difference between plan and package in db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
How does DB2 use multiple table indexes?
What is the clustering index in the db2 database?
What is the difference between TYPE 1 index & TYPE 2 index
COBOL 
