IBM Support

Unable to Update Key Fields using UPDDTA

Troubleshooting


Problem

A user is unable to make changes in key fields, either through the physical or logical file.

Resolving The Problem

A user is unable to make changes in key fields, either through the physical or logical file. Other users are able to change the same key field(s). Ask if they have recently created a DFU program. If so, the problem might be with a setting called Changes allowed. This setting is set when you create or change a DFU program, and used by all future DFU programs. It is not retained and used by individual DFU programs, it is used by all DFU programs

To check the setting, the user must perform the following steps:
1. On a command line, type STRDFU and press Enter.
2 Select menu Option 3 - Change a DFU program, and press Enter.
3. If the name and library of the DFU program the user created are not all ready filled in, you should fill them in, and press Enter.
4. On the Define General Information/Indexed File screen, verify that Changes allowed is set to No:

Keys:
Generate . . . . . . . . . . . . . . . . . N Y=Yes, N=No
Changes allowed . . . . . . . . . . N Y=Yes, N=No
5. Change Changes allowed to Y, even if it is all ready Y, and press Enter.
6. Press F3 to Exit .
7. Verify that Save program and Run program are set to Y and press Enter.
8. Verify that you are able to change the key field(s).

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m3p000000F91aAAC","label":"Programming ILE Languages-\u003EUtilities"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Historical Number

626901694

Document Information

More support for:
IBM i

Component:
Programming ILE Languages->Utilities

Software version:
All Versions

Operating system(s):
IBM i

Document number:
684661

Modified date:
25 November 2024

UID

nas8N1011100

Manage My Notification Subscriptions