The substring is very important and mostly used function. You can get part of string from main string. This example gives you clear idea on how to use it especially in DB2.
DB2 version10 provides an individual package option for managing concurrency access within applications in 3 ways.
This post tells about very simple idea for DB2 developers about the concept of external stored procedures, how to create and how to run these stored procedures. The stored procedures can be written in any supported language.
The database consistency is very important to get up to date information. In DB2 database why data consistency is necessary and best explained with example when it is needed. Committing the data is a main task in data consistency.
Process you need to analyze SQL query to improve performance.
In DB2 Date , time and timestamp are three different columns in a table. So this post gives the best idea on how to choose these columns in Table to suit project requirements as well as better performance.
You are really serious about DB2 certification. Then these 5 sample Questions asked on Tables really boost your knowledge. You can practice these kind of questions for sure success in certification exams.
A schema in DB2 is a logical grouping of database objects. It also is used for name qualifiers, which help naturally organize database objects by their name.