• 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:
  • 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:
  • 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:
  • 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:
  • Journalling PF in AS400

    Hi, I would like to know when a PF is added with some new entries, or the existing entries been modified.  I require a report to be printed with the users and time of update.  How this could be achieved easily?

    Rajgoaj280 pointsBadges:
  • update flat physical file

    I have physicle file it cantains following records .I used As400. F1 (colum heading) RRMUNI WPB 3 18 00015 0109 RRMUNI WPB 2 18 00015 0105 RRMUNI WPB 4 18 00015 0107 There are 418 recodrs contain in the file. i want to update RRMUNI as RRMINI using strsql in all the fileds. Pls give sample code or...

    NADEE12320 pointsBadges:
  • RPG

    How do we declare a Physical file for both  input and output(Read/Write/Update) operations in RPG400?

    TNKR130 pointsBadges:
  • AS/400: concept of Unique key

    Hi, I have a PF wiht 3 fields. I  created LF based on this PF, with first 2 fields as Key fields and specify file level key work UNIQUE in that LF. What will happend if I add the duplicate records in PF object...?  

    Samule400160 pointsBadges:
  • How to list Journaled files to an Outfile

    Hi.  Is there an easy way to get a list that will provide information on which physical files are being journaled within a library?  For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven't found it, nor have I been able to find it...

    jamesm33330 pointsBadges:
  • How can you pass the parameter to the pf in RPG/400?

    How can you pass the parameter to the pf?(using function key 4)

    Girilabs130 pointsBadges:
  • what is the object type of srcpf,pf,lf? (RPG/400)

    what is the object type of srcpf,pf,lf?

    Girilabs130 pointsBadges:
  • Necessity of a multi-member PF in COBOL

    How do we read a multimember PF in cobol ?How does it differ from a regular PF ?

    Supriyob2165 pointsBadges:
  • data search using popup window

    Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?

    sarapsm5 pointsBadges:
  • Reading a file in AS/400

    I wanted to read a Physical file based on library. Eg: One master file is available in most of the libraries. I wanted to change some data in that file. So i wanted 2 read file in all the libraies. how to achieve this using program?  

    rajeshece1,215 pointsBadges:
  • writing record to a file through CLLE

    Can we write a record to the physical file using CLLE?

    Anisanju5 pointsBadges:
  • Help!! Physical file accidentally deleted, logicals still there. Is there hope?

    I made a HUGE mistake and realized it way too late!! I needed to do a copy of a physical file with *NOMAX on it for the errors because there were 10 corrupted files. Anyway, things went wrong, we restored from backup. Things were back to normal, or so I thought. I got back on the system a couple...

    Kristy112935 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.