Unrecognized argument: &

kavuri · Post by **kavuri** » Thu Jul 14, 2011 9:51 am

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

kavuri · Post by **kavuri** » Thu Jul 14, 2011 12:34 pm

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

cgi_bi · Post by **cgi_bi** » Fri Oct 14, 2011 10:33 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Oct 14, 2011 3:11 pm

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

pandeesh · Post by **pandeesh** » Fri Oct 14, 2011 11:53 pm

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

DSXchange

Unrecognized argument: &

Unrecognized argument: &

Re: Unrecognized argument: &

An hint