Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Paul Watson — — source: Usenet: comp.databases.informix
This sounds more like a syntax error, i.e. your encrypted data
has a quote in it. Look at the statement Perl is trying to execute
Brian McLaughlin wrote:
>
> Hi all.
>
> I have two Informix servers -- a production box and a test box. Passwords
> to our vendor's software are stored encrypted in a char(20) column. I want
> to copy passwords from production to test. I've written a perl script to
> fetch the password from production and I want to put that password into the
> same table/column on the test box. The problem is that the encrypted
> passwords have non-ascii characters.
>
> update user_mst set access_code = "blahblah" where id="235112">
> This update command gives me this:
> DBD::Informix::db do failed: SQL: -202: An illegal character has been found
> in the statement. at ./3000create.pl line 27.
>
> How can I copy the contents of one char column to another if the data
> contains "illegal characters" ??
>
> Thanks,
>
> Brian McLaughlin
> George Fox University
> (503) 554-2587
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.