I have a table of surnames and ethnicity.  I want to choose one ethnicity
and the number of characters going backwards from the end that should be
matched to approximate ethnicity.  This will be used to extract names of one
ethnicity form another table.  I'll be using MS Access ...

Folks,
 Is there a documentation on stored procedure performance?
 We have a database that is accessed by COBOL and Java applications.
 I am trying to convince my superiors that instead of writing SQL code

After the database upgrade from V8 to V9 (AIX5, FP02), SQL errors -803
started occuring quite frequently for the single-row-insert SQL statements
like "insert current timestamp... " on a table with a unique index on the TS
column.

hello friends,
I am new in db2 and I need to do select to a table in common call
VTACLI of different databases located on he himself server.
I need aid since to do select to two data base.

 I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.

   I'm thinking of using a PREPARE statement inside a stored
procedure, but
   am wondering about the performance penalty associated with calling
PREPARE

        we know that db2 create index using B-Tree,but if i want to
create index using hash structure,how can i do it? in my opinion, db2
usually create index using B-tree,my question is if db2 udb support to
create index using hash?

I have migrated a database from 8.2 to 9 FP3 by restoring a backup
into a DB2 9 instance.  Operating system is Solaris.  The migration
during the restore claims to have been successful.
Now, there is this function created back on the 8.2 side by me.  Works

I am new to DB2 9.
I need to restore database PRD onto database TEST (replacing it, as in doing
a production database refresh to a qa system).  I believe this is called a
"redirected restore" in DB2 speak?

I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I
cannot choose the provider, this is the only one I can use.
The tables in AS/400 don't have journal and I cannot change this.
When I define an ODBC and link tables in ACCESS I can perform every

I am getting the error while trying to take a backup of the schema
according to the backupschema.sql written at
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602...
db2 => CALL ADMIN.BACKUPSCHEMA('PKMSQA','/u01/Backup_schema')

Can I have a 32 bit & a 64 bit db2 instance on the same AIX box? If so
I do I catalog a databse to use the 32 bit insatnce?
Thanks

I want to convert the following recursive query to a Stored Procedure.
WITH school_hry(wing_school_num,bgt_yr,wing_school_seq_num,school_nme)
AS (SELECT wing_school_num, bgt_yr, wing_school_seq_num,school_nme
FROM t_wing_school WHERE wing_school_num = ? AND wing_school_seq_num

Can some one list the DB2 8 fix packs for me so I can determine when
the products intersect? Does it look something like this? Can someone
post an IBM link that documents it?
Thanks,

Using V9 for LUW, client-server, there is an option when configuring
the connections to use "server-encrypt."  It seems that this encrypts
everything in the client-server interchange.
Does anyone know the level ("strength") to which this encryption is