• AS/400 SQL Update for matching records

    I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...

    Marshphil5 pointsBadges:
  • Maximum number of records that can be stored

    What is the Maximum number of records that can be stored on an as400 data file.

    JohnsonMumbai1,160 pointsBadges:
  • Mysterious AS/400 record locking

    We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...

    bogeybetsy560 pointsBadges:
  • Extracting Only Numbers from String in AS400

    I have thousands of address records in AS400 and need to extract only the numbers from the records. Example: 5770 South 900 West #2 and I want it to look like 57709002 Is there any way to do this in AS400? Thank you.

    Bolillo12345 pointsBadges:
  • must reorganize huge file over thanksgiving

    We have a file with 4 million active records and 200 million deleted records , I want to reorganize on Thanksgiving. Plan is to copy out (cpyf) , clrpfm, then copy back (cpyf). My question is will the 'clrpfm' run for hours ??

    DAIRYPGMR20 pointsBadges:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following