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 |
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
how to unload different table data into different gdg files/ vsam files.
What is difference between *omit and *nopass?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
How to see the structure of db2 table??
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What type of database is db2?
How does DB2 use multiple table indexes?
What are the full forms of spufi and dclgen and why are they used?
What is buffrpool? Where we use it ?
Explain about dbrm.
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?