query the syscat.columns table and prepare SELECT statement (SELECT
all_columns FROM table_name). For example, let's say that TAB_1 table
has total of three columns, and the statement should be:
SELECT COL1, COL2, COL3 FROM TABSCHEMA.TAB_1

Is there a simple query to extract the rows as below
Suppose the data is as follows
Part#    Assebly#     Type
--------    -------------     -------

I have DBADM authority over a particular database but I am unable to do a
'list applications show detail'.
Is there any special privilege required for the same? Thanks.
Cheers,

I am running db2updv8 -d databasename and i get this error
exec(): 0509-036 Cannot load program db2updv8 because of the following
errors:
       0509-022 Cannot load module

Folks,
 I have several files in db2event/db2detaildeadlock directory and is using
 up considerable amount of disk space. When I run following command I see
 event for 2 years ago.

Hi All;
I have a 2.5mm row table (very wide columns) on an UDB v8.2.3 (DPF -
6x10) AIX box. We were doing some performance testing to determine the
pros and cons of delete/insert vs load from cursor operations in our

I am trying to import the following file:
C:\SMARTMUN.0.DB2.NODE0000.CATN0000.20060926082904.001
with the following command:
RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2

Is there a way to run a script every (day, hour, week, etc.) within db2
itself or does it depend on its hosting OS for such things?

Are stored procedures / udf's / User Defined Structured Data types not
available in the free DB2 Express Edition?
I am able to create only user defined Distinct Data types through the
Control Centre.

Is there a way to include the character _ in the search string in LIKE
clause?
The default behaviour is:
- _ replace one character

Is there a way to disable the RESTRICT semantics for the dropping of
objects in DB2 8.1?
Thanks,
Ryan Gow

If I'm in a transaction started with 'odbc_autocommit($dbConn, FALSE);'
and I UPDATE a row in tablex, then later SELECT FROM tablex, will I see
the updated row or the original row? If it will help with suggestions, I
would prefer to see the updated row.

while trying to read data from a table assigning values into more than
one value I stopped at the following problem:
   declare c1 cursor for
   select val1 into cval1, val2 into cval2

Hello. I'm trying to connect a Jsp with tomcat 5.0 to db2 v.8 and it
doesn't work.
I have copied db2java.jar into tomcat/common/lib and I don't know how
to config tomcat.

I have this error when restoring my db:
SQL2548N Database codepage indicated in backup image differs from that
of the current on-disk database. The restore operation has failed.
I read the work around but I can do that becouse I have not the