Re: Help with SQL or ILERPG

[James Perkins <jrperkinsjr@xxxxxxxxx>]

You should just be able to with it standard SQL. Something like this I think
would work.

UPDATE contacts
SET email_address = SUBSTRING(email_address, 1, LOCATE('@',
email_address))|| 'newdomain.com'
WHERE SUBSTRING(email_address, 1, LOCATE('@', email_address)) = '
olddomail.com'

--
James R. Perkins


On Thu, Oct 28, 2010 at 13:06, Jack Kingsley <iseriesflorida@xxxxxxxxx>wrote:

> I have a file with a field called contacts.  The contacts field holds
> varying length email addresses.  I want to use the @ as the key to grabbing
> all of the email address content prior to the @ sign and then holding it in
> a variable or ds.  Then I need to add on a new domain name to all of the
> records.
>
> So if I had bob123@xxxxxxxxx    and
>                david67899@xxxxxxxxxxx
>
> I want it to be like this
>
> bob123@xxxxxxxxxxxx
> david67899@xxxxxxxxxxx
>
>
> Could I do this with SQL insert or can I only do this with ILERPG.
>
> Thx.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.