Re: Update a table from EXTNAME-defined data structure using search argument

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Some good points Rob...

But the work-a-round is the same as it should be for RPG RLA...  the DS
should not be defined using the physical table.  Instead, it should be a
view/LF with an explicit column list.

One of the advantages of SQL is that it allows you to disconnect the
physical layout of the data, but only if you use an explicit column list.

Charles

On Tue, Jul 19, 2022 at 7:40 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> You may want to rethink that.  Suppose you add derived columns, or those
> which have default values.  Examples include some of the timestamp, job
> user, etc columns used for temporal tables.  Do you really want to manually
> override these?  IDK if making these columns implicitly hidden would remove
> them from appearing in the data structure.
>
> But if you're sure you want to do that then google is your friend
> https://www.rpgpgm.com/2018/01/using-rpg-data-structures-with-sql.html
>
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
>           Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
>           Ft. Wayne, IN 46818
> http://www.dekko.com
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Alan Cassidy
> Sent: Tuesday, July 19, 2022 9:30 AM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: Update a table from EXTNAME-defined data structure using search
> argument
>
> 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.
>
>
> Good morning folks,
>
> I am updating a file. I have an externally defined data structure
> defined with EXTNAME().
>
> I can't find a specific reference anywhere, but is there a syntax to use
> that data structure to update the row in the table, like so, maybe?
>
> UPDATE  TABLE1  SET TABLERECD = :TABLE-DS WHERE KEY1 = VALUE1 AND KEY2 =
> VALUE2?
>
> I have just seven fields to list out, and I'm doing that, but I just
> wondered if there was a way to do the above (without having to input
> with an update lock)?
>
> Reason I'm asking is for the future, if I could set it up that way, it
> would make it easier to add changes to other columns, and maybe other
> thins.
>
> --Alan Cassidy
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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