SAP IQ 15 and above allows users to change their password using "NEWPWD" dbisql connection string parameter
1. Create user
(DBA)> create user myuser identified by sql
2. login to SAP IQ server as myuser
$ dbisql -c "uid=myuser;pwd=sql;eng=iqmpx1010c" -nogui
(myuser)> quit
3. Change myuser password using "NEWPWD" connection string parameter
$ dbisql -c "uid=myuser;pwd=sql;NEWPWD=newpass;eng=iqmpx1010c" -nogui
(myuser)> quit
4. Connect to SAP IQ server as myuser to confirm that changed password is working
$ dbisql -c "uid=myuser;pwd=newpass;eng=iqmpx1010c" -nogui
(myuser)> exit
"NEWPWD" connection string can also be used to change expired password without DBA intervention
1. create user with login policy root and the password expires on next login
(DBA)> create user myuser identified by sql login policy root force password change on
Execution time: 0.083 seconds
2. User can change his password using "NEWPWD" connection string parameter
$ dbisql -c "uid=myuser;pwd=sql;NEWPWD=newpass;eng=iqmpx1010c" -nogui
(myuser)> quit
3. Confirm user can login using changed password.
]$ dbisql -c "uid=myuser;pwd=newpass;eng=iqmpx1010c" -nogui
(myuser)> quit
