Search results for query: *

Yes, you CAN do what you want. 1) Create a package variable - call it something like mypkg.dontfiretrigger. 2) Create an autonomous transaction (procedure) that does what you want (the part that is causing the mutating table now). 3) Modify the existing trigger to: -- If dontfiretrigger is...

I am having some serious performance problems using outer join. Any insight or hints that you can offer would be most appreciated! Here is my timing script. echo "Inner Join" date db2 "select count(*) from ( OSI join SSL on OSI.S_Key = SSL.S_Key and OSI.SubCaty =...

Why not do a self join and do it all in the select? Select a.year, a.month1, a.month1/b.month1, a.month1/c.month1 ... From table1 a, table1 b, table1 c where b.year = a.year-1 and c.year = a.year -2 and a.year = 2001 Or am I missing something? FYI... you would probably want your select...

1) One week. Of course I had several years experience too. Started 1/2/2001 with the SQL exam. Finished 1/31/2001 with the Networking exam. 2) 10-12 3) None. Passed each on first attempt. 4) No, only OCP for DBA. 5) It's helping me KEEP my job. :-0 6) Not yet - but there is hope!

I have a JDBC connection to a DB2 database. The connection is successful, no errors on loading the driver (in db2java.zip), or opening the connection. But, when I try to query I am getting java.lang.UnsatisfiedLinkError. Looking at the class definition, I see that the method that is trying to...