• Special character in a PF

    Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any of these in iseries

    Rockleadme385 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:
  • Display output of RPG program in physical file

    I want to display output of my RPG program in a new physical file. How can I do that?

    PREETYKAUSHIK15 pointsBadges:
  • Synon/2E

    Hello, Let’s say my physical file has 1000 records, and I want to read 500th directly. Is this possible in Synon 2E? If possible can anyone explain me the way to implement it? Thanks & Regards Bibin George

    BibinGeorge130 pointsBadges:
  • Convert AS/400 file to Excel and PDF

    I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

    As400programm10 pointsBadges:
  • Create iSeries PF with multiple record formats

    How can I create an iseries PF with multiple record formats

    aderene185 pointsBadges:
  • How to create PF without member

    Is it possible to create physical file without a member? If possible, please let me know method of creating PF.

    Sonis1212175 pointsBadges:
  • Create a LF based on a particular member in a multimember PF

    Hi, How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?

    ITKE1,027,225 pointsBadges:
  • CL SNDUSRMSG to PF

    Hi All, I am new to CL/400, please help me to understand it. Below is the simple CL program. PGM DCL VAR(&A) TYPE(*DEC) LEN(4 0) VALUE(10) DCL VAR(&B) TYPE(*DEC) LEN(4 0) VALUE(20) DCL VAR(&C) TYPE(*DEC) LEN(4 0) DCL VAR(&D) TYPE(*CHAR) LEN(6) CHGVAR VAR(&C) VALUE(&A +...

    sivaknagula55 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 I...

    mgrady15 pointsBadges:
  • Difference between source physical file and physical file on AS/400

    What is AS/400? Difference between source physical file and physical file?

    AS400 - Ask the Expert485 pointsBadges:
  • Reading members of a physical file

    Hi, Can somebody please help by providing the program code for reading all the members of a file using RPG or RPGLE program? Suppose a file has 3 members then how to read the records of all the 3 members in a file? Thanks!

    6r1,850 pointsBadges:
  • How to track members in a logical or physical file

    Dear all, I have the question. Before the system was running full backup then Members name over 19,000. After the system was backup finish and Administrator's Application is missing control Members in PF/LF, so submit job (SBMJOB) many the jobs, such as everyone known, Maximum number of members in...

    Hvphong031175 pointsBadges:
  • Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath007760 pointsBadges:
  • How can I delete LF in the database that is currently active? Is it possible?

    I wanted to delete a library on AS/400. It failed due to object dependencies.can I delete logical file that is depending on object located in a currently used physical file.

    ejaaje170 pointsBadges:
  • Need to port flat file data into AS/400 physical files

    Hi, There are some flat files in one environment (within the same AS/400) with huge data and we need to create physical files and need to port that data such that the reports being generated over those files should be same even after migration. Thanks in advance, Svanky

    svankipu625 pointsBadges:
  • How to use in two physical files using in KLIST

    I'm using two physical files in a KLIST program. I'm looking for the MVR opcode. Can someone help me?

    baluyadav1435 pointsBadges:
  • Convert SAVF to Physical file in AS/400

    How to convert SAVF to Physical file in AS/400? I backup SECDTA into my library and it's in SAVF format. I would like to convert it to PF, so I can query it. I'm using V5R2

    arifhamid20 pointsBadges:
  • DDS L Date with no DatFmt keyword

    The question we have is that we have a DDS defined Physical file and the source is defining a date field with L but no datfmt keyword. Our sysval is DMY. Will this field be seen as *iso or DMY by the database? The only info we can see from IBM is that it will be defaulted to ISO is this correct?...

    Sxlad200145 pointsBadges:
  • AS/400: Merge same physical file from two different libraries

    I have two libraries with same physical files. Now I want to merge both the physical files data in a single physical file in third library with unique records. My problem is the physical file doesn't have key fields. Solution can be in SQLRPGLE or RPGLE. Thanks in advance.

    97834441841,465 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