Table level snapshot showed me a entry as below
Table Schema        = CARD
Table Name          = DEALER
Table Type          = User

I'm trying to create a simple UDF like so:
CREATE FUNCTION MYSCHEMA.GETUSERDEPT(USR_ID  INTEGER)
    RETURNS VARCHAR ( 256 )
    LANGUAGE SQL

Just a brief question: Are "FETCH FIRST ROW ONLY" and "FETCH FIRST x
ROWS ONLY" DB2 specific or SQL92?
thanks for any help,
nymano.

Is there any article / white paper  that you can suggest to me to
create a pivot table? I found Alexander Kuznetsov's article on IBM's
web site. But i need something deeper than that.
Pivot table's number of columns may vary depeding upon the input

is it actually possible to create a table that has a UDT as a column
datatype?
e.g.:
CREATE TYPE addressType AS (

I need a control break flag in my result when a certain value is
different to the previous.
A table/result like this:
PRODUCER ARTICLE

Passed DB2 UDB 701 test, how can I prepare for 704 test (Advanced DBA)?
There is not as many info. on this test as on others.
Thanks.
Mike

I need a proper index naming standard for my database (datawarehouse).
This is what I have thought so far:
Table name:  TGL_MTR_VHCL
Index name:  XGL_MTR_VHCL

 Hello!,
   Short question,
   Is there a way to backup database in db2 working in linux and then
restore it in db2 woring in windows ???

Windows XP Pro SP2
Excel 2003 SP2
IBM DB2 Personal Edition accessing a DB2 database on an AIX server via
the DB2 ODBC driver

Hello people,
I have an AIX system with the following characteristics:
- OS Level    : AIX 5.3.0.0
- DB2 Level    :

i have table structure like below
CREATE TABLE T1(
         ID INTEGER NOT NULL ,
         STORY CLOB(1048576) NOT LOGGED NOT COMPACT)

Hello, I am just starting out with DB2 and have come across some problems
with the perl DB2 DBI driver that I'd like to discuss and perhaps find
answers for. First is that the driver seems to be incapable of connecting
to a remote database, or at least it provide the following error ...

Recently I installed UDB8.2 on a Chinese version of WindowsXP. As
expected, every interfaces(ie Control Center, CLP, etc...) and system
messages were all in Chinese.
It wasn't a problem until I tried to migrate Perl scripts that I have

After install FP11 I found difference with previous versions. When I
call sp with commit inside from as400 on UDB now I got exception -925
o   When issued from a stored procedure, SQL COMMIT is also not
   allowed if the calling program is executing in a distributed