• Query in subfile with SFLNXTCHG

    I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing anything on to the subfile, the...

    RamvishakRamesh2,505 pointsBadges:
  • Code review checklist for AS/400 application

    Hi, As part of Unit Testing process documentation, I need to prepare 'Code review checklist' for AS/400 application. Request the members to please share the same.

    pammy12310 pointsBadges:
  • About CRTPGM command

    I have a module which has a copy book in it and when I am creating a main PGM with the command CRTPGM by giving the module name itself as the PGM name and binding the service programs, I am getting an error which says that the procedures which are defined in the copy book are not defined. How to...

    JSDHFKJHA335 pointsBadges:
  • RPGLE SETLL / READE for update getting record lock on different key

    We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match...

    SemiTechieGeo70 pointsBadges:
  • AS/400 Query – how do you split names in field into seperate fields

    Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I've tried everything I can think of, am out of ideas. Thanks in advance for your help

    sueshe4me5 pointsBadges:
  • How to display total of all the records that contain the same primary key in RPG4?

    How to display total of all the records that contain the same primary key in RPG4? e.g...                                                             Transaction number :4458 product no:      name        QTYonHand      quantity on order              ...

    Keo55 pointsBadges:
  • Data migration from AS/400 DB2 to SQL Server

    Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?

    Explorer1910240 pointsBadges:
  • How to find the copybook?

    Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M

    mvrkrishna555 pointsBadges:
  • Related to move array opration

    I have following example in rpg Movea ex1(1940) ex2(1920) here ex1 is an array of length 1940 and ex2 is a data structure of length 1920, if the move array operation performed, Is there any loss of information was there?

    sivakesava285 pointsBadges:
  • How do I convert a date in text format to a proper date with AS/400 Query

    I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access for Windows.

    PhilipX25 pointsBadges:
  • Change the user of a JOB

    Hello, I would like to know if it is possible to assign a running job to a different user than the one who ran it? Thanks.

    al7iss140 pointsBadges:
  • AS/400 Transfer of files

    Hi all, Is it possible to transfer the files through DDMF connection. Source system will have single file with single member. While transferring this file to target VPC, it should get added as member? Is that possible in DDMF? I don't see a member option given in DDMF.

    As400pgmmer305 pointsBadges:
  • Compiling error

    *** error in creating required objects for Batch program XXXXX The above messages appeared when I try to recompile a valid Batch Program. This program was error-free. Its purpose is to produce a Payroll Bank report to the spool file. I also have recompiled successfully both the physical files and...

    mofgps10 pointsBadges:
  • Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?

    Hello All, I ran into a roadblock writing a new purge process for my company. Here's the situation: I have 3 files that hold EDI Data that I need to purge: FILEA - Record Format FILEAR FILEB - Record Format FILEBR FILEC - Record Format FILECR All of the above files have the same record length,...

    Eric Witham690 pointsBadges:
  • RPG date calculations

    I need to add 28 days from the system date and output it into a file in the format mmddyyyy. I can not use free RPG or RPGLE. Could you help, please?

    Larisagas265 pointsBadges:
  • WRKPRB deleted logs

    In our system the WRKPRB message will last for 30 days. Now I want to see the deleted WRKPRB logs. Is there anyway to find that logs?

    didinu760 pointsBadges:
  • Parameter Passing: RPGLE to CMD to RPGLE

    Hello, I have an RPGLE program that I am using to call a command with 1 parameter. The parameter is a container number, 11 positions alphanumeric. I want to be able to run my RPGLE program, execute the command via QCMDEXC and receive/process that parameter within the same RPGLE. Is this possible?...

    Eric Witham690 pointsBadges:
  • SQL message with no records selected

    I have two user profiles, one will show data and the other does not when I do a simple Select * from myfile. I get a message, 'Syntax check found no errors.' I am *SECOFR on both profiles, library lists appear to be the same. Ideas anyone? Thanks in advance, Nick

    NickHutcheson11,380 pointsBadges:
  • Three way replication on MIMIX

    Hi, I have a question; we are planning to move our PR and DR to different location from existing one. Now on current location we have V5R4 and we are moving on V6R1 on new location where will have different network segment. We can’t keep down PR for more than 5-6 hrs. max. So what would be best...

    Shethchirag15 pointsBadges:
  • LANSA: Calling a subroutine from def_break command

    I have a function (I did not write it) that is calling a subroutine from def_break command and one field that is defined on the def_break command is not being cleared when break occurs. The last value of this field just repeats on the next break line. I ran this function under a debug and this...

    kamanie675 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