Re: SQL Possibily Question

wrote:

I have a list of numbers (AP#), Claim#. --> list

In the file F0411 the AP# is stored in the RPRMK field.

I need to update each record in the F0411 where the list.AP# =
F0411.RPRMK

F0411.RPURAT with the list.Claim#

field and set F0411.RPDDJ with
120366, (JDE format of 12/31/2020)

Can this be done in SQL?

If so please show me how.

Daniel E. 'Danny' Hayes
Senior JD Edwards Developer
813 901-2150 x133154
[cid:image001.png@01D18A63.3B5B0030]
9119 Corporate Lake Drive | Tampa Florida 33634 | www.carecentrix.com<
http://www.carecentrix.com/>


________________________________
This communication is intended only for the use of the individual or
entity named as the addressee. It may contain information which is
privileged and/or confidential under applicable law. If you are not the
intended recipient or such recipient's employee or agent, you are hereby
notified that any dissemination, copy or disclosure of this communication
is strictly prohibited. If you have received this communication in error,
please immediately notify CareCentrix Compliance Hot Line at (877)
848-8229 and notify the sender by electronic mail. Please expunge this
communication without making any copies. Thank you for your cooperation.
--
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: 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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.