• AS/400 Date Format DD-MM-YYYY

    Hi, I have a scenario. I need to create a physical file with date format of (DD-MM-YYYY).I am specifying with  *EUR/*DMYY  along with this I can't use the date separator. Kinldy let me know, how to achieve this.

    HABBIE895 pointsBadges:
  • Save physical file too small in AS/400

    I would save a PF (800G with about 3 billion records) and one of its logical file. OS is v6r1. However it said the save file is too small. I remember that this limitation of save file is 2T while the size of my physical file and logical file no more than 1 T. Anyone can help me? Thanks a lot.

    liushiqiang15 pointsBadges:
  • Send physical file in SAVF format via CDSND

    How to send physical file in SAVF format (Save file) from AS/400 server to other server via CDSND command?

    ssssssssssssssss115 pointsBadges:
  • AS/400: Add some fields in the physical file

    Hi! Actually I have a physical file containing 400,000 records. I just want to add some fields in that file and it is referred by many programs. I know that I can use CHGPF. But I'm a bit afraid to change a big database. What are the necessary steps I can take on these process and proceed further?...

    Sureyz2,825 pointsBadges:
  • Changing a physical file definition

    I’m trying to prove how this happened. The file in TEST has an old creation date on the object but it includes 2 new fields. So not done via recompile. Is there another way to change a file definition without recompiling? I suspect maybe SQL? Please keep it simple with any reply – I don’t...

    aceofdelts2,425 pointsBadges:
  • CDSND character mapping in AS/400

    Currently in our system, we are sending a physical file using CDSND to a UNIX system. In the physical file we have '[' charecter, but when this file is transferred to UNIX system this character is changed to Ã. I want to see the [ character at UNIX system, as àcausing some issue at UNIX...

    sivakesava285 pointsBadges:
  • Deleting the physical files without deleting logical files

    Hi, Can anybody tell me how to delete the physical file(PF-DTA) without deleting its dependent files (LF). Actually we are having Mimix running in our live and DR system, in the DR I want to delet PF only and resync with the live.

    Syedm180 pointsBadges:
  • Reducing Impact of increasing a field length of AS400 file

    I am currently working on a project where there is a file which has a field of length 3 (packed decimal). Under the project, we need to increase that length to 5 packed decimal.But this change is causing a lot of impact on the system as lot of programs and queries need to be changed/recompiled. Is...

    sanras12340 pointsBadges:
  • negative sign in physical file copy process

    this is regarding copy file.I have a physical file P1 and physical file P2. Now in P1 i have a zoned decimal field and in P2 i have a packed decimal field. let us assume i have the negative data in P1. after performig the CPYF to copy the P1 to P2, i am getting some junk characters ( '}', 'M', 'S'...

    sivakesava285 pointsBadges:
  • COBOL AS/400 – Using same field name from two different files

    Hi, I have modified a program by adding a physical file with fields fielda, fieldb and fieldc. I am also using its logical file in the program. I have redefined the physical file's record format and changed the fields name. I used redefined keyword in logical file and used filler and changed the...

    yagnasstar5 pointsBadges:
  • Pre run time array

    In my PF, one record is there with 40 fields and each field length is 2. Now I declared one array like this: D ARR      S  2  DIM(40) Now I want to move all the 40 fields data into array in a single statement. Can anyone help with this?

    421380 pointsBadges:
  • Altering keyfields inside RPG Program

    Hi all, I have a  Physical file PF with 5 different logical files (LF). PF don't have any keys at all. In RPG program I need to perform a CHAIN on this file with 2 key-fields in which 1 of the key is defined as key field in some LF's. But the other is not. Now I was asked to perform CHAIN without...

    Sai4AS4001,420 pointsBadges:
  • Convert spool file to physical file in AS/400

    How to convert result file to physical file?

    Ckishorekumarr25 pointsBadges:
  • Sort file based on a key in another file

    Here is a scenario. I have a balance file which has account number and balance in it. I want to create a report out of it. The report should looks like this, it shows the Rank,(Rank 1 means account with highest Balance) Account number, and Balance order by Rank. There is another Account master file...

    RamvishakRamesh2,505 pointsBadges:
  • Delete duplicate members from a physical file using RPGLE

    Hi, could someone please help me with the code to delete duplicate records from a physical file. Please post with the full code.

    AS400dot5 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • Help with iSeries CRTLF command

    I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I...

    mgrady15 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Comments missing after copying

    Hi all, We have a common source physical file QRPGLESRC in lib Qbbb  for our Project. In this, almost all RPG Members are having comments for understanding the program. Well, when I have a copy to my own Source file Qxxx in another Library Qyyy to change the program according to new requirement,...

    Sai4AS4001,420 pointsBadges:
  • XML to Physical file

    We will be receiving a file in XML format. Is there a way that I can convert file to a physical file on the 400.

    Dman465 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