what is the certification that has a good value for a
practioner in mainframes but not habving much knowledge on
db2 related stuff?
Answers were Sorted based on User's Feedback
Answer / mangesh
Db2 700/703 certificatioin , for more details go on IBM site
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santy
DB2 730/733 certification which are base on the advance DB2
version 9.
730 is the DB2 family fundamental certification whihc
mostly inculeds fundatmental concepts of DB2.
and 733 is the IBM DB2 DEVERLOPER certification.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a Database Request Module(DBRM)?
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.
How can you quickly find out the # of rows updated after an update statement?
Can one database have multiple instances?
how to take the back up of the DB2 table.
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What does runstats do in db2?
Explain correlated sub-queries.
Can we delete records from view?
What is the advantage in De-normalizing tables in DB2?
What is host variable?
When can an insert of a new primary key value threaten referential integrity?