RE: SQL Update ?

[Mark Allen <allenmark@xxxxxxxx>]

That's what I am going to do, the only problem (but its not mine) is
that for 300-xx-xx (changing to 341-xx-xx) there are already records in
the file with 341-xx-xx......

So until the central office guys fix that I am off the hook


Mark Allen
I.S. Manager
Wilkes Telephone & Electric
A Dycom Company
Phone: (706) 678-9565
Email: allenmark@nu-z.net
http://www.nu-z.net




:-----Original Message-----
:From: midrange-l-admin@midrange.com
:[mailto:midrange-l-admin@midrange.com] On Behalf Of Vernon Hamberg
:Sent: Thursday, April 18, 2002 8:48 AM
:To: midrange-l@midrange.com
:Subject: RE: SQL Update ?
:
:
:You might try RUNSQLSTM. You create a source member with all
:the statements you want to run. In SEU you could copy each
:statement, then change what you need.
:
:Each statement needs to be terminated with a semicolon (for
:some reason)
:
:make 55 copies of the statement. Less chance of fat finger syndrome
:
:
:At 03:20 PM 4/18/02 +0200, you wrote:
:
:>Mark,
:>
:>indeed, it should be
:>
:>update FILE set LCE = '341' || substr(LCE, 4) where
:substr(LCE, 1, 3) =
:>'300'
:
:_______________________________________________
: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.
:
: