Problem with the READ from PF in RPGLE

Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program its reading the Physical...

Sureyz2,825 pointsBadges:

AS/400 Physical file conversion to XML file

Hi, I need to write an RPGLE program to convert an AS/400 physical file to an XML file. Does anyone have a sample code for it? Thanks in advance.

Siri55 pointsBadges:

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,067,585 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,955 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...

Hvphong0311100 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: