Limiting query results in DB2

DB2 provides the FETCH FIRST command to limit query results.

select * from mytable fetch first 10 rows only;

To get the first 10 by column

          
  

DB2 Select

A select statement fetches data from database tables and stores the results in a table called resultset. Your SQL tool displays the contents of the resultset.


DB2 Comments

Comments are text written by developers to leave an explanation in the code. Comments are ignored by the database. DB2 supports two types of comments:

/* */
--

Example

          
  

DB2 Quick Guide

SQL Commands

Comments

/* */
--

Select

select co1, co2 from tbl where fld = 3;

Intelligent Agent

It is difficult to define intelligence. Lets define a few simplified characteristics of an intelligent person

  • an intelligent person realizes the importance of goals

Benefits of visual communication

Among the many extraordinary talents of Charles Dickens was his ability to describe people, places, objects, and situations in a way that allows readers to experience the events he narrated.


Records Management

ISO-15489 defines records management as the "field of management responsible for the efficient and systematic control of the creation, receipt, maintenance, use and disposition of records, including


Tools and techniques to assist in project management

There is no magical tool which could manage a project for you. However, there are many indispensable tools, which assist in project management.


Environment

An environment is the physical or virtual terrain that an agent work in e.g. Mars, chess board, Internet, etc. Complexity of the decision-making process can be affected by the environment.


Agent

An agent is a computer system capable of performing autonomous actions to in a given environment to meet its design objectives.


Artificial Intelligence

Computer systems can only perform actions anticipated, designed and coded by programmers. When a computer encounter an situation it is not programmed to handle, it either hangs or produces an error.


Using Javadoc to create documentation

Programmers often complain about insufficient documentation yet most of use don't take the time to document our code properly.


Advantages and disadvantages of Java

In 1977, DoD launched a project to build the perfect programming language. The project lead to the creation of the most expensive programming language to be ever created, Ada.


Setting up Java EE and Eclipse on Microsoft Windows

Setting up Java EE with Eclipse is pretty simple. Following are the steps:


Java recursion examples

Recursion is when a function calls itself repeatedly. The classical example of recursion the factorial function.

5! = 5 x 4 x 3 x 2 x 1
n! = n * (n-1) * (n-2) * (n-3) * (n-4) * (n-5)