RE: SQL Update ?

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Hmm, does the 341 need to change to something, also? if so, the combined
statement would take care of it, since it would never go back to previously
changed records.

And you would have only 5 copies to make in the script.

At 09:57 AM 4/18/02 -0500, you wrote:
>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.
>:
>:
>
>
>_______________________________________________
>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.