Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: Error Getting -244 (Due update in systable)

    Hello...

    I'm trying to chage my table to row lock (was in page lock)...


    I heard about update in systable the field locks..... but afte I did this,my application's getting this error (-244)...


    How I change one table from page to row ?

    Thanks.

  2. #2
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    alter table <table_name> lock mode (row)

  3. #3
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    never ever....ever....ever... you do a update/delete/insert over any SMI (sys*) tables....

    To alter the lock mode:
    Code:
    alter table tab_xyz lock mode (row)
    you already shutdown you IDS and restart to stopping these errors?
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  4. #4
    Join Date
    Oct 2007
    Posts
    61
    I guess It's ok now.. thanks.

Posting Permissions

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