Re: RPGSQL update one column of a field.

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Although the syntax is "not quite" SQL, the idea of using CONCAT is not
that off the mark. In some languages the '|' character does not map as the
SQL concatenation operator. If you are thinking of using your statement
outside of the US you could write it as:

set fielda =concat(substr(fielda, 1, 99), '*')

Regards,
Luis

On Sat, Oct 14, 2017, 08:48 Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
wrote:

> You are right, my mistake, I used RPG notation instead of SQL notation.
>
>
> Paul Therrien
> Andeco Software, LLC
> paultherrien@xxxxxxxxxxxxxxxxxx
> 225-229-2491
>
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lynne
> Noll
> Sent: Friday, October 13, 2017 9:45 PM
> To: RPG programming on the IBM i (AS/400 and iSeries)
> <rpg400-l@xxxxxxxxxxxx>
> Subject: Re: RPGSQL update one column of a field.
>
> In SQL, not RPG
>
>
> set fielda =substr(fielda,1,99) || '*'
>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>
>
> ________________________________
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> on behalf of Paul Therrien
> <paultherrien@xxxxxxxxxxxxxxxxxx>
> Sent: Friday, October 13, 2017 9:33 PM
> To: 'RPG programming on the IBM i (AS/400 and iSeries)'
> Subject: RE: RPGSQL update one column of a field.
>
> Update filea set fielda = substr(fielda : 1 : 99) concat '*'
>
>
> Paul
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth
> Martin
> Sent: Friday, October 13, 2017 9:19 PM
> To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
> Subject: RPGSQL update one column of a field.
>
> I expect I am making a simple task way too complicated.  There is a 100
> character field in a record.  I wish to update the existing data by
> overlaying an asterisk ( * ) onto column 100
>
> Something like    ... set fieldA = substr(fieldA: 100) = "*" ...
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD