DB2 Group By and Order By Clauses

ORDER BY DB2 Order by clause is used to sort the result table values by the sort Key order. Here, sort key can be the column name or column number. Results can be sorted either by Ascending (ASC) or by Descending (DESC) order. ASC is the default order by clause. If you do not specify

DB2 Isolation Level details

In DB2 or in any Relational databases, the concurrency & data integrity is the key factor. Concurrency is the feature that makes multiple applications or users to access the resources at the same time without affecting each other’s work. Concurrency control is important as without the proper concurrency the applications may end with an invalid

DB2 Locks and Importance of Concurrency Control

Locks & Concurrency: Concurrency is the feature that makes multiple applications or users to access the resources at the same time without affecting each other’s work. It makes the applications/users to share the resources interactively at the same time by using the locking concept. Concurrency control is important as without the proper concurrency the applications

jQuery Code: show character count in text area when user enters the text

Here is the jQuery code to show the character count when the user enters the text in the text area or any input control, it will show the remaining character count as user enters the text in the field. See the live demo here and view the source if you’d like. jQuery Code add the

cobol redefines clause with examples

This topic covers the redefines clause usage, syntax, declaring and valid & Invalid redefines cases. Redefines clause is used to share the common storage among the different data items/groups. This is useful to optimize the usage of working storage area. 1. This can be used at 01 level as well. Ex: 01 VAR-1 PIC X(10)

jQuery Datepicker: How to Mark the Holidays on Calendar

Jquery UI has a fully-featured and highly customizable date picker control that let us create and customize the control based on our requirements. To create a basic date control, you just need to call the below single line of code [crayon-56ba84d0d4de1112793707/] input field: [crayon-56ba84d0d4de8924856920/] The Date Picker will appears when textbox has the focus, and

Best Free Online Image Editors

Here are the list of free online image editors, these tools will give you the flexibility to do quick changes to your photos or images online for free. Aviary Phoenix Aviary Phoenix photo editing tool has layers, channels, levels, hue and all other features that you would expect from the Photoshop like application. It Allows

jQuery Code to Display Top News using YQL JSONP API Service

Many sites provide JSONP services, allowing you access to their content via a predefined API. Great source of JSONP-formatted data is the Yahoo Query Language. Below example, we’ll use YQL JSONP API service to populate the top news from yahoo rss and display on the web page. [crayon-56ba84d0d53ad016582928/] You can use the above code to

Javascript Code to Scrolling Page Title

Here I am going to share the Javascript code for scrolling the page title of any web page. You can change the page title by simply set document title property using javascript [crayon-56ba84d0d557e242187662/] Scrolling Page Title Code [crayon-56ba84d0d5585788070213/] You can change the scroll speed by changing the value of variable “speed”. Above it is 150,

jQuery Code to Show Time in Different Countries

This post has jQuery code to show the time in different time zones using jclock plugin. You can use this code to display world clock. Here, I am displaying country names in dropdown, when you click on that it will show the current time in that country. See the live demo here. We have used
Bitnami