how do I export a VARBINARY field in a xml and import it later into
another table?
I have to do that with jdbc.
I think I have to export a VARBINARY filed with getBinary, but how do I

Linux accepts the userid '00001', and I can login to my database with
that userid. But when I try to grant privileges to that userid I get:
DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC:
00001;user_animals TO USER;END-OF-STATEMENT

I am creating a trigger in DB2 express version.
When i use the following syntax to create trigger
CREATE TRIGGER USER_PK_TRIGGER
BEFORE INSERT On users

v8.2.1
Please try this:
---
create function t(v char(1))

I am attempting to call RUNSTATS_KEY from VBA code and everything looks
coorect to me, however when I run it, it errors out.  The code snippet
is below...
           Set cmd = New ADODB.Command

DB2 LUW 8.2 FP5 (or is it 8.1 FP11?)
I am CALLing a stored procedure from a trigger in order to maintain a
column-level audit trail.  Not only do I need to store a record of
the INSERT, but also the initial values of all columns as of the INSERT,

i am a db2 newbie. we have a server hosting a db2/6000 database that
restricts the use of backup, generate ddl. i wonder if there is a
simple way to transfer the database structure and data into my laptop,
on which db2/nt was installed.

hi everyone.....
              Can anyone tell how to move tables between
schemas.......... that is changing the schema name of the
table................

db2 GRANT all  on a_table_name to user me
is for a table, I'm wondering possible to grant all on all_tables to
user me, without listing all tables' names?
--

Hello people,
I have this requirement to move a DB2 V8 database from Windows 2000 to
AIX V5.3.
I have managed to do that for a small simple database using

how do I insert "VARCHAR FOR BIT DATA" via jdbc?
I like to create from an ResaultSet (from a table) Insert-Statements.
How do I hanlde the Field-Types?
Does someone have an example in java?

Hi, our DataStage developers would like to connect to DB2 on Z/OS.
What would be required to do the same?
Cheers,
San.

i request all my friends of this group to share there idea like db2
tips,any R & D they have done and any suggestion they have about a
particular aspects,  apart from queries  and solutions.
so that  we can note it down and it may help in one or the other way.

is there a way to get informations from tabelspaces of a db2
(datafiles) via java (jdbc)?
Thanx...
Stefan

I have several Databases in a Instance . I want to a set particular
Isolation Level for Only one read Only Database . Is it Possible to set
a specific Isloation Level at a Database Level