Physical File

DB2/400

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

How to differentiate between newly added records and previously added records in Physical file

i have physical file in which records are added on daily basis. i have to copy record to another Flate file. How can i recognise the block of newly added records? There is no date field in Physical File sothat i can copy records on date basis.

CPYTOIMPF

CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created a 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...

Printing Physical File Records

I wanted to print the Records in Physical File with out using 1. RPGLE Program 2. Query I wanted to print the PF records using WRKMBRPDM and Option 6 Please help me to find the solution

AS400 Physical file conversion to xml file

Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.

Copy logical to different physical

using STRPDM I would like to create a copy of an existing logical over another physical. For example: Copy the logical F0911LA that is over the F0911 in TKDATA Production TO be created over a F0911 physical in the ARCDATA library in the same Lpar

AS400 I have a flat physical file,this flat file will be updated daily by datewise.I have to use an CLP for copying the records by the datewise daily

I have a flat physical file ,this flat file will be updated daily by date wise . I have to use an CLP for copying the records by the date wise daily and copy that data to another Physical file and change the naming conventions of the file and send the data to mainfram system using FTP( FTP too we...

Flat file to PF conversion

Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

DB2/400 - Source Physical File Deletion?

I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

How can I convert all the records from a Physical File to Exces ?

I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .

DB2 logical files

HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

Seeing where a member is deleted in a journal

I have a situation where a member is being created in a physical file and is later being deleted by some process, human or automated. I'm trying to find what is removing the member and set up a journal to find the answer. I am able to readily see where the member is created, where records are added...

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

DDS with temporary name for Physical file

Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !

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

WRKOBJ System Physical File (QSYS)

Hi guys, Do u guys know what is the name for the physical file of WRKOBJ in Qsys? I need to OVRDBF with this file. Do u have the reference for the System Physical file for AS400??? Thanks!!!

CL/400

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 Lgical Files , which are depended on PF1. I am writing code...

Describing files using Data Description Specifications (DDS)

Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF

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!!!!

RPG/400

i have a physical file name with length of 10 same file i need to declare in rpg/400 but here accepting only 8 length so any way to overcome....