Our business is in manufacturing, and we are running SAP on DB2 8.1,
planning on upgrading to 8.2.2 within a couple of months. We are
running operations 24/7, so are looking for ways to reduce our
maintenance impact to our users. Our users hit some specific SAP tables

Hi Newsgroup.
I need to call a view over an SQL statement.
The SQL statement makes an update at a table and needs the view in the
where part of the statement.

People,
I have an ESE 8.2.2 database running on win2k server [sp4]. I need to
do some system testing that requires I reset the dates back a couple of
years then progressivily move it forward to current date.

DB2 V6.1 on windows
How can I write a query that join two tables in a different database (but
same instance).
Thanks

I have some questions related to stripe sets that I'm hoping someone here
can answer.
1) What happens to stripe sets when doing a database restore? Do they stay
as is?

We have  14 GB db (PRICE)on Windows with  user exit
Offlie backup done daily at 10 PM
at 7 AM follwing day we restore offline backup of PRICE as
PRICE_R and reapply log  files to  6 AM

Guys -
Does the PRUNE logfile command do anything other than just do a simple
delete of the files?  Or is there more to it internally in DB2?
Thanks in Advance,

During install of UDB 8.1 on Windows XP, my name gets set to AUTH ID as
'MARTIN NIELSON'. Then, when I try to create a table DB2 complains about the
value of the ID. Where does DB2 get the name from so I might change it. OR,
what can I do to correct/circumvent this problem?

Hallo Newsgroup.
Ich möchte eine Abfrage die ich im Access2003 erstellt habe auch in
der Befehlszentrale vom DB2 erstellen. Doch die Funktion "first" kennt
DB2 nicht. Anbei der SQL Code vom Access, das wird mein Problem genauer

In our software we use an UDF since 1997. Now, after creating the
complete software, this UDF doesn't run. It gives the error message
db2 => values (lzgneu.bitand (5, 7))
1