I'm new to SQL but not Excel
I was given a Excel spreadsheet with Employee names.  I have a large
database with a Personal Table with Employee names and a whole list of
other tables that I'm used to running queries.  I'm still new to

Here is the SP:
--#SET TERMINATOR !
CREATE PROCEDURE execute_immediate (IN in_stmt VARCHAR(1000)
,OUT out_sqlcode INTEGER)

Customer is running a load test against a websphere application that uses
DB2.  While the load test is running the memory usage of DB2 climbs from x
up to y. When the load test ends, the memory usage of DB2 returns to x.
However, sometimes after running the load test the memory ...

I've a table Table_val as follows:
  C1   C2
  ---- ----
  V1   val1

I believe this has been asked before, but I can't find the answer.
Can HADR be used to provide failover for a DPF node(s) that goes down
because of a server hardware failure?

A batch job run from an informatica server is failing with the
following error when trying to connect to the prod database, but it
connects the second time when a retry is issued without any problems.
[IBM][CLI Driver] SQL30082N  Attempt to establish connection failed

Sorry for the length of this post, but I think it will illustrate my
point. As part of my deployment process I run a bunch of verification
scripts. Amongst other thing the column order of primary/foreign keys
is validated. The other day I stumbled upon an error. The foreign keys

Check your requirement from the following list of Software
SAP IDES for Your Personal Practice at Home.
I.       SAP ECC 6.0 SR2  12DVDs   +  Screen shot Installation Guide
II.      SAP ECC 5.0 IDES  7 DVDs   +  Screen shot Installation Guide

Hi community,
the log files in SQLOGDIR have -rw------ as permissions. How can I
change the permissions to -rw-r----, also for newly created logfiles?
Thanks in advance,

I'm trying to implement an internal company provided security
algorithm as a UDF within DB2. I have the provided C source code and
was able to put a UDF wrapper around it and compile it using the
provided bldrtn script on my development box. It appears to be working

I have an edit trigger:
--#SET TERMINATOR !
CREATE TRIGGER EMPSCREDIT  
  NO CASCADE BEFORE INSERT ON EMP_SCREEN_EDIT

I'm pretty new to DB2 and like to know if column cardinality can play
a role in choosing the column order in a composite index.
In Oracle, it appears composite indexes of different column orderings
perform the same regardless of column cardinality (http://

Will a DB2 (v8.2.7) primary database find a required log for
perpetuating HADR in the db cfg parameter OVERFLOWLOGPATH?
TIA,
Kermit Lowry

We are testing one of our component with JDBC + DB2 using db2jcc
driver. We afced a strange issue.
Scenario is like this.
1. We insert 1 record to a table having IDENTITY column as the primary

I am currently developing trigger based screen edit fro several 100 screens
in COBOL/CICS
EVIRONMENT.
For every screen i have a corresponding DB2 TABLE  and an edit trigger: