Hi, all..
I'm creating a table with one column of type DATE, non nullable, with
a default of the current date.
The column syntax I'm using is "THIS_DATE_1  DATE  NOT NULL  DEFAULT

Friends:
(DB2 LUW 8.1 FP 10, 64-bit)
I have a fairly small Java program that I want to wrap a UDF around.
I'm able to call the Java program from a little caller class fine, but

i cant erase sample table ,how can i that ? from  now on thank you:)

I'm running a java program on a PC which calls z/OS SQL stored
procedure.  The stored procedure returns an integer which should
contain "2", but is always "0".
I (pre)compile the stored procedure from the PC using "IBM Data

Can you use SPUFI to call a procedure in z/OS DB2?
Regards,
Serenity

Last week I downloaded Db2express on my Ubuntu laptop. I am now trying to learn
table partitioning and I am getting an error that Exp edition does not support
it
and only Enterprise edition supports it.

Not sure if We have  DPF running on two machines, both running AIX
underneath DB2.
We try to use AIX WLM to control priority of different service classes
in DB2. Shall we

Hi, all.
I'm trying to understand a certain RI question.
I have 3 tables.
TABLE_A has a PK of A_1.

to pierce its unholy heart.
I keep getting baited into this thing in CubeLand, and my colleagues do
have something of a point; to wit, if Users are to be empowered to take
responsibility for their data, then they have to be able to maintain the

Please help me. I need to port one stored function from Oracle to DB2.
In Oracle there is a sequence used, like this:
  SELECT seqTF.nextval INTO seq_nextval FROM dual;
I have lost 2 hours trying to find how to do the same thing in DB2. :-

Type - Model: 9406 - 520
i5/OS version:  5 Release 4 Modification 0
I need to be able to create a script that will allow me to store the
results of a stored proc into a session temp table. I need to be able

From the LDAP documentation...
You must extend the schema for Active Directory by running the DB2
Schema Installation program db2schex (located \cdrom\db2\common)
before the first installation of DB2 on any machine that is part of

Hi Team ,
Can some one tell me why we dont we have a DROP column or rename a
column command in DB2 ? I Have a very Huge table and need to rename a
column . The only option i have to do to rename a column which i by

I am trying to compress a table in my database, but for some reason the
compression doesn't work.
Here are the executed commands and their results:

Environment:
Server side: DB2 v. 8.2 on AIX 5.3.
Client side: AIX 5.3 LPARs, on a different physical server.
I have some SAS batch jobs which need to connect to a DB2 server. The