• Quick way to delete x number of records from a file

    I just found a history file that has over 57 million records and is taking up a good share of disk space. This is a file that contains 1 field per record of mixed data. There is nothing that resembles a time stamp of any form in the record. I would like to at least delete the first 50 million...

    azohawk2,060 pointsBadges:
  • CPF5032 member already locked to this job

    I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be...

    GHENDER215 pointsBadges:
  • SAVLIB from V7R1

    I did a savlib from V7R1 system using tgtrls V5R4M0. When I try and restore to the V5R4 system, it says file was saved from a more recent release of the operating system. Am I missing another parameter on either the save or restore?

    kfrantish15 pointsBadges:
  • Write duplicate record to a PF

    A screen has one input field called number. whenever the number is inputted, the value gets stored in a file. The file has 2 fields, Value and Sequence. So, if any user has inputted '10', the files will store 10 as value and 1 as sequence. If any user inputs a value, which is already present in the...

    manju05310 pointsBadges:
  • How does the job user identity get set for a job

    In AS/400, how does the job user identity get set for a job?

    28390015 pointsBadges:
  • Access data on AS/400

    Hi all, I am auditing an AS/400 DB and I want to know what are the commands which allow users to access directly the DB of the AS/400? (like CHGFC, SQL queries and more..)

    dantlv5 pointsBadges:
  • Retrieve Job Start parameters to start it by script

    Hi Folks, I have a subsystem in which usually 40-50 jobs are working. Before the maintenance I should bring down all these jobs, because they are make some locks on files. At the end of maintenance windows I should start all of them manually... My question is: How to atomize this process? The...

    Motorbreath70 pointsBadges:
  • Reading members of a physical file

    Hi, Can somebody please help by providing the program code for reading all the members of a file using RPG or RPGLE program? Suppose a file has 3 members then how to read the records of all the 3 members in a file? Thanks!

    6r1,850 pointsBadges:
  • AS/400 setup on personal machine

    I am new to AS/400. I am very much interested in learning from administration to development, but I need help in configuring connection on my system itself. I have installed IBM Personal Communication, System I Navigator and IBM System i Access for Windows on my personal computer. Now I want to...

    Sanjeevsk15 pointsBadges:
  • Mimix DR hardware requirement

    What is hardware and software requirements for running Mimix DR?

    Shethchirag20 pointsBadges:
  • Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • AS/400, Mac running Parallels & Windows 7, PC5250 Emulator iseries access PCSWS037 error

    I have a Mac Air running Parallels 7 and Windows 7 with PC5250 to access AS/400. I get a PCSWS037 error (Initialization of the keyboard table failed) when I connect. And also get the PCSKBD110 error (The system keyboard is not supported) when I start my session. Any help fixing this would be...

    solomonmark10 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh50,095 pointsBadges:
  • Update causing reade to read the same record in RPGLE

    Hi Team, I have a critical issue. In RPGLE program, I have read a file then based on some condition I am updating the file if condition is not satisfied I am not updating that file. I am doing it in a do while loop. The issue I am facing is the record that has been updated is being read again....

    soundariya20 pointsBadges:
  • AS/400 print files stuck at RDY

    I am managing, but very unfamiliar with AS/400. I have a user who does not receive the printouts for her job. It looks as though the printouts are all stuck in RDY status on the Output Queue. If I look at our printers, there is a printer of the same name as the Output Queue. That printer is in END...

    HeyLeonardo5 pointsBadges:
  • User is unable to connect to AS/400.

    A user is trying to connect to AS/400 but keeps getting an error that he is unable to establish a connection with the server. Unable to connect to TCP/IP server.Winsock error 10061

    Shabari10 pointsBadges:
  • AS/400 Administration Training

    Can I download AS/400 to learn it? Is there a specific training I could use?

    JuliusWWalker5 pointsBadges:
  • Create user profile other than QSYS library

    Can we create user profile other than QSYS library or QSYS is default library for creating user profile?

    anand12345610 pointsBadges:
  • How to lock FTP user out of the rest of the IFS

    I have an FTP user that will upload files onto our box. When they connect they start in their /home/ folder. I want to make sure they can't get back to root '/' or anywhere else in the IFS. Preferably without creating a massive security maintenance workload as this expands.

    GregManzo660 pointsBadges:
  • iSeries mapped drive security

    I would like to set up a number of drives where user A can access folder A and User B can access folder B. Neither user can access the other users folder. I have tried making the folder authority specific to a user with public exclude. This has made not prevented access. I assume this is the...

    Fignon5 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.

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

Following