• 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:
  • as400 logical files

    A PF has 10 LF’s. Normally, when the PF is updated, the data in the LF is immediately reflected. However, there is a scenario wherein when the PF is updated, I (the user) do not want to see the updated data reflected in any of the LF. How do you achieve this objective?

    As400am5 pointsBadges:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 pointsBadges:
  • RPG 3 duplicate record error handler

    The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.

    Shankey5 pointsBadges:
  • Can an AS/400 COBOL pgm have a logical & physical file open and referenced at the same time

    In the COBOL program, using calls to IO modules, can the same file be opened with a physical fiile definition and a logical file definition at the same time? Or can it be opened as a physical file and then read by logical key and updated with physical key? Or does the file have to be opened as...

    khalon15 pointsBadges:
  • find physical files with large record counts that are unused

    How can I capture the number of records (not file size) for numerous physical files via a cl command in order that I may download the information and find the ones with the largest number of records? I need to free up disk space so I need to find the files that have records but have not been...

    Hayleypatrick5 pointsBadges:
  • convert physical file to spoolfile?

    through runqry i generated some reports.In that reports page what date i generated reports display that date.later i want print that reports with that current date.for this use i am using one method 1)convert that report spoolfile to pf and by using strdfu i was change the date in reports.Now i...

    Madhuas40040 pointsBadges:
  • Reading logical with different key fields scenario

    Hi, I have a physical file FILE with fields A, B and C. I am using these fields as KEY fields in logical file FILELF. But in my program, i have scenarios like:- a. Read FILE on the basis of key fields A ,B and C, if not found then b. Read FILE on the basis of key fields A,B or A,C or B,C, if not...

    Sangay635 pointsBadges:
  • how to convert physical file to spool file?

    how to convert physical file to spool file?

    Madhuas40040 pointsBadges:
  • Maximum no. of records allowed in PF

    A question based on an interview: Is there any limitation or standard followed regarding maximum no. of records that could be populated in a physical file. If yes, then what is the reason.

    NRI15 pointsBadges:
  • Damaged member in Physical file

    Any way to tell if the file was damaged is due to OS issue or application related issue?

    Leokoh40 pointsBadges:
  • db2/400

    Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

    Repaire45 pointsBadges:
  • Finiding the PF name

    Hi Guys, I am stuck in here to find the physical file name, I know the alternate name of the PF, is there any procedure to find out the original PF name using the alternate name? Please help

    vssagar70 pointsBadges:
  • Flat file or Physical file in as/400?

    How to know whether a file is physical file or flat file in CL/400?.

    Alicsc370 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:
  • How to check a perticular record

    How to check a perticular record in aphysical file without using READ and CHAIN

    9633695 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • Synon/2E, Physical Files

    Physical File has RRN as Key. but is this RRN is always Assending or somehow we can make it descending also??

    Sharmak15 pointsBadges:
  • How to detect a non empty physical file using CLP

    How can I detect a non empty phyiscal file using CL

    aderene180 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