Re: SQL vs Native

[Alan Campin <alan0307d@xxxxxxxxx>]

In Darren example, he is doing a select and then an update so he is
accessing the record twice. Jon was saying performance could be slow. What
happens if you are using a "Where Current Of" and "Update of" clause?

On Thu, Aug 18, 2022 at 9:22 AM Darren Strong <darren@xxxxxxxxx> wrote:

> You can still do the equivalent of a chain, update and write in SQL.
>
> Chain equivalent:
> select fld1 into :FLD1
> from file1
> where condition1=:KEY1
> fetch first row only
>
> Update:
> Update file1 set FLD1=:FLD1
> Where condition1=:Key1
>
> Write:
> Insert into file1
> (FLD1)
> Values(:FLD1)
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg
> Wilburn
> Sent: Thursday, August 18, 2022 10:05 AM
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: SQL vs Native
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>
> I'm developing logic to create a "transactional" file/table in an
> existing  RPG program that creates labels.
> I'm trying to capture information about the labels we produce using a
> service program procedure and SQL.
>
> The catch is that the users will, on occasion, recreate/reprint a set of
> labels.  So I need to ensure I'm not creating duplicate transactions.
>
> With native access, I would simply CHAIN then UPDATE or WRITE based on
> %FOUND.
> With SQL, I would have to do a DELETE then INSERT for each record.
> Just wondering if there's an alternative to the SQL method?
>
> I'm trying to go 100% SQL for file access.
>
> Thanks,
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com