there is an application which issues a lot of simple dynamic queries
against an Oracle database. If CURSOR_SHARING is set to FORCE, Oracle
treats dynamic queries as static ones, for instance
SELECT * FROM SALES WHERE CUSTOMER_ID=12345

Is it possible using dynamic SQL in UDF?
In Sybase below example work but in DB2 UDB 8.1.3 I get error:
"SQL0104N  Unexpected element "EXECUTE IMMEDIATE" found....."
CREATE FUNCTION DropTable(p_TableName VARCHAR(30) )

How can I insert a row in a table from inside a stored procedure? The table
is in a different database in the same instance and on the same server.
Thanks,
J. Terrazas

From inside a stored procedure written in SQL PL, I need to insert a row in
a table in a different database which is in the same instance and on the
same server.
I have tried to use a federated connection and although I'm able to query

I've encountered a strange error with loading delimited files from a
Samba (SMB) network drive, has anyone else seen this before?
(Platform: WinXP Pro, UDB PE 8015, level 02060106, SAMPLE db)
db2 load from M:\org1.del of del replace into org

DB2 7.2 (ESE) on AIX 5.2.
In 3 weeks, we've seen the following :
Tablespace name                            = SYSCATSPACE
 Direct writes                            = 150306

I was actually just wondering if someone could possibly take a look
and tell me what I may be doing wrong in this query? I keep getting
ambiguous column errors and have no idea why...?
Thanks in advance!!!

I have a locale problem in AIX 5.1

LANG=pt_PT
LC_COLLATE="pt_PT"

I can't find this in the manuals. I'm not interested in size of
primary or secondary logs, what is a good rule of thumb for how many
logs to cut in an hour in a busy OLTP and DW environment. I heard
every 15 minutes was a good starting point. Thx, Flick

I'm a developer for a software application vendor, and our application
makes use of a customer-maintained Oracle 8i/9i database. We've had a
customer request to support DB2 database, and I'm looking into the
feasibility of migration. Our application runs on NT Server and, the

We have a DW and are using TSM for the logs and backups. We are
constantly
getting retry messages in the db2diag.log inidicating that DB2 won't
try to

on db2 v8.1 for linux 32 bit redhat 7.3, when
installing fixpak6,it's overwriting the symbolic link
that I defined for the install directory, and proceeding
to fill up my root partition.

I'm new to set up DB2 though using JDBC for years.
my question is:
supposed there are 3 computers in local-net, named A,B,C (they are Windows
2000 families). DB2 installed in A (port is db2c_DB2 50000/tcp) which hosts

OK.  I have a problem and need some help from DB2 Gurus.  In ORACLE, I
have a trigger which fires on an update event, sending the ROWID and
TRANSACTION_ID via a pipe to my application.  The application can then
issue SQL to read the row that was updated (directly accessing it by

Given table a:  col1 col2 name1 name2 where col1 and col2 make up the
unique key.
Given a stage table b: col1 col2 name1 name2. (again unique key same
as a)