In sybase we have a function "COMPUTE BY" that gives
us the output with the grand total at the end.
like
select type, price, advance

I am trying to call SQLSetConnectAttr api but I am getting following
error:
SQLSTATE:   HY024
Native:     -99999

I have no DB2 or SAP knowledge, but would like to know if someone has
done Quickshadow Space optimised snapshot of SAP/DB2 and did a restore
from the snapshots.
We try to backup SAP/DB2, by bring the DB2 database in online backup

I was wondering if anyone has any thoughts on a DB2 book that might be
useful for me.
We are currently a mainframe shop running VSE/ESA 2.7.  We are in the
process of installing z/VM, which we'll run VSE guests under.  We're

Dear collegues,
small query problem.
A table (simplified example)...
customer as char(5)

table "A" was created by user "USER1". Is there a way for USER1 to
grant access to DROP that table to user "B"?
The answer I heard so far was "only if user B has administrative
priviligies". Any evidence to the contrary?

HI Every body ,
I would like to know whether is it mandatory to give Tablespace page
size and Bufferpool page size equal..? i also heard like while creating
tablespace if pages size of tablespace and bufferpool , the statement

I have the following statement which I run successfully in... 1 hour 10
minutes.
SELECT
    a.tsgicd as ACCT_ID,

I have a view created based on two base tables..now when i drop one of
the tables on which the view is dependent ..what would happen when i
try to select some records from that view ..? Does the view becomes not
usable or autmatically that will get droped as soon as one of the base

               Sybase authentication is managed by the database
manager
whereas DB2 relies on OS userid and password.
when we migrate from sybase, there are certain applications that are

We are having some problems with triggers, sequences and union all in
V8 on code that worked fine in V7. Was wondering if someone else has
seen this and/or knows what to do.
A trigger that runs after insert on, where the insert uses nextval on a

Does anyone know of any good sources (white papers, etc.) regarding
migrating from Teradata to DB2 UDB EEE?
We are in the very beginning stages of investigating this as an option
for some of the smaller projects that are going to Teradata presently.

     I am trying to connect the Database which is installed in AS400
using DB2 Client Version 8 in Windows box.
First i created the Catalog,
then when i selected the connection type as ODBC, then i am getting

Is there a way to read the (archived) logical log files to see the sql
statemets that got executed. The classic example is when 'some joe'
programmer ran a bad query, trashed the database and then come back and
blame the dbas for ' you did it all', how can we defend ourselves? I

Greetings Gurus!
I'm having difficulties inserting data into a DB2 database from a SQL Server
linked server.
I can run the following query from SQL Server's query analyzer correctly: