Information with regard to creation of a table is stored in SYSTABLES.
Is modified time stamp of a table stored in
   DB2, if so where.
Thanks,

       We are having a strange problem that appears on Fix Pack 10.
       Problem:
       When using bulkloader to load data into a table that has a identity
column, the records get rejected and

     It seems the DB2 CLP (Command Line Processor) is the way to go (other
ideas???)
     I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or Windows?

I need to increase the UDF_TIMEOUT value within the scope of a job, and
had hoped to use CHGQRYA to do this. However there seems to be no
UDF_TIMEOUT parameter to this command.
I can change the UDF_TIMEOUT within the QAQQINI file and that works,

Ciao a tutti ( Hi to all )
( sorry for my bad english ) !
I have a problem with dynamic sql. I try to read all internet but I don't
understand anything ! So I hope in Serge ( I love toronto in particular

The following insert takes ages, although it started out pretty fast. I
monitored it with DB2mon, and in the begin insert count was about 1000
per minute while after 300000 or so rows, it droped to about 20 rows
per minute.  Anyone any idea what could cause that?

I'm getting:
DBD::DB2::db do failed: [IBM][CLI Driver][DB2/LINUX] SQL0440N  No
authorized routine named "CONCAT" of type "FUNCTION" having compatible
arguments was found. SQLSTATE=42884

Hi To All,
I took up the IBM sample testfor Exam 700 today and I have the test
tomorrow,I have some questions for which Iam not sure about the right
answer,can anyone please guide me as to what is the right answer for

i want to insert into a temporal table the result of a store procedure.
on sql server the sentence would look like this (already working)
       INSERT     INTO #SHIPINFO
    exec     TESTDTA.S59RSH05 @SCBILLTO, @INID, @ADRSTYPE

I have Db2 server installed on remote server. i am connecting to that
remote server by using VPN.
I want to connect that remote DB2 server instance using my local
machine DB2 development client. Bur Its gives me following error

I am still getting "Password Invalid" with all new users I define on my
linux box. I have tried all the suggestions made here and they made
exactly no difference. I have server authorization set. I do have
connect authority for the new user. I have all the same groups for the

I am calling the exact same stored procedure called myprocedure from 2
different boxes from the CLP, but I'm experiencing different behaviors
between them. After I was unable to get
any support from IBM due to V7.1 being no longer supported, I figure

I don't have much experience writting UDFs, so I don't know if this is
possible (and simple). I am basically looking to write a wrapper table
UDF that encapsulates reorgchk_tb_stats and reorgchk_ix_stats
procedures, so I can easily manipulate the result set using SQL.

I backed up a database and took it home to work on it.
Problem is with the stored procedures:  In the Control Center I can see
the SPs, and I can see their SQL code.  But I cannot edit nor copy the
SQL code.