RE: Another week, another SQL request...

Just to disprove this I created a table and all - this code is TESTED!

update rob/duh2
set currency = 'EUR'
where currency in('FRF', 'IEP', 'DEM')
1 rows updated in DUH2 in ROB.

Rob Berendt

==================
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Darren Taylor"
                    <Darren.taylor@cosalt-clo       To:     
<midrange-l@midrange.com>
                    thing.com>                      cc:
                    Sent by:                        Fax to:
                    midrange-l-admin@midrange       Subject:     RE: Another 
week, another SQL request...
                    .com


                    12/13/2001 12:13 PM
                    Please respond to
                    midrange-l






>From experience Steven, you cannot do a LIST in SQL.

Do the statement something like

UPDATE <CUSTOMERFILE> SET <CURRENCY CODE> = 'EUR' WHERE
<CURRENCY CODE> = 'FRF' OR
<CURRENCY CODE> = 'IEP' OR
<CURRENCY CODE> = 'DEM' BLAH BLAH.

Hope this helps.

Darren


-----Original Message-----
From: steven.donnellan@simonjersey.com
[mailto:steven.donnellan@simonjersey.com]
Sent: 13 December 2001 17:06
To: midrange-l@midrange.com
Subject: Another week, another SQL request...


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
On 1st January most national currencies in Europe will disappear to be
replaced with the Euro, and so we need to SQL our customer files...
Is it possible to do an SQL along the lines of;
UPDATE CUSTOMER FILE SET CURRENCY TO 'EUR' WHERE CURRENCY LIST 'FRF'
'IEP'
'DEM'....
you get the idea.

Thanks in advance for your help, and a special thank you to the previous
poster who drew my attention to the SQL Cookbook download. (If you want
a
copy, do a search for it on GOOGLE.COM and you'll be there in a jiffy!)

Steven Donnellan
AS/400 Systems Manager
IBM Certified Specialist - AS/400 Professional Operator
Simon Jersey Ltd

http://www.simonjersey.com

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete
it immediately and notify the sender, do not discuss or disclose the
contents.
The views expressed in the e-mail are those of the author and not
necessarily those of Simon Jersey Limited.
**********************************************************************
--



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



Security Warning: This e-mail has been created in the knowledge that
Internet e-mail is not a 100% secure communications medium.
Cosalt Workwear accept no liability for any claims arising as a result
of using this medium to transmit information.

By reading this disclaimer please accept that Cosalt Workwear has swept
the transmission for computer viruses with e-sweeper screening service &
anti-virus software and by using the latest definitions of antivirus.

Should you receive this email in error or have any problems please
notify Cosalt Workwear: Administrator@cosalt-clothing.com or Tel:
(++44)01942 898800.

Please feel free to visit our website: www.cosalt-clothing.com



Security Warning: This e-mail has been created in the knowledge that
Internet e-mail is not a 100% secure communications medium.
Cosalt Workwear accept no liability for any claims arising as a result of
using this medium to transmit information.

By reading this disclaimer please accept that Cosalt Workwear has swept the
transmission for computer viruses with e-sweeper screening service &
anti-virus software and by using the latest definitions of antivirus.

Should you receive this email in error or have any problems please notify
Cosalt Workwear: Administrator@cosalt-clothing.com or Tel: (++44)01942
898800.

Please feel free to visit our website: www.cosalt-clothing.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.