In some situations, you may need to clear the file content without deleting the file. This post, I show you how to do this in Linux using a single command: http://www.technicaladvices.com/2012/10/11/clear-the-file-content-without-deletion-in-linux/

Tags:  content clear delete cat linux file /dev/null

Sometimes, you may need to get the current stamp of the database server if you need for example to calculate the difference between the entry creation time and the current time. In this post, I show you how to do this: http://www.technicaladvices.com/2012/09/25/db2-getting-the-current-database-server-timestamp/

Tags:  current timestamp server sysibm sysdummy1 db2 database

In this post, I show you how to get the db2text indexes information in your current DB2 database: http://www.technicaladvices.com/2012/09/16/getting-the-db2text-indexes-information-in-db2-9-x/

Tags:  text indexes search db2ext.textindexes db2text

You may face this problem when you try to run the JsTestDriver (JSTD) tests. In this post, I show you how to solve this error: http://www.technicaladvices.com/2012/09/13/java-lang-runtimeexception-oh-snap-no-server-defined/

Tags:  unittesting directive --config running java.lang.runtimeexceptio... no test server javascript jstestdriver jstestdriver.conf defined! oh jstestdriver.jar snap!

A very common requirement is to have pagination on the level of the database especially if your query result returns thousands of database records. In this post, I show you how to make database pagination in DB2: http://www.technicaladvices.com/2012/09/03/db2-pagination-for-large-data-volumes/

Tags:  row_number large template data query pagination db2 volume