Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Unanswered: Oracle Equivalent DB2 Statements

    Hi Everyone,
    i am new to DB & DBForums.i am working on a DB2-Oracle migration project. as part of it, i need the SQL Equivalent of the below DB2 statements :
    1.SET PATH &
    2.SET CURRENT ISOLATION
    can some one please help me with this?

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    2. ALTER SESSION SET ISOLATION_LEVEL = READ COMMITTED
    1. DB2 SET PATH allows you to specify the search order of schema names when using unqualified functions and types. However, Oracle resolves schemas differently, see here: Syntax for Schema Objects and Parts in SQL Statements
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •