Common DB2 SQLCODE

SQLCODE	Description
-301	THE VALUE OF INPUT HOST VARIABLE OR PARAMETER NUMBER position-number CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE
-302	THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE
-440	THE NUMBER OF PARAMETERS IN THE PARAMETER LIST DOES NOT MATCH THE NUMBER OF PARAMETERS EXPECTED FOR STORED PROCEDURE name, AUTHID authid, LUNAME luname. number PARAMETERS WERE EXPECTED.
-551	auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name

Complete list: http://www.caliberdt.com/tips/sqlcode.htm

Getting started with Ant

A(nother) N(eat) T(ool)

What is Apache Ant?
http://ant.apache.org/

Download bin:
http://ant.apache.org/bindownload.cgi

Getting started with Maven

Apache Maven is a software project management and comprehension tool. Based on the concept of a project object model (POM), Maven can manage a project's build, reporting and documentation from a central piece of information.

Download and extract bin from http://maven.apache.org/download.html

Basics:
http://maven.apache.org/guides/getting-started/maven-in-five-minutes.html

To install a package into your local repository:
1) Open <MAVEN_HOME>/conf/settings.xml
2) Set the local repository
<localRepository>S:/bel/repo</localRepository>
3) Set profile
4) Set what profile to activate
5) Set proxy (optional?)
6) Run mvn install (if variables are needed, add -D{varname}={varValue}). To skip test add <skipTests>true</skipTests> on pom.xml (inside properties tag). To set a default/permanent variable, set it in MAVEN_OPTS environment variable

How to set MAVEN_OPTS
-> set MAVEN_OPTS=-Xmx512M -XX:MaxPermSize=128M
-> add in mvn.bat
1) edit <MAVEN_HOME>/bin/mvn.bat
2) add SET MAVEN_OPTS=-Dmaven.test.skip=true

Note:
- dependencies -> mvn install copies all libraries first from WEB-INF/lib to the snapshot lib before downloading all dependencies declared in pom into the snapshot lib. so make sure to always clean up WEB-INF/lib first before executing mvn install to remove any conflicting jars

Source: http://maven.apache.org/

Getting started with Weblogic

Download: http://www.oracle.com/technetwork/middleware/weblogic/overview/index.html

Object Oriented Javascript

Object Constructor

function Cat(name) {
  this.name = name;
  this.talk = function() {
     alert( this.name + " say meeow!" )
  }
}

Creating Objects

• using constructor of defined object
  

  myCat = new Cat("Kuting");
  

• using new Object()
  

  person = new Object()
  person.name = "Bel"
  person.run = function() {
    this.state = "running"
    alert( this.name + " is running!" )
  }

• using literal notation
  

  person = {
     name : "Bel",
     siblings : ["Ana", "Marie"],
     run : function(){this.state = "running"; alert( this.name + " is running!" )}
  };

Prototyping - attaching a method to an object

Cat.prototype.changeName = function(name) {
   this.name = name;
}

References:
http://www.javascriptkit.com/javatutors/oopjs.shtml

Javascipt Basics

javascript

Getting started with Ext JS

Ext JS is a client-side, JavaScript framework for building web applications.

1. Download most current Ext JS release
   - http://www.sencha.com/products/js/download.php
2. Set the URL of s.gif
   

   Ext.BLANK_IMAGE_URL = '/images/ext/resources/images/default/s.gif';

Reference:
http://www.sencha.com/learn/Learn_About_the_Ext_JavaScript_Library