I need some SQL help. I have a table that looks like this:
Cat1    Cat2   Cat3     Subset   Number
---------------------------------------------
A       ABC    Primary     X         21

hi newsgroup,
is there a way to pass a parameter (e.g. password) to a db2script?
Example:
db2cmd /c db2 -t -fscript.clp

I am using IBM db2 version: 8.1.0.36.
The following code:
insert into t values (next value for s)
[

Does DB2 UDB Supports Exception Join? I think 'No'. Hence I used the
following method to find out an functioanally equivalent exception join
select * from tab1
where   not exists

i  have a problem related to slow downloading speed.the situation is i
have about 60 PC's in a domain.when i ping ISP Gateway from a LAN PC i
get the replies...22, 25,35, 400, 50ms an some times 22, 40, 220, 150,
30, 100ms...I get lot of variations

[8.2.4 on 32-bit linux]
Have found
http://www-128.ibm.com/developerworks/db2/library/techarticle/lyle/0110lyle.html
which is quite helpful, but doesn't quite tell me what I want.

We are using V8.1.9 (aka 8.2) and we are having an annoying issue with
the Command Editor. It does not seem to remember, from session to
session, the "targets" that should appear in the drop-down box .Was
this supposed to be a feature? It would be nice...

I need some expert advice on a ROLLUP fine point.
summary_table table has 4 columns:
file_id
primary_site

When ever I start DB2, I get the message that APLD has been truncated
and that I should add the param to the DB2 registry DB2NTMEMSIZE =
APLD:125830720
The documentation says that APLD is related to Fenced Stored

I have restored a clients database using a redirected restore. However,
it is in a roll forward pending state. When I try to to a roll forward
to end of the logs, I get
SQL1268N  Roll-forward recovery stopped due to error "1" while

I am trying to load from a cursor which selects 124 million
records...but while loading it completes the build phase and it stuck
..I think...at the delete phase(which in turn looks like doing the
relational Integrity thing)  according my DBA at around 4%...Is there a

        We have the following scenario:
                  1)  update table A by joining with a global temporary
table B
                  2)  There is a one to one correspondence between A and B

I'm somewhat new to DB programming and have a question. I am now taking
over an application that a previous programmer had written and he had
made use of the Parameter.Add function for DB2 comman objects. This is
what is trying to be done:

 I am using a DB2 table of size 100 thousand records in it, which does
not have any relationship with other tables. When i tried to delete the
data in the table by using the command
IMPORT FROM /dev/null OF DEL REPLACE INTO MyTable;

Does anyone know how to get the schema name given a JDBC Connection
object? I see that I can do "toString" and pick the "User=" substring,
but smells of a hack. :)
Thanks,