• 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:
  • Physical File Without Key

    Hi guys, Currently i'm using RPGLE language. If i have a Physical File that without key, How am i going to set my pointer. I can't CHAIN,SETLL and SETGT as well. In order to use them, u need have a key. Am i rite? Is there any idea to solve this matter? Thanks!!!!

    SoulReaper20 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,570 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,150 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...

    sanras12335 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:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries.  Everything is going extremely well other than 2 files that I need to access use members.  These are the only ones that do on the entire system.  I was told that...

    mgrady15 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