Load utility in DB2, to load bulk data, very popular. The questions given in this post are useful for interviews.
Category: Mainframe DB2
Top five DB2 storage area questions to understand quickly
Mostly asked certification questions in DB2. You need more focus on these areas before you take the test.
You need to know these SQL query and rules to delete a row from a Table in DB2 database
Table spaces are completely logical in any database. Many developers confused that they always access data from physical storage. But actually that is not correct. So this post clarifies how to define a table with logical storage. Sample SQL really helps you to understand quickly.
There are many of the occasions while writing SQL query you will come across this kind of scenario that you need in the result only digits. To achieve this explained with examples of DB2 function DIGITS. This is also called column function.
Query to change Data Type ALTER TABLE BOOKS ALTER BOOKNAME SET DATA TYPE VARCHAR(200) ALTER ISBN…
Today’s post What is stored procedure? How many types of stored procedures? What are those?…
What is Distributed computing? Here DBMS server process the requests send by the client. How…
When performing data modeling in preparation for designing a database, knowing that two entities are…
Here are the details about DB2 packages, and the need to keep multiple versions. The…
I am very cool today reading Db2 magazine. I have got an idea why can’t I…
