How do I connect my db2 database to ibm?
- 0 Answers
- 805 Views
- I also Faced
- E-Mail Answers
What is Reorg Recovery? when will you run it?
How do I delete a column in db2?
Mention the different locking levels that are available in db2.
What is load replace in db2?
How do you run JCL in cobol program
Is schema the same as database?
What are foreign keys in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How to fetch the last row from the table in SQL (db2)?
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 use of reorg in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
COBOL 
