A new isql option -X enables both extended password encrypted connections and password encrypted connections without plain text password reconnection. The password-enabled connection proceeds according to server capabilities:
If the server can handle both extended password and password encryption, extended password encryption negotiations are used.
If the server can handle password encryption only, password encryption negotiations are used.
If the server cannot handle password encryption or extended password encryption, the first connection attempt fails and the client attempts to reconnect using a plain text password.
The option -W disables both extended password and password encrypted negotiations.