• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

Hazem Saleh

  • Log in to participate

About this blog

Technical Blog about common technical issues
  • Facebook
  • Twitter
  • Google
  • LinkedIn
  • RSS

Archive

  • May 2016
  • August 2015
  • April 2015
  • January 2015
  • November 2014
  • May 2014
  • April 2014
  • March 2014
  • January 2014
  • September 2013
  • August 2013
  • July 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009

Tags

Posts by date
  • Sort by:
  • Date
  • Title
  • Likes ▼
  • Comments
  • Views

Creating DB2 Stored Procedure from the command line

Hazem Saleh (IBM) 2700027XCV | | Visits (17017)

Tweet
In this post, I show you how to create stored procedures in DB2 from the command line prompt: http://www.technicaladvices.com/2012/10/02/creating-db2-stored-procedure-from-the-command-line/

Tags:  sql procedure stored -td@ -svf db2 install script

[Linux] Clearing the file content without deleting it

Hazem Saleh (IBM) 2700027XCV | | Visits (4707)

Tweet
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

Hazem Saleh (IBM) 2700027XCV | | Visits (5901)

Tweet
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

Hazem Saleh (IBM) 2700027XCV | | Visits (4069)

Tweet
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

java.lang.RuntimeException: Oh Snap! No server defined!

Hazem Saleh (IBM) 2700027XCV | | Visits (6316)

Tweet
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

Hazem Saleh (IBM) 2700027XCV | | Visits (5382)

Tweet
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
  • Show:
  • 10
  • 20
  • 30
  • Previous
  • Next
1