Re: SQL vs Native

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Last time I tested this it was way slower in SQL.  must re-do that test some day and see how things have changed.  SQL unlikely to match native still but might be closer.


Jon P.

> On Aug 18, 2022, at 12:22 PM, 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