• QAQQINI File

    What is the QAQQINI file? Does it have to be in every library? I saw someone mention ignore_derived_index and setting it to yes. My files don't even have that value. I have the file in QSYS, QUSRSYS, and one of our test libraries. Are there any other options I should worry about? Currently, any...

    Dcantwell465 pointsBadges:
  • Non Subfile Field Not Changing When Doing an EXFMT

    This should be a simple thing to do but it is not working. I have an RPG program in which the user enters a warehouse code and presses enter. If the code is valid, it then populates a field in the record with the warehouse description. If the user changes the code to an invalid warehouse, I turn on...

    GHENDER175 pointsBadges:
  • Automatic Publish web page when excel data changes

    I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the...

    Gerrib150 pointsBadges:
  • Retrieving error incurred(if any) from the jobs using an independent process- AS/400

    Hi, we have some batch jobs running for the entire day.Can someone tell me what will be the best way to monitor the errors that got spooled in a joblog & retrieve the same using an independent process ? If possible, please let me know the steps that  can be best suited to cover the most of...

    160780 pointsBadges:
  • DSPF & SNDRCVF

    In a CL, I need to define two files. One file is a display file and the other is a physical file. Then I need to do a RCVF to pass the retrieve data in the display file then use the physical file. When I try to compile the pgm using the RCVF, it does not recognize the variables in the display file...

    SOUTHEAST30 pointsBadges:
  • Merge two Physical Files using Logical File

    I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.

    nhewage50 pointsBadges:
  • AS/400 syslog agent or daemon

    I'm looking for software that we can load on our AS/400s to send their Journals to a Linux Syslog server.  Does anyone know of a package that will do this?  I'd prefer a freeware solution.

    Jcoxen5 pointsBadges:
  • CFINT

    My company is experiencing a serious performance problem due to CFINT. I'm sure we've reached our threshold and now IBM is making us pay the penalty. We have ordered a trial version of the GoFaster product, but none of us have any experience with such a package. Have any of you used this product or...

    JasonWV5 pointsBadges:
  • Open IT Forum: What cloud concern do you need addressed?

    Will all of the buzz surrounding the cloud - no doubt amplified by Vivek Kundra's push to the cloud - are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know...

    MelanieYarbrough6,345 pointsBadges:
  • Highest RRN in a Subfile

    Does anyone have the positions for the highest RRN on a Subfile? This was found in the old CPF programmer’s guide a hundred years ago. It was right after the Lowest RRN currently displayed on the subfile. This info comes from the INFDS. Are there examples?  

    Nickhutcheson165 pointsBadges:
  • delete old IFS files

    I have been asked to create an automatic procedure which cleans out (ie delete) files older than 6 months. Transactionfiles keep coming into the system, and after having been processed (read) they are moved to an IFS directory 'archive'. We now have more than 90.000 files from last 26 months. I...

    DanTheDane2,555 pointsBadges:
  • Is anyone user Mantis/400 bug tracker / help desk software?

    I would be interested in hearing from anyone who is using Mantis/400 on an IBM i running i5/OS 6.1. There is a good article on the topic but is is from 2007.  We sure would like to hear from someone who has had recent experience with Mantis.

    WoodEngineer6,045 pointsBadges:
  • TCP3436 – AS/400 printing

    I have an Epson DLQ3500 printer set as a remote OUTQ. It is intermittently stopping, sometimes mid print, and I get TCP3436 as the message Message . . . . : No response from remote host system within open time-out. Cause . . . . . : An open request was sent to a remote host system, but that host...

    KasMcc230 pointsBadges:
  • Can you mass change file libraries in AS/400 query?

    Here's a tough one. We currently have a few hundred user defined queries. Created with the WRKQRY command. We are looking at a software upgrade that now puts the production data in a new library. When a user creates a querey and leaves the library *LIBL,  it defaults in the first library it finds...

    ToddN20006,360 pointsBadges:
  • AS/400 query join

    I have 2 files I am joining. The primary file is an employee master. The secondary is a history file with the employees time punches. Using a type 1 join it works fine. The user wants a change to the query to show the employees who did not punch in for a specific day as well, which would be a type...

    ToddN20006,360 pointsBadges:
  • Date field default value – RPG

    I have a date field defined in a file to hold the date we expect an order to be delivered. However there may be no orders open for an item and I expect I will get an error if I then leave this field blank. Any ideas on how I can handle this to avoid the error?

    FrankStacey105 pointsBadges:
  • What does a Logical File in AS/400 contain?

    Does it contain data. If not then why do we need a member for alogical file?

    AXM5 pointsBadges:
  • AS400 File Transfer

    What are all the ways there to send file to another server/ system in AS400?

    rajeshece1,215 pointsBadges:
  • Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 pointsBadges:
  • CPYSPLF from one profile to another

    Is there a command thru which we can copy the spool file from one profile to other?

    PRIYAS40 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