×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Thanks much Vern,
That's what I thought but wanted to confirm with you guys.
Thanks again!
Ashwani
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Wednesday, January 17, 2018 10:42 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: For update clause in dynamic SQL
Ashwani
I am certain you cannot use a host variable in this way. The documentation says that they are used where you want to bring in a value for a column.
It says that you cannot use them to identify SQL objects, such as a table or a view, and a column would probably be also an SQL object.
You can put the field name into a character string that is the entire statement, then prepare that or EXECUTE IMMEDIATE, I believe, if the statement qualifies for that command.
HTH
Vern
On 1/17/2018 10:33 AM, Singh, Ashwani (Pune) wrote:
Hello Guys,
I have to update a file field whose name will be known at run time can we use " For update of :field" clause if yes please let me know how to do that.
Thanks,
Ashwani
--
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
