DFU (UPDDTA) and changing Keys

25 pts.
Tags:
AS/400
DFU
SQL
DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has update authority. The file is not being held by any process. As far as we can tell the file is not even being used by anything except the DFU. We need to change the field and sometimes can't. Any suggestions? We cannot sign-on to the remote system from our system and the user may not have SQL so we can't use that. Thanks in advance for any help. Tyrone


Software/Hardware used:
As/400
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is down to your DFU default settings. You need to STRDFU and create a dummy DFU program in QTEMP. Work through the prompt screens and you’ll see “Changes allowed” as an option. Set it to Y and in future you can change key values when you run UPDDTA.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    What do you mean by "sometimes"? Does it work "sometimes" depending on which file it is? Does it work for some users and not others? When it doesn't work for one user, does it work for any other user? If it didn't work for a user yesterday, does it work for the same user and the same key today?

    And what does "doesn't always allow us" mean? Is that simply a reference to "the user does not have access"? And what does "does not have access" mean? Is the key simply not shown? Is it shown but not input capable?

    How are the problem keys defined in the database? Are any of them generated keys? Are any of them 'foreign keys'? What are the relationships between the keyed files and other files?
    35,650 pointsBadges:
    report
  • ToddN2000
    Using DFU for changing data may not be approved if you get your data audited. As for not being able to change keys, it may be possible the file has the keys set to UNIQUE and you are trying to create a duplicate file key.
    133,740 pointsBadges:
    report
  • Splat
    The DFU definition may be part of the problem.  If it was created not to allow key changes it won't.
    12,895 pointsBadges:
    report
  • Bamba61
    This is group of files/Formats joined in one DFU. 
    It is working other people who has same authority.
    They can change Same key fields which i Cannot.
    Also I can Create DFU for any other file/s and can update Key fields. only on this instant, it does not allowed to update.
    Cheers 

    25 pointsBadges:
    report
  • Bamba61
    This DFU is always not allowed to update keys for this user, but allowed to other.
    Yes, key fields are visible but protected.
    This dfu is created to allow key changes.
    I understand Duplicate key problem, but that is not the case.


    25 pointsBadges:
    report
  • TheRealRaven
    "It is working other people who has same authority."

    That is almost certainly not true if everyone runs the same DFU. We need to see the authorities to the file(s?) for a working and a non-working user. If multiple files are involved, authorities to the underlying PFs should be included.
    35,650 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: