Intelliware Logo

I’ll try to explain how to use ALTOBJ with this thread. I’m not going to get into the GUI because it is hard to describe in text. First of all …

Intelliware Logo

The following outlines a simple example of the renaming of a DB2 table column using the SYSPROC.ALTOBJ procedure. See the below link for a more detailed description of using ALTOBJ. …

Intelliware Logo

This document describes the DB2 schema limitations in great detail (there are 27 identifier length limits), and in terms that I find a little misleading (e.g. Longest unqualified column name, …

Intelliware Logo

This is an example of how to implement a Java-based User-Defined Function (UDF). Define the function CREATE FUNCTION db2admin.concatenate(VARCHAR(200)) RETURNS VARCHAR(2000) SPECIFIC append EXTERNAL NAME ‘AppendStrings.Append’ LANGUAGE JAVA PARAMETER STYLE …

Intelliware Logo

Getting the description of DB2 error NNN db2 ? sql-NNN Bring up a command window for executing DB2 commands db2cmd Display the database schema db2look -d hw -i db2admin -w …

Intelliware Logo

Article originally posted by Deth Personally I’m a type 4 kind of guy. I’ve been debugging a strange JDBC issue with DB2 and NG. When I run a test that …