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 IamaSherpa 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: *

  • Users: val02
  • Order by date
  1. val02

    user exp / imp in db2

    hi all is there any way in which we can export the user (db2admin)objects (tables, procedures, functions etc) to a dump file .dmp or any other file and import the file at some other database in some other user... oracle has exp and imp command (command line commands) .. thanks and regards...
  2. val02

    dbms_output.put_line in db2

    Hi all is there any procedure similar to dbms_output.put_line in db2.. to propmt the messages on the prompt thanks and regards vallabh
  3. val02

    auto commit in db2

    hi all how to turn off auto commit in db2? i think auto commit must be on by default as what ever i do in QMF gets committed even if i issue roll back thanks and regards vallabh
  4. val02

    begin..end block

    Hi All In oracle we define the pl/sql block as begin --sqls exception --exception handling end I.e. we use begin..end to help us handle the exceptions for particluar sql seperately.. Can begin ..end in DB2 used for similiar purpose? Is it advisable to multiple have begin ..end with declare...
  5. val02

    Explain plan

    Hi All I am learning DB2, I want to know is there is anything similar to Explain plan in Oracle, which can be used to view the statistics for the query like..physical read, sorts, whether query is using indexes etc.... Thanks and Regards Val

Part and Inventory Search

Back
Top