DB2
in [SQL]
|
never-ending LOADs Hello, We use DB2 8.2.4 I have noticed that on one of our sun solaris machines LOAD command don't work. EXPORT and IMPORT commands works, but if I execute any LOAD - it never ends. The same LOAD statements takes on another machines less then second. On those server we have 3 instances and on every database it ... 10 Jul 2008 03:08
inserting data into a dependent table Hello, I have two tables, one is a list of activities, the other a list of participants. I want to insert one record in the activities table and then using its identity column as foreign key, I want to insert two or more records into the participants table. My problem is that I have no idea what foreign key to... 10 Jul 2008 06:11
Redirect SELECT results to a file This should be simple, and the docs say so, but no... 1) I have an .hta file (VBScript), with a call to windoze shell 2) the shell call is to db2cmd, input from a file 3) the command file has a db2 SELECT <blah> command If I insert > foo.txt in the db2cmd command line, the commands, result set, and mess... 11 Jul 2008 21:15
need help with the trigger Hi everybody! I have an INSERT stattement like this: insert into ELIGIBLE_PAY select from ELIGIBLE_PAY_B where cust_id = 999999; after insert i would like to delete row from source table by creating the following TRIGGER: CREATE TRIGGER DEL_FROM_ELIGIBLE_PAY_B AFTER INSERT ON ELIGIBLE_PAY REFERENC... 9 Jul 2008 12:40
DB2 patches - need historical record of proof Hello, I am relatively new to DB2 LUW (v9.1). I have been asked to prove the history of patches to the database. I know I didn't apply any (we started on fix pack #1), and that we are testing fix pack #4, but how do I prove this? Is there a hidden (or not hidden) file somewhere in the DB2 install directories th... 8 Jul 2008 05:55
Free Webinars on PMP Certification Awareness and Roadmap Dear Freinds I came across a website which conducts Free Webinars on PMP Certification (Project Management Institute, USA) Awareness and The Roadmap. It proved to be quite useful. This Training Institute also provides live online lectures on PMP Certification Preparation at very competitive rates and also have f... 7 Jul 2008 09:24
Schema size(Size of all the tables in a schema) Hi , I was trying to find the size of a schema (Size of all the tables in a schema). Can some one tell me an easy way to do this. There are more than 200 tables in my schema and it is very tedious job for me to calculate each table size manually. Thanks in advance, Kamalnath.V ... 7 Jul 2008 10:25
Latest updates in database management and SQL server Find the latest updates in database management and SQL server tools and techniques. More details about software testing, flowchart preparation and many more http://www.sqlserversoftware.blogspot.com Find the jobs details in MNC companies in the field of information technology http://www.infotechjob.blogspot... 6 Jul 2008 21:10
brothers and sisters must register and send this article to users http://www.youtube.com/watch/v/as_b6...&feature=email Lecturer: Bro Sheikh Feiz 4rm Austrailia For how long, for how long are we going to be heedless of the signs of Allah (SWT), for how long are we going to be busy with the Dunya (World), busy making money, chasing our dreams, following our desires? We ... 6 Jul 2008 14:00
UDF RETURNS DIFFERENT TABLE I would like to write an UDF function that returns table A or table B based on a value passed as argument. Something like: CREATE FUNCTION my_func(my_value INTEGER) .... RETURNS TABLE (C1 INTEGER, C2 INTEGER) .... BEGIN ATOMIC RETURN if my_value = 1 then SELECT C1,C2 FROM TABLEA else ... 6 Jul 2008 18:06 |