472,353 Members | 2,064 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Exclamation point in password irritates DB2 CC?

aj
DB2 WSE 8.1 FP5
Linux Red Hat 2.1 AS

I am using a new more secure password for my instance owner
account, one which has an exclamation point in it.

Using CC, when I try to import or export or use any of the
various automated functions, I get:

SQL0104N An unexpected token "!" was found following
"<identifier>". Expected tokens may include: "NEW".

Explanation:

A syntax error in the SQL statement was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid..... <snip>

If I press the 'Show Command' button, copy the command to a
cmd-line CLP script, and let DB2 ask me for the password on the
cmd line, all is fine. So the problem is that the exclamation
point in the password irritates CC.

This is slowing me down... Any ideas?

TIA

aj
Nov 12 '05 #1
2 2416
I believe DB2 v8 fixpak 7 or later (also known as DB2 8.2) supports !
in authid's and passwords.

Nov 12 '05 #2
aj
ad******@ca.ibm.com wrote:
I believe DB2 v8 fixpak 7 or later (also known as DB2 8.2) supports !
in authid's and passwords.

Thanks Blair.

aj
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Guy | last post by:
I'd like so that when a user moves there mouse over an image (or clicks the image, either way it doesn't matter), I'd like some text to appear. I...
9
by: Neil Varshneya | last post by:
Hi, I've been having trouble trying to find the html code command for how to make the sign that when you click something wrong it flashes up and...
4
by: James Vitale | last post by:
Microsoft .NET 1.1 ASP.NET using VB.NET I'm using System.Web.Mail.MailMessage to create an email and an SMTPMail object to send the mail. I...
2
by: DraguVaso | last post by:
Hi, I have a DataGrid bound to an sqlDataAdapter. When I do a SqlDataAdapter.Update, on 1 row I got a red dot with a whie exclamation mark in...
2
by: philhege | last post by:
I'm using a third-party chat application. They require that form field names be formatted "SESSIONVAR!FIELDNAME". The bang is creating headaches...
8
by: Dennis C. Drumm | last post by:
I have ordered the book .NET Framework Solutions, In Search of the Lost Win32 API by John Paul Meuller which I think will help answer some of my...
3
by: rvanvolken | last post by:
After sending an email message formatted for HTML using the STMP Mail function within .NET, my message arrives with exclamation marks throughout the...
5
by: Sheldon | last post by:
Hi Everyone, I have defined a function: struct Transient arrFromHdfNode(HL_NodeList *nodelist, struct Transient retv); and in the code: ...
31
by: Mark Dickinson | last post by:
On SuSE 10.2/Xeon there seems to be a rounding bug for floating-point addition: dickinsm@weyl:~python Python 2.5 (r25:51908, May 25 2007,...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.