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 …

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. …

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, …

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 …

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 …

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 …