PF

Displaying data through DSPF and CL programm.!

I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT          1  QPADEV0021  USERNAME      pgm             ...

Convet pf file to Excel

I had copyed spool file to pf and i want that should be copied to execl format.

negative numeric values

How to retrieve the negative numeric values stored in packed fields of a PF into a RPG program and process them?

data base files

How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?

Database Issues - Trying to prove that something has to be done

Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...

Logical file with Substring fields

I have a Physical file field 100 characters long. But it has more than one data elements with various data types in this field. I know these sub fields’ types, starting positions and lengths. I tried to create a Logical file to describe these sub fields using “SST” function. But I got an...

Non-display fields in physical file

i want to create a PF in which i want to declare fields as non display.Can u help me out

Duplicate object (PF) using SQL with same attributes

I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

convert csv file to pf file

i have a file on IFS in .csv format.how to copy this file to pf format in another library.

Selecting Fields in Logical File

If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?

Override to a Logical File

hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...

Add field without altering Record Format Level Identifier

Hi, Is it possible to alter a file (say adding a new field or deleting a existing field) without altering format level indentifier? if yes? please tell me how? Tanx

PROGRAMMER DELETED SOURCE FILES

Recently I asked an AS400 RPG programmer who has worked here over 9 years to delete PF's in their test library. This person also deleted their test source files (QRPGSRC, QCLSRC, ECT) Does anyone have thoughts on this? I really appreciate this.

ovrdbf doesn't get deleted with a dltovr

I've got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn't get deleted. I can't figure...

AS400 - RRN of PF

FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program

Search in a Physical file

How can search for a particular string in physical file when there is not any primary key in physical file. There is not any information about the field name and field structures also.. e.g. like we have to search for "anshu" in a PF but we dont have ay idea about the feilds in the PF. PF doesnot...

Unable to override a PF member

Hi, I am trying to override a physical file using CL. The CL program is being called by a CBLLE program. In the CBLLE program, I want to process the overridden member.But,all the processing is going on the first member only.It looks like as soon as the CL program terminates DLTOVR gets executed...

I want data from AS400 PF to my windows system in form of XL sheet.

I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

CLLE File Declaration

Can display File and PF be declared in a CLLE program

Clearing a PF record on AS/400

I'm chaining a field to a unique keyed PF. I'm getting a not found indicator so I'm trying to write the record but I receive a duplicate key error. How this can be I do not understand. A colleague suggested that a field (or fields) within the record might be a key of other LF's over the file and...