I want to change my password via the IBM Db2 SQL Command via the SQL Commander
Product: DbVisualizer Free 13.0.1 (build: 3263) OS: Windows 10 OS Version: 10.0 OS Arch: amd64 Java Version: 11.0.14 Java VM: OpenJDK 64-Bit Server VM Java Vendor: Eclipse Adoptium Java Home: c:\program files\dbvisualizer\jre DbVis Home: C:\Program Files\DbVisualizer
Connect to database_name USER my_user USING oldpassword New newpassword confirm newpassword
I get the following error returned
13:17:47 START Executing for: 'TST' [DB2 LUW] 13:17:50 INFO Physical database connection acquired for: TST 13:17:50 FAILED [CONNECT - 0 rows, 0.106 secs] [Code: -104, SQL State: 42601] An unexpected token "Connect to database_name" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<audit>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.28.11 Connect to database_name USER my_user USING oldpassword New newpassword confirm newpassword; 13:17:50 STOPPED Stopped because of errors 13:17:50 END Execution 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.106/0.000 secs [0 successful, 1 errors]
IT seems DBVisualizer is blocking / does not support the CONNECT statement syntax.
I am following the IBM Db2 recommendation here to allow the user to change their password when the password expires as per the security rules established on the system. I would like the users to be able to do this from DbVisualizer rather than having to log in separately outside of DbVisulizer, and to not need to use others tools like ssh into the system or putty sessions as this just confuses users.
Michael Feehilly
Hi Folks,
I want to change my password via the IBM Db2 SQL Command via the SQL Commander
Product: DbVisualizer Free 13.0.1 (build: 3263)
OS: Windows 10
OS Version: 10.0
OS Arch: amd64
Java Version: 11.0.14
Java VM: OpenJDK 64-Bit Server VM
Java Vendor: Eclipse Adoptium
Java Home: c:\program files\dbvisualizer\jre
DbVis Home: C:\Program Files\DbVisualizer
Connect to database_name USER my_user USING oldpassword New newpassword confirm newpassword
I get the following error returned
13:17:47 START Executing for: 'TST' [DB2 LUW]
13:17:50 INFO Physical database connection acquired for: TST
13:17:50 FAILED [CONNECT - 0 rows, 0.106 secs] [Code: -104, SQL State: 42601] An unexpected token "Connect to database_name" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<audit>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.28.11
Connect to database_name USER my_user USING oldpassword New newpassword confirm newpassword;
13:17:50 STOPPED Stopped because of errors
13:17:50 END Execution 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.106/0.000 secs [0 successful, 1 errors]
IT seems DBVisualizer is blocking / does not support the CONNECT statement syntax.
I am following the IBM Db2 recommendation here to allow the user to change their password when the password expires as per the security rules established on the system. I would like the users to be able to do this from DbVisualizer rather than having to log in separately outside of DbVisulizer, and to not need to use others tools like ssh into the system or putty sessions as this just confuses users.
https://www.ibm.com/docs/en/db2/11.1?topic=details-maintaining-password-information
I get the same error if I use the following version of the IBM Db2 connect statement
connect to database_name USER my_user change password
Thank You