Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dudeami

    how to disable a trigger while he`s opereting?

    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...
  2. dudeami

    DB2 - Outer Join Performance

    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 =...
  3. dudeami

    Use Cursor in PL/SQL

    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...
  4. dudeami

    How good are you?

    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!
  5. dudeami

    java.lang.UnsatisfiedLinkError

    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...

Part and Inventory Search

Back
Top