On Dec 10, 2022, at 9:53 AM, gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
I have a phisical file with two key fields created from DDS for compile my
RPG program; this file is then duplicated with CRTDUPOBJ to Qtemp and then
via "SQL Create or Replace", populated with records/rows, but in this way
(SQL Create or Replace) i lost the key fields; the file became a nokeyed
create or Replace table qtemp.oc32W AS (
WITH pr AS ( bla , bla , bla )
ON REPLACE DELETE ROWS
Is there any way to avoid it (lost key fields ??)
Thanks in advance
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,
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.