I can not get the SQL compiler to rewrite my SQL UPDATE statement to
include columns being SET in a Stored Procedure being called from a
BEFORE UPDATE trigger.
Example:

Hi ... we're a mainframe V7 shop planning an imminent upgrade to V8. My
application team is converting an IMS DB into a DB/2 table ...
approximately 40GB of uncompressed (~20 GB compressed) data spread over
10 partitions. Approximately 35% of the data is "inactive" (easily

I'm trying to get the SQLERRMC info from the SQLCA into my SP so that I
can use the information it provides.   I'm successfully getting the
SQLCODE and SQLSTATE and so added the SQLERRMC to the code which
obtains these.   It doesn't seem to work however -

I am trying to connect to DB with the following command
db2 connect to <dbname> user <username> using <password>
It throws the following exception
SQL1337N  The service "db2inst1" was not found.

On a 3 [INTEGER] column table, the PK consists of all 3 columns.
I [also] have queries on the first two columns, as well as on the last two
columns. (Select * where column3=x and column2=y.)
I was hoping that this same pk index will suffice for the latter

I'd like to enhance my training by earning a IBM examination oriented
DB2 credential.
But when I search the internet, even IBM's traing site, all I find are
entities that want to sell me on a $1000/day training seminar.

I have the following Java code :
package com.rhi.bb.udf.utils;
import java.sql.Clob;
import java.sql.SQLException;

Hey all,
I'm trying to parse the output from the get_dbsize_info procedure with
a Perl script, using the DBI and the DB2 DBD.  Below is the relevant
part of the code:

Thanks.

I want to delete some rows from a table (TAB1), but only those rows which
has a match in antother table (TAB2). Something like this:
TAB1: col1, col2, .....
TAB2, col1, col2,......

This is Hiten from Quality IT Source, and we are looking for a suitable
candidate for the following position
Informatica ETL developer
Duration: 3-6 months (Contract to Hire)

i'm new to db2, so the answer on this question is maybe verry simple
(or not)...
i've installed db2 on a server, and now, I want to make a connection
with odbc from a client (windows 2000). I installed the IBM DB2 odbc

I have a scheduled job that does an archival job. Archive process
deletes records by family  i.e., say the application is based on travel
trips, "trip"s are archived one by one. When a "trip" is archived,
records related to that "trip" in various related tables are deleted in

I had a special senario here..
I need to build a database which only around 50-70GB finally.
But one of table would be 40GB finally. ( grow every year until to the
retension period)

I created a stored procedure called MANLIB.MAN535CL based on a CL/COBOL
program.
I know it works because I can run it successfully.
However, I don't really understand where it is on the iSeries.