Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2005
    Posts
    30

    Unanswered: after ontape -N db, i always get 256 SQLCODE

    i use C++ to connect DB.
    after using ontape -N db,
    there is no problem to create proc, and disable triggers ect.
    but when i try to execute the proc,i always get 256 error code?

    finderr 256
    -256 Transaction not available.

    You cannot begin a transaction in this database because it does not
    have a transaction log. In order to support transactions, you must
    start a transaction log. Refer to your Administrator's Guide for
    information on how to start a transaction log.



    is it normal error message?
    how to avoid it?

    thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41
    Yes ontape -N dbname turns off logging to start a transaction begin work commit etc you need to have loggin set to either Buffered or unbuffered loggin ontape -U or ontape -B
    Jeff Wain

  3. #3
    Join Date
    Oct 2005
    Posts
    30
    ontape -N DB1 -B DB1

    if i use command above,

    Database 'DB1' - Logging status updated.
    Database 'DB1' - Logging status updated.

    Program over.


    what's that meaning? unbuffer first, then buffer again?

    Can I use -N and -B , -U at same time?

    what kind of command i can check the DB in exactly which status concern the log?

    Thanks in advance.

  4. #4
    Join Date
    Oct 2005
    Posts
    30
    Problem solved, in the procedure, there is begin work, which open transaction, i remove this begin work, it is ok now.

  5. #5
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41
    There ya go when setting the loggin only use one option in the future -U = Unbuffered -N = No Logging (which by the way is unsafe if there is ever a crash) the -B if for buffered logging
    Jeff Wain

Posting Permissions

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