Re: Cancelling A query
Jake -
Thanks! We think the problem is with our version of Informix 7.1.
We are in the midst of upgrading to 7.23 and the problem is not
evident in 7.23
}
} Peter Wages wrote:
} >
} > We have a reoccurring situation where a user in dbaccess submits a query
} > against several large tables , changes his mind and cancels it with
} > control-c. This has brought down the database. We're using 7.14 UD1 on
} > an HP K460/T6600. Is there any way to prevent this? We have an 80
} > gigabyte database.
}
} If interrupting a single session can bring down your database (I presume
} you mean your OnLine system) you have bigger problems. However, the
} easiest solution is for the 4GL programs to include the following:
}
} options
} SQL interrupt on
}
} Now, when the user pressed CTRL-C while the program awaits a query, the
} program will get an error message to the effect that "Query interrupted
} by user". (No, I don't know the error number! Do I look that kind of
} total twit? ;-)
}
} --
} -- Jake (Never yelled "CROWDED THEATER!" during a fire)
} +------------------------------------------------------------+
} | The expedient performance of a task with excessive concern |
} | regarding its duration-to-completion engenders a virtual |
} | certainty of diminished benefit therefrom. |
} | -- Benjamin Franklin (but he said it in 3 words) |
} +------------------------------------------------------------+
}