DSXchange

Hi,
I am trying to connect to SQL Server. I am getting the following error when I run the job.

Unrecognized argument: &

But if I view data, all the arguments are working fine. I am using ODBC stage for Database connection.

I appreciate any idea.

Have a great day!
Thanks
Bhargava

Got it,
The issue with the password containing "&" symbol within it. Unix treats this as a command. So we requested our DBA team to change the password and everything works fine now.

Have a great day!
Thanks
Bhargava

DS PX 7.1, AIX, DB2

I had that issue with a DB2 Entreprise Stage password parameter. I discover that it was my Copy/Paste (mean use Ctrl-C/Ctrl-V) that it didn't works. When I wrote manually the password it work fine

The DataStage manuals specifically alert you to the fact that "&" and "#" characters require special handling.

i believe the passwords having special characters such as "%","-" , should be enclosed within double quotes.,"passw&o%r-d"