RE: RPGSQL update one column of a field. -- RPG400-L

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