this might be very stupid question
does UOW include select statements ?
regards,
db2admin

Hallo zusammnen,
ich möchte einen  VARBINARY-Wert aus einer Tabelle auslesen, diesen in
einer Datei speichern und später wieder in eine Tabelle einfügen.
Den Wert hole ich mit einem Select und getString().

I'm trying to invoke a DB2 stored procedure. The stored proc is coded
in C and compiled to a shared library, which has been placed in the
<DB2 dir>/functions directory. The platform is Solaris.

Hi to all ng
(sorry for my bad english)
in my c program I wrote a dynamic sql. So happen that everytime the string,
rappresent the sql command, was length more 1720 char in runtime i have an

I am having trouble getting DB2 to select an index I have created for a
spatial location.
Table definition
create table gps_paf_address

I have a question, can you please guys guide me on how to implement it:
We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I

So I get a call from my customer this morning, he tells me the database
has hung during the TSM backup and nobody can connect.
After tyring a few things, I resorted to db2_kill, and db2start.
I don't feel this was the best solution, but since the database was in

I'm trying to execute a xquery statement and I get always errors.
It seems that only the prolog section is giving me errors.
If I want to declare a namespace the xquery processor is coming up with
an "unexpected token" error.

I'm having trouble getting HADR to work with the sample databases on
two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the
following error.
SQL1768N  Unable to start HADR. Reason code = "7" - The primary

i have query doing tablescan instead index scan. i would explain
situation in more detail.
table has MDC on one column and three more regular indexes. now, one of
the index which has three columns has bad index ratio ( 40 ) due to

In a stored procedure,
If i use "alter table <tablename> activate not logged intially with
empty table", i get SQL104n error.
If i use "execute immediate alter table <tablename> activate not logged

does cost of SQL include broadcasting etc. as additional cost ?
cost of SQL doing join on partitioning key is less than cost of same
SQL doing join on cluster index which has column other than
partitioning key

Hello and thanks for taking the time to help out.  I've been tasked
with finding records from one table that are not in another table, but
do exist in a third.  I've written a query that identifies the records,
but when I try to add the meaningful data to the select statement, I

I am new, and trying to learn DB2. I am trying to setup a simple
master-slave replication. Is there a way around using Replication
center? I want to stay away from the GUIs much as possible.
TIA

IF p_flag='I' AND v_count<>v_limit  THEN
 INSERT INTO
user_vendor_table(account_id,vendor_id,user_login_name,user_password,type)
VALUES(p_account_id,p_vendor_id,p_user_login_name,p_user_password,p_type);