Every company has a specific set of password policies for its database system. Depending on the policies, the password expires at a specific date and time. Unless the password is reset, the Adaptive Server drivers connected to a database throw password expired errors and suggest that the user change the password using isql. The password change feature enables users to change their expired passwords without having to use another tool.
To change your password, set these two connection properties:
oldpassword – the current password. If oldpassword contains a value that is not null or an empty string, the current password is changed to the value contained in pwd.
pwd – contains the value of the new password entered by the user. If oldpassword does not exist or is null, pwd contains the value of the current password.