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 handling of NULLs is must do activity when aggregate functions are used in SQL. There are the cases when no data is found in table, that time DB2 sends NULL indicator. The COBOL program must handle it, else you will get -305 SQL error code.
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.
In DB2-COBOL program, you can write simple SQL queries to complex SQL queries that depending on the project. Almost all data intensive projects writing SQL
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.