473,503 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2479
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
3628
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 was going to use the img tag with the alt...
9
9678
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 makes a tone with the speakers on and has a...
4
1987
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 assume that it is using the virtual SMTP server to...
2
1641
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 it, to show me there is an error, and the changes...
2
1749
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 when I try to write validation script. How can I...
8
13090
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 questions I have regarding making custom...
3
2027
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 text, which inadvertantly hinders the correct...
5
7100
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: struct Transient arrFromHdfNode(HL_NodeList...
31
1589
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, 16:14:04) on linux2 Type "help", "copyright",...
0
7205
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7287
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7353
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7468
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5596
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3170
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
747
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
401
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.