Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Lightbulb Unanswered: lock several database

    Hi all,

    Anybody can tell me if informix allow lock more than one database same time.

    Thank you for you help.

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    A database can be opened in locked mode with the SQL statement
    Code:
    DATABASE dbname EXCLUSIVE
    but in an interactive session you will first have to close the current database. I presume in an application you can make multiple connections to databases and lock them with this statement. Keep in mind that for opening a database in locked mode no other connection to that database may exist at the time.

    Regards

Posting Permissions

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