This is my first time starting a topic here so I hope this is the right
place.  I am having problems running SQL queries on a Version 8 DB2
database for Windows Server using the type 4 driver. I get a connection
but when I run a query, I get this error:

I want to get the next val in a sequence and then use it to do an
insert. I can do this to get the next val:
select NEXTVAL for EAIDATA.SUPPLIER_TP_SEQ_NO from EAIDATA.SUPPLIER_TP;
But if EAIDATA.SUPPLIER_TP is empty, this fails - "0 records selected".

Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.

When trying an alter I am getting:
DB2 SQL error: SQLCODE: -20054, SQLSTATE: 55019, SQLERRMC:
IS3.SERVICE_OBS;22
 Message: The table "IS3.SERVICE_OBS" is in an invalid state for the

Our health center used to send out notification emails but now it
doesn't
We dont have DAS turned on, does that need to be on in order for the
emails to work? Looking into the best way to drop/recreate and get it

hey guys
i would be really appriciate if any of u guys can share a script with me
which check each database wether they take backups.since we dont need to
check the intigrity of the backps,script  dont have to be tightly scripted.i

Environment UDB 8.1 Fixpak 9 on Solaris (64bit instance).
After connecting to the database as "my_user".
There is an alias from my_user.mytable to XXX.mytable.
There is no real table my_user.mytable, only an alias.

We need to initial load hundreds of tables from within programs. We try
to run several programs that call the DB2LOAD in parallel (to load
different tables of course) in order to speed up the process.
However, the program that completes the DB2LOAD first appears to cancel

I encounter problems with a java application which connects to DB2.
The problem only occurs with DB2 v7, in v8 all is fine. I know that
I think that I can solve my problem using "db2jdbcbind", but I am
not able to find this executable.

Hello
I am trying to use db2 load to load into a table that has a column
named URL. My command lists the column names.
I get an error 'An unexpected token "URL" was found'.

I wanted to know if there is a way in DB2 UDB/AIX v. 8.2.2 to
activate/start a database in a single user mode similar to how you can
start the entire instance in Admin Mode.
I want to take a database offline.  I use the force command but there

Dear Oracle/DB2 DBAs,
I'm looking for advice on tuning Oracle 9i and DB2 8.1 for rollbacks.
I have a number of developers, who each build and test our
client/server database application privately on their local machine.

I have a sql procedure that (among others) deletes a row in a table
(very small). The table has a foreign key - ON DELETE NO ACTION that
points to a large table (child). There is an index defined on the child
table column, but the selectivity is very poor (actually in this

I am getting the following error when I run a db2 clp command.
$ db2 list applications
SQL6031N  Error in the db2nodes.cfg file at line number "0".  Reason
code

1) Why do we have to commit so that statistics are taken into account :
Insert into DGTT
call ADMIN_CMD ('runstats ...')
<<- If we don't commit here, explain plans show that stats are not taken