IWD

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 …

IWD

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

IWD

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

IWD

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 …

IWD

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 …