Hi All,

I am facing problem when trying to connect to database.

#!/bin/bash

db2 "connect to QA_DB user db2admin using admin!@#"
ls
db2 "select count(*) from ORDER"
db2 "connect reset"


I am getting error:
-bash: !@#": event not found

Can anyone please solve my problem.

You have to escape the special characters or your shell (bash) will try to interpret them. One approach is to put single-quotes around the CONNECT command.

Hi Stolze,

Thanks for reply I tried by putting single-quotes but getting error

[db2usr1@ps0259 ~]$ db2 'connect to QA_DB user db2admin using admin!@#'
SQL0104N An unexpected token "!" was found following "ADMIN". Expected
tokens may include: "NEW". SQLSTATE=42601


Can you please suggest something else how to escape these special characters.

Try a '\' as escape character.

Other than that, don't use an exclamation mark in passwords...

I also tried with \ but

[db2usr1@ps0259 ~]$ db2 'connect to QA_DB user db2admin using admin\!@#'
SQL0104N An unexpected token "!" was found following "<identifier>".
Expected tokens may include: "NEW". SQLSTATE=42601



I have to use ! sign in password because thats the requirement.

if u can suggest somethine else then it will be great for me.

Actually, I think if you use special characters in the password you also need to enclose the password itself in quotes, so it should end up like this:

yes it worked.

Thanx a lot