Re: LF question

Hi,

I also never had a problem with an LF built over a SQL table.

I fact - that technique is quite common and some of the gurus (e.g. Birgitta) even recommend it as a way to modernize your database without breaking (or even have to recompile) your existing RPG programs.

We do that a lot - add an ID primary key and created/changed fields to the table - and use LFs with the old record structure over those tables. We even create a LF with the same name as the old PF - so everything works, as before - and you can use the new table and have all the nice things that a native SQL table can do.

HTH
Daniel

Am 02.04.2025 um 15:44 schrieb Vern Hamberg via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

Agreed. Now one of those things is a field list and a key - that is now possible when creating an index, because we can specify the columns to be returned.

I generally have no problem with creating an LF over a table. I need to see an example where something did not work right - I need more than vague statement without a clear foundation.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.e2TziMe5.EUY8eAwW@centurylink.net> CAAC (COMMON Americas Advisory Council) IBM Influencer 2023

On 4/2/2025 7:30 AM, Justin Taylor wrote:
Generally good advice, but there are a few niche things that DDS LF can do
that DDL can't.

"Do not repeat the tactic that gained you a single victory, but let your
tactics be dictated by the infinite variety of circumstance."

On Tue, Apr 1, 2025 at 3:08 PM Patrik Schindler<poc@xxxxxxxxxx> wrote:

Hello Doug,

Am 01.04.2025 um 18:41 schrieb DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx>:

I have a LF built over a DDL-Table. The DDL table is defined without a

key

[Arrival].

The LF has an Item Number field defined as Unique.

When I compile the LF, the LF allows all operations except a Write
operation.

Does anyone know where it is documented what causes this? It's not the
first time I have seen it. Why would you not be able to add records to a
LF that would be written to its PF? I have no idea if the Unique key on
the LF causes this but wanted to include it in case.

I have no precise answer to your question, but a general advice (from a
rookie, sort of): Just don't mix DDL objects with DDS derived objects. Just
don't.

In the last few weeks I was learning to embrace SQL on much newer IBM i
releases, while trying to stay in known waters. It gave me headaches all
over. So many possible pitfalls and corner cases with sometimes confusing
error messages.

Don't mix them, and you'll be fine.

My $.02. :-)

:wq! PoC

--
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.