Although the restriction of a logged-on display terminal applies to the starting of ISQL, it does not apply if a user disconnects after starting ISQL. For example, if you have an EXEC that starts ISQL and then executes a number of ISQL SELECT statements, you can disconnect your display terminal after ISQL is started and the remainder of your SELECT statements are executed.
Avoid using commands and statements that result in the issuance of ISQL decision-type messages. For example, stacking a SET AUTOCOMMIT OFF command causes the following message to be issued:
ARI7602D You are in a logical unit of work. Type COMMIT to
have a COMMIT issued for you or ROLLBACK to
have a ROLLBACK issued for you.
Your response to this message cannot be accepted from the command stack because of the interactive design of ISQL. You must type the response yourself.