Db2 8.1.3 windows
Is there any way to write data into a text file using a stored procedure?
The way we return a cursor output to the calling application, can we
return data in a text file?

I created a sproc with 3 input parameters and one output parameter.
I want to test it in the "Run SQL Scripts" app of Navigator.
I wrote this code:
DECLARE RTNDATE CHAR(10) DEFAULT '';

We are calling a OS/2 DB/2 v2.12 database from MS Access 97 and MS
Access XP. When doing a call we get the following error.
SQL0980C A disk error occurred SQLState=58005
We see now hardware failure in the raid system and other queries run

I'm new to this group.
I'm looking for products similar to the "DB2 Image Extender". It seems
to me that there aren't that many, or are there?
I found some tools such as ACDSee or Cumulus, which I would describe as

I have to create a trigger to accomplish the following:
Before the insert into table A occurs, the trigger must check to see if
the combination of two columns (from the insert statement) exist in
another domain table.  If the combination does not exist the trigger

I want to use MERGE to UPDATE the rows when there is a match. If there
is no match, I want to INSERT the rows, and at the same time change a
column value to a constant. For example, change the PURGE_INDICATOR to
'Y' to all inserted rows. Is there an elegant way to achieve this?

simple query
 select * from "Result" res where (res."QID" = 51541 or res."QID" =
51542)
works fine ("SRV-BL"."Result" ~ 900000 rows) and returns 36 rows

I think I have discovered a bug in the handling of null values (vs NULL
values) passed as parameters to a stored proc.
I have always believed that the database handled NULL and null the
same.  The following statement returns the expected results:

We commonly use triggers to log changes to our main tables to
historical log tables.
In the trigger, we create a concatenated string of the old values by
casting them as follows:

Are there DDL triggers in DB2?
By DDL triggers I mean the triggers which can be fired on ALTER, DELETE,
DROP, GRANT and REVOKE commands.
Such triggers are there in Oracle and SQL Server. I was hoping that they

     the problem i am having is that the SYSCATSPACE of one of the
ODS's growing overnight. I am sure no new objects are being created.
What can be the cause of this? I am on db2udb for aix 8.2 fp 12. Please
let me kow if I need to be more specific

I have a quick question about HA.  We have a setup that will be
implementing HA for DB2 ESE v8.2 FP 11 on AIX 5.3.  This instance that
needs to be configured for HA was installed with the -ese because it
was only to be used for DB2 connect.  Currently, we are making

Hi to all !!! And thanks to answer my topics.
I have problems when I try of run stored procedures, show diferents
errors. I made one test with one example of the tutorials. The example
is this

We are on DB2 v8.2
Can someone tell how can I know the size of backup in this version.
We take backups on TSM as well as Local Disk.
Is there any utility available within DB2 to see that.

How do I give create database privielege to a specific user/group at a
particular db2 instance ?
I read about various authorities like SYSCTRL etc. but I am interested
in giving only Create database privilege.