Creating DB2 Stored Procedure from the command line |
[Linux] Clearing the file content without deleting it
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 |
DB2 Getting the current database server timestamp
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 |
Getting the db2text indexes information in DB2 9.x |
java.lang.RuntimeException: Oh Snap! No server defined!
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! |
DB2 pagination for large data volumes
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 |