• Not able to override a database file in CL

    Hi, I am trying to override a physical file using CL. But,when I go and delete the override, I get an exception that it was never overriden. :( Any help will be highly appreciated

    Prabhjot8515 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 pointsBadges:
  • count physical files

    How can I count all the physical files on a System i?

    Vitome5 pointsBadges:
  • Record addition in a PF

    I have a PF with some data in it which i am using in a RPG program. I got another text file with extra data related to PF in it. I have to add this data to the existing data in the PF, Please tell me how can i do this from my RPG program....advance thanks

    ten20081,150 pointsBadges:
  • How to send the data from a Physical file to a Flat file

    Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF E DISK FSAAPH...

    Askt1140 pointsBadges:
  • AS/400 script or program needed

    I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...

    ITStarter5 pointsBadges:
  • Searching out and eliminating unuse files on AS/400

    We have over 1700 files & members in a production library, and we know that there are many that are no longer used or pertinent. We thought we could clean these up by running DSPFD to a physical file and checking such parameters as "last used date", but this seems to be ambiguous and fraught with...

    Stoogenut10 pointsBadges:
  • 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 I...

    Floyd02320 pointsBadges:
  • How to view online the new data added to a PF?

    Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!

    Mariodlg2,790 pointsBadges:
  • How to get the row count of a PF with RPG ILE?

    Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.

    Mariodlg2,790 pointsBadges:
  • Differnce 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:
  • AS/400: Unique records in file

    hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...

    Ambrish 82310 pointsBadges:
  • Display files in AS/400

    I am getting stated with RPG400.I hev this requirement to add a new field in an existing screen and move this value to a new PF.This is when the screen is opened in crete mode. the other screen where the new field is to be added is the update screen.In this screen value is to be retrieved from the...

    0 pointsBadges:
  • iSeries to Unix FTP problem

    I've a physical file with single field (64 chars long) and want to transfer it across to our Unix system using FTP. When I transfer the file across, I don't get CR/LF characters at the end of each record. All physical file records appear in a single line. If I retrieve the same file from my PC...

    Maverick6925 pointsBadges:
  • iSeries: Accessing src PF member using Java/400

    I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member (e.g...

    Raju40060 pointsBadges:
  • Finding newly created objects

    I am trying to define a query to find any newly created objects ona daily basis. I have scheduled a job to run daily that creates a file to display all DSPOBJD which outputs into a physical file. I now want to query this file to find anything created on the previous day (the job runs overnight)....

    Gross140 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • Start Journaling of PF.

    How do I Start Journaling on 2200 Physical Files together instead of using STRJRNPF for every file.

    Haaiderali215 pointsBadges:
  • How to create Dynamic DDS for a PF(Physical File In AS/400)

    How to create Dynamic DDS for a PF(Physical File In AS/400)

    Ugan5 pointsBadges:
  • command to delete a line in physical file

    i want to delete the comment lines through cl program.i want to know the command for deleting a line in physical source file?

    R225 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