Database Forum - DB2 Topics

Thread preview

Thread	Last Post	Replies

cli load question	31 May 2006 22:22 GMT	1
We are using cli bulk loader to load data into db2. In some cases the rows get rejected and this is flagged as a warning allowing the program to continue. Is there any way to trap this warning, I read the use of "EXCEPTION TABLE"
Parent Child Relationship - System catalog tables	31 May 2006 20:46 GMT	3
Is it possible to determine the list of child/parent tables for a particular table from any system catalog tables? Using the syscat.tables I'm able to retrieve the no of dependent parent/child tables but unable to determine the list of dependent table name(s)
Disabling Constraints in a table	31 May 2006 20:19 GMT	3
I am using IBM DB2 UDB 8.2. I have a scenario where in I need to disable the constraints of a given table temporarily. For ex:
Wider columns or Deeper Rows?	31 May 2006 17:38 GMT	3
My data modeler asked me an interesting question... What is better as far as efficiency is considered: Tables having wider columns or deeper rows? I answered: 'It depends' on the total size of the data to be fetched (row
translate function	31 May 2006 15:35 GMT	3
I am trying to remove all blank chars in middle of the string "text1 text2 text3 text3 text4" with following stmt: VALUES(translate('text1 text2 text3 text3 text4' , ''
CASE AROUND ORDER BY?	31 May 2006 14:12 GMT	7
Hello I'm trying to have some control on how my data is ordered depending on an input parameter my question is in a stored procedure how can I do something like this at the end of my
2 Serge Rielau: please, repost bitwise ops implementation (udfbit)	31 May 2006 11:58 GMT	8
Hello, Serge. A while ago SR> Subject: Re: poor query performance SR> Date: Thu, 08 Sep 2005 06:31:52 -0400
Bulk insert from a CSV file to a DB2 file. How?	30 May 2006 22:14 GMT	3
I have created a program in Visual Basic that creates CSV file on the PC. However I need to do an upload of these files into DB2 tables (from time to time) I'm currently using ADO to create a connection to the DB2 table and update
seek select statement to fetch rows older than five minutes	30 May 2006 17:00 GMT	2
Ideally I'd like an equivalent of : current date - 5 days which works for minutes instead of days... ---
Newbie Insert Trigger question	30 May 2006 15:51 GMT	6
I've been a Sybase DBA for a number of years. We now have a number of DB2 servers that I'm starting to work on. I've written many Sybase triggers but the DB2 syntax is still unfamiliar. :-(
Monthly security Audit Check	30 May 2006 15:48 GMT	2
I need to do a monthly security audit check on our DB2 instances.. Did anyone has any information on how to proceed, pl help Thanks in advance Regards
Need Tech Review of DB2 Backup Chapter for O'Reilly Book	30 May 2006 15:21 GMT	6
My name is W. Curtis Preston, and I'm the author of "Backup & Recovery" (formerly "Unix Backup & Recovery") from O'Reilly & Associates. ( http://www.oreilly.com/catalog/unixbr/ ) We're updating the book for 2006 and adding a chapter on DB2 backup and
DBA Interview Questions	29 May 2006 17:48 GMT	1
DBA Interview Questions http://quickdba.blogspot.com/2006/05/dba-interview-questions.html Visit for more Articles
Oracle Server Quick Reference Guide	27 May 2006 14:06 GMT	1
Oracle Server Quick Reference Guide http://quickdba.blogspot.com/2006/05/oracle-server-quick-reference-guide.html Visit daily to get more updated articles
CREATE TRIGGER ON INSERT	27 May 2006 14:01 GMT	8
I have looked over various forums, and refined this trigger to the best of my abilities, but when someone pastes a trigger using code -very- similar to yours and it still doesn't work for you, ya gotta ask yourself, what's wrong?