Re: LF question

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