Steps you always need to increase the availability of database. Read more.
Category: DB2 V11
The NVL function returns the first argument that is not null. ==>NVL(expression1, expression2) The arguments…
Tricky interview questions to read for interviews on DB2 cursors.
SELECT -The select-statement is the form of a query that can be directly specified in…
The reverse scan in DB2 also called backward index scan. Reverse Scan The ordering of…
Here is all about REPAIR utility. It fixes data in tables and their related data…
SQL error code -180 reason and quick resolution.
Here is a discussion on DB2 supported data types. Explained each for ready reference. Numeric…
The best DB2 tutorial that covers index, synonyms,alias and DCLGEN. Read more.
Catalog tables listed in this post where you need to look in about remote system details.
Provide a fast, efficient method for locating specific rows of data in very large tables. (In some cases, all the information needed to resolve a query may be found in the index itself, in which case the actual table data does not have to be accessed.)
DB2 tutorial given in the form of questions and answers. So that any mainframe or…
You must be logged in to post a comment.