| Thread | Last Post | Replies |
|
| Trigger fails when stored procedure is called two times in a row | 01 Dec 2005 18:07 GMT | 6 |
I am puzzled by the following behavior.
If stored procedure PROC1 is called 2 times in trigger TRIG1, then I
get error during trigger firing:
SQL0723N An error occurred in a triggered SQL statement in trigger
|
| Using Net Search Extender on Typed Tables | 01 Dec 2005 16:55 GMT | 8 |
I have been using IBM Net Search Extender to perform full text searches
on text columns in relational tables in DB2 without any problems until
now. However it doesn't seam to function properly for text indexes
created on attributes of typed tables.
|
| identity column & import - need help | 01 Dec 2005 14:57 GMT | 2 |
8.2 UDB win32
I need update a one column in very large table. PK for this table -
generated always as identity :-(
I can't recreate table without generated always.I don't want write SP
|
| how to change the data type | 01 Dec 2005 14:01 GMT | 1 |
HI all, we r using db2 V 8.2, when i am trying to change data type ie.
SMALLINT to INTEGER(no data in the table), iam getting this error
messege. Pl. help me slove the error.
ERROR is
|
| SQL1031N connecting to remote database | 01 Dec 2005 11:30 GMT | 2 |
Im connecting to a database on a remote machine. The node and catalog
command were successfully run. I can connect to the database from the
db2 command line.
db2 => connect to dkt_old user xxx using yyy
|
| DB2 on Windows to DB2 On Mainframe | 01 Dec 2005 05:02 GMT | 5 |
I just want to know what are the points or performance
issues to consider while migrating database objects(like sp's,
triggers, tables etc) from DB2 UDB on Windows to DB2 on Mainframe7.1 or
any link where i can find some important information regarding the
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread