Justin,
Parameters in SQL are separated by commas (,) , not by semicolons (:) .
Best regards,
Luis
Sent from my Moto G phone. Please excuse my brevity.
On Oct 16, 2017 10:57, "Justin Taylor" <JUSTIN@xxxxxxxxxxxxx> wrote:
Are you talking about this:
Update filea set fielda = substr(fielda : 1 : 99) concat '*'
If so, why is that "not quite SQL"?
-----Original Message-----
From: Luis Rodriguez [mailto:luisro58@xxxxxxxxx]
Sent: Saturday, October 14, 2017 8:07 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx
Subject: Re: RPGSQL update one column of a field.
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
--
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
midrange.com
