• %lookup: Read first file store in array

    I want to read my first file store in array then add QTY in second file through array and then lookup in my third file to update or write. How can I do that?

    PREETYKAUSHIK15 pointsBadges:
  • QSORT issue in RPGLE program

    I added QSORT logic to my RPGLE program. This is the first time I've tried using this. I have the BNDDIR('QC2LE') in the H specs, along with DFTACTGRP(*NO). The program compiles without error. But when I run the program, it errors CPF4131 on my 'open' file statement. I followed similar logic to:...

    Decouser5 pointsBadges:
  • RPG/36 or RPG II or RPG/400 sample program

    Hi I need to write an RPG program that reads a program-defined file; does not use the program cycle, and outputs to a program-defined Disk file using either a WRITE or EXCPT. I am a 30-year RPG programmer who knows RPGIV, but I have forgottem how to code program-defined output files. Thanks, Stoney

    Stoney90335 pointsBadges:
  • IBM i authentication required for relay

    We have an application running on IBM i which used to send mails. We are using a third party email service. I wish to send email from IBM i but i received an error "550 Authentication is required for relay ". How can I give this authentication?

    Sureyz2,825 pointsBadges:
  • File Level identifier Vs. Record Format Level Identifier vs. Member level identifier

    Hi,   Please let me know the difference b/n File Level identifier, Record Format Level Identifier and Member level identifier with an example

    AS400B20 pointsBadges:
  • List out only lckw jobs from the active job list

    Hello, Does anyone have any ideas on how I can list out only the active jobs that have a status of lckw. It would be great if I could get that list sent to a physical file. Any suggestions are welcome. Thanks all.

    bp0144275 pointsBadges:
  • Installing the missing options in SS1 IBM i

    Recently we have upgraded our IBM OS from 6.1 to 7.2. We have used image catalogs for the upgrade. Now I need install SS1-option 47 which we have missed to install it. How can I do that with the Image catalog or via any other option?

    Sureyz2,825 pointsBadges:
  • iSeries Temperature Warning

    What message(s) does the iSeries issue when a critical temperature is reached within the case?

    mwking699225 pointsBadges:
  • BPCS Inventory activation date

    Is there a BPCS native file that shows the date in which a lot changes from status "H" to status "A"?

    ricardoguadarrama5 pointsBadges:
  • How to know from all where a program (*PGM) is called?

    PGM1 calls PGM2 can be known by DSPPGMREF. PGM2 is called by PGM1 (and others, if any), any command for it?

    rajat01110 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER220 pointsBadges:
  • Position to in subfiles

    Subfile type -Load All SFLRCDNBR(cursor) If I mention * top also as parameter in SFLRCDNBR, when I take option against any row nd return to initial screen, the selected row will be displayed as first row in the page. So I prefer using cursor as the parameter of SFLRCDNBR as it always points to the...

    NicyChn140 pointsBadges:
  • Is RPG quicker than SQL to update ALL records

    We update a few fields in every record on a file with over 13 million records. Masking a copy of production data on a performance test environment. It is run on a two processor 595 box under OS7.1. The job runs for about 36 hours. If I wrote an RPG program, I would open the file non-keyed to...

    ShadowProgrammer15 pointsBadges:
  • How to pass numeric data to CL program from AS/400 command line

    Hi All, I want to pass numeric data of length (8 0) to my CL program while calling from AS/400 command line but program is not receiving correct value into the program. Can anyone please help me how to pass numeric data?

    Mohan K695 pointsBadges:
  • Display output of RPG program in physical file

    I want to display output of my RPG program in a new physical file. How can I do that?

    PREETYKAUSHIK15 pointsBadges:
  • Exit a macro from inside a macro (iSeries AS/400)

    How do I exit a macro while it is running if it runs into an error in iSeries AS/400? I have script that checks to see if the cursor is in a specific position and if it isn't I have a message box pop up telling the user to stop the macro, but how do I have it just exit instead?

    jasunderland15 pointsBadges:
  • Performance issue if we have server with disks of varying capacity on iSeries server

    Will there be performance issue if we have server with disks of varying capacity on iSeries server?

    JohnsonMumbai1,445 pointsBadges:
  • System i Navigator will not start

    System i Navigator will not start. My Event Viewer indicates that MSVCR80.DLL has errored out. I have already tried repairing and removing Client Access with no results. Here is the event data: Log Name: Application Source: Application Error Date: 8/19/2017 8:18:21 PM Event ID: 1000 Task Category:...

    DDEFILLIPO5 pointsBadges:
  • AS/400 screen display

    How do we change the screen's display? The top of the screen shows "Session A [24 x 80]. We need to be able to show more of the information that resides well to the right of the display. The only way we can view that info is to do a "print screen" and paste to Word. We'd like to be able to view all...

    BERNDPAULHANS0 pointsBadges:
  • AS/400 entire system back up

    Below are the steps, I am taking for entire system back up: Initialise tape End all subsystems Go Save-> 21 Now question comes, how to make your system up again after above steps?

    ayushgarg185 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