Manipulating Data

Insert

Read the rest of this article »

Introduction

SQL:Structured Query Language

SQL is a standard computer language for accessing and manipulating databases.

SQL commands

• Data retrieval : SELECT
• Data manipulation language(DML) : INSERT, UPDATE, DELETE
• Data definition language(DDL) : CREATE, ALTER, DROP, RENAME, TRUNCATE
• Transaction control : COMMIT, ROLLBACK, SAVEPOINT
• Data control language(DCL) : GRANT, REVOKE

Data retrieval

Selecting Rows

Read the rest of this article »

IBM WebSphere Information Integrator Content Edition installation
     These are required softwares for full IICE installation. Each software would have prerequisite hardware and software requirements, you can see more informations in the links below. The installation procedure might be complete only with corresponding version.

Based Version : DB2 UDB V8.1
Extension : Fixpack 7A

Based Version : WebSphere Business Integration Server Foundation (WBISF) V5.1
Extension : WebSphere Application Server (WAS) Fixpack 1

: WebSphere Business Integration Server Foundation (WBISF) Fixpack 1

Based Version : DB2 Content Manager V8.3

Based Version : WebSphere Information Integrator Content Edition V8.3

Read the rest of this article »