Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: conversion of Oracle For Update to sybase

    Hi,

    How do you i convert the below Oracle Query to Sybase.

    SELECT * FROM T1 FOR UPDATE;

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    set the isolation mode to REPEATABLE READ.

    SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
    then,all row will be locked when select clause fetched the data before transaction complete.

  3. #3
    Join Date
    Aug 2004
    Posts
    76
    Hi,

    Thanks for the info: Then can my query be some thing like this?

    Oracle:
    SELECT * FROM T1 FOR UPDATE

    Sybase:
    SELECT * FROM T1at isolation repeatable read

    Also I've read about Lock Table command in Sybase. Which the best suited one.

    Thanks,
    Cheeks

Posting Permissions

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