Dear Friends
First i like to introduce myself. I am satish working as Oracle and Ms-SQL
DBA from last 4yrs.
My compnay recently introduced DB2 Database in one of our projects.

Hi we have a certain SQL script. From that script we have calls like:
DROP FUNCTION A@
call sqlj.remove_jar( 'AXML')@
CALL SQLJ.REFRESH_CLASSES()@

Can someone direct me to a definative source to explain or suggest
naming datamart or summary tables?  Given a column in a detail table
like revenue, customer no, date (e.g., revnu,cust_no, and trans_dt) and
I create a summary table "sales summary by year_and month"

Here is an example of what I am trying to do. Can I not access (echo or
print or dump to file) the variables within the "BEGIN ATOMIC" ? I get
the error "SQL0104N  An unexpected token "ECHO" was found following "a
= cur.TABLE_NAME "

I am trying to create an MQT using the following select statement and
refresh immediate option
SELECT                  c1,
                       c2,

Is there an easy way re-prime the Package Cache after a
db2stop/db2start ?
i.e We have a Script of captured SQL (containing parm. markers) of our
workload,  that we would like to simply run Prepares of , and not

I found this ideas (below) from an old post, my question is, if I
choose alternative number 3, with two selects and one for the header,
is there a way to automate that code? I mean, without having to
hardcode the name of each field?

I am new to DB2. So i dont have knowledge of DB2 API. I dont have
knowledge of how to use API ...
I have requirement of loading data from tab delimited text file in to
Db2. For this I came across LOAD utility in DB2. But now my problem is

I'm trying to acquire the parameter MAX_CONNECTIONS by using the API.
The following is the code segment I used:
struct sqlfupd paramItem[5];
paramItem[0].token = SQLF_DBTN_MAX_CONNECTIONS;

FRIENDS
Here i m going to tell you the fastest way to get
MICROSOFT,CISCO,COMPTIA,ORACLE,SOLAIS certified without efforts......
friends i have five vue and prometric testing sites here in

I am working in a project that I need to parse an arrayt an select
records based upon the values parsed. I used the functions developed by
Knut Stolze in his article 'Parsing Strings'. I am particulary having
problems inserting records using a function.

I have to perform an update on a table.  I am having problems figuring
out how to join two tables as I need to check a value in a different
table before performing the update.
I have two tables here

I have one column  which has data type of varchar only. in this column
i want to store some secured data (I want to store this data by
encrpting using db2 encryption function).But along with this encrypted
data this column contains normal data also..

Greetings All
I have a question about IBM DB2 Content Manager. Is it J2EE Compliant?
Does it Support Two Phase Commit?
Many Thanks

can somebody help me to translate this oracle function to a DB2
function;
I've tried to do this but it didn't work.
With this function i can separate one textfield with a delimmeter in