• 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:
  • 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:
  • 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:
  • Compile all dependent logical files at once

    I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Logical Files , which are depended on PF1. I am writing code...

    Khadar90 pointsBadges:
  • Accessing the data of a Particular member in COBOL/400.

    Hi Group, In a COBOL/400 Application, I need to access the data of a particular member in a Physical file. One way of achieving it is by creating a LF on that member. Is there any other way of doing it? Regards, M

    mvrkrishna530 pointsBadges:
  • OPNQRYF query not working to filter pfdiv records

    I have 4-fileds on Display File like frdiv(zoned),todiv(zoned),frpr(char),topr(char). All the fields are of size 2 only. I am using a "OPNQRYF" to filter the records from a Physical file (pfdiv), it contains 1,25,000 records . Through this openqryf all the selected records I will copy to a file...

    Khadar90 pointsBadges:
  • Using CPYTOIMPF to copy records from a physical file to an Excel book

    CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created an Excel book with name exc.xls. My requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired Excel book. When I run...

    Chrisjam95 pointsBadges:
  • RPG/400 filename length

    I have a physical file name with length of 10. I need to declare the same file in RPG/400 but here accepting only 8 length. Any way to overcome this?

    Askt265 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Add a negative value to a physical file record in AS/400

    How do I insert (add) a negative value or number to physical file record?

    Sureyz2,375 pointsBadges:
  • How to delete junk value records from a PF

    Hi, I have a file which has a date field of DECIMAL 8 and it has value +++++++++++ for some records. How can I delete these records via SQL or programatically.

    Ankitsikarwar10 pointsBadges:
  • AS/400 ILE

    Hi, I want to ask the question about the physical file and logical file which with the members. Anyone could help me please? eg. PH 'A' with 5 members, so how about LF 'A'? Is it should be 5 members also? or we still need to add in? How about the data in the members?

    yeepiyaya70 pointsBadges:
  • Check the record counts of a physical file from single system which exists on 2 systems.

    Hi. I have a PF which exists on 2 different systems. The systems are in replication using MIMIX. During DR drill (system role swap) we are comparing the record counts of some PFs. For comparison we are using "SQL Interactive Sessions". Is there a way to get the record counts of these PFs which are...

    Ketan19305 pointsBadges:
  • Add a field in existing file in DB2/400

    I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.

    Askt265 pointsBadges:
  • Source physical files in a library

    I would like to know what are the source physical files in my Library. Is there any command for this? I have used some command in my previous project. But couldn't remember it..Can anyone help on this?

    NAN4AS40095 pointsBadges:
  • SETLL

    Hi, I want to read a physical file sequentially. The physical file has no key. I use SETLL and READ. *LOVAL is not allowed when I use SETLL (because no key in the pf?) so I set a 1 in factor 1. 1 SETLL READ 90 *IN90 IFEQ *ON ... Is this ok? When I have a key in the file could I then use the...

    withcareandsoon5 pointsBadges:
  • NULL value in physical file

    I am a beginner in AS/400 and learning through some tutorials, I came with a problem of how to add a NULL value in physical file. The spaces can't do the work, as even spaces have a ASCII value. Please respond with possible solutions.

    Durgesh813370 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