• 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

    mvrkrishna535 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?

    sivakesava280 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:
  • BI product

    We are using KBM software for our ERP system. We have a mandate to build a data warehouse so we can use a good BI tool to extract data. We would like to run this on our AS400. Does anyone have suggestions as to a good product for us to investigate?

    CharlieBrowne41,370 pointsBadges:
  • COBOL reading RPG created files

    I am trying to read a RPG created file with special characters in the data fields (EX: EP$DEPT,etc). Is there a way I can remap the fields in a COBOL program. I tried a logical mapping over the PF but when I rename the fields in the LF removing the $ sign, I get compile errors because the LF can't...

    Theraven35 pointsBadges:
  • Execute from a source member list

    I saw a colleague run something, and I know he built the user defined option (F16) "EX" in the WRKxxxPDM display, I don't know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan

    dinks5715 pointsBadges:
  • PRT01 is in MSGW

    When I check for the WRKCFGSTS, I am seeing this status: PRT01 * IPDS Offline or not yet available. Unable to vary on...

    didinu760 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