• Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath00775 pointsBadges:
  • How can I delete LF in the database that is currently active? Is it possible?

    I wanted to delete a library on AS/400. It failed due to object dependencies.can I delete logical file that is depending on object located in a currently used physical file.

    ejaaje140 pointsBadges:
  • Reading members of a physical file

    Hi, Can somebody please help by providing the program code for reading all the members of a file using RPG or RPGLE program? Suppose a file has 3 members then how to read the records of all the 3 members in a file? Thanks!

    6r1,765 pointsBadges:
  • Need to port flat file data into AS/400 physical files

    Hi, There are some flat files in one environment (within the same AS/400) with huge data and we need to create physical files and need to port that data such that the reports being generated over those files should be same even after migration. Thanks in advance, Svanky

    svankipu625 pointsBadges:
  • How to use in two physical files using in KLIST

    I'm using two physical files in a KLIST program. I'm looking for the MVR opcode. Can someone help me?

    baluyadav1435 pointsBadges:
  • Convert SAVF to Physical file in AS/400

    How to convert SAVF to Physical file in AS/400? I backup SECDTA into my library and it's in SAVF format. I would like to convert it to PF, so I can query it. I'm using V5R2

    arifhamid20 pointsBadges:
  • DDS L Date with no DatFmt keyword

    The question we have is that we have a DDS defined Physical file and the source is defining a date field with L but no datfmt keyword. Our sysval is DMY. Will this field be seen as *iso or DMY by the database? The only info we can see from IBM is that it will be defaulted to ISO is this correct?...

    Sxlad200140 pointsBadges:
  • AS/400: Merge same physical file from two different libraries

    I have two libraries with same physical files. Now I want to merge both the physical files data in a single physical file in third library with unique records. My problem is the physical file doesn't have key fields. Solution can be in SQLRPGLE or RPGLE. Thanks in advance.

    97834441841,465 pointsBadges:
  • How to delete physical file member?

    I tried to delete physical file member in AS/400 by using CLRPFM command...but nothing get deleted...why?

    ganeshpavi75 pointsBadges:
  • Zoned decimal in a physical file

    Hello all, I have a decimal field in a physical file say amount 15S2. By default when we enter value in that field all leading zeroes are not shown in PF. For example suppose I enter 00025.33 into the amount filed. It will be shown as 25.33 in PF. I want it to be 0000000000025.33 in PF. Is there...

    mohit123210 pointsBadges:
  • FTP Server on iSeries

    I have a batch process which will create a IFS file from physical file and FTP to iSeries IFS Directory. FTP function will fail if the FTP server on iSeries is not running. I would like to include a statement in CL to ensure FTP server is running on iSeries before placing the file in IFS directory....

    Babs312290 pointsBadges:
  • Delete members from multimember physical file

    I have to remove members which are were created before six months from two physical files in a single CL program if the member size is reached in physical files. I am creating outfile using DSPFD command and then deleting records that are created before 6 months. EHUBTMP and EHUPTMP will be the...

    mohit123210 pointsBadges:
  • AS/400: Insert duplicate records through PF

    We have two logical files with unique keyword using the same physical file without unique keyword. Can we insert the Duplicate Records through PF

    mahalak75 pointsBadges:
  • Convert AS/400 file to Excel and PDF

    I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

    As400programm10 pointsBadges:
  • How do I copy a pipe delimited text file to pf on iseries.

    Can someone tell me how to copy a pipe delimited text file to PF on iSeries?

    CarolKendall5 pointsBadges:
  • Merge two Physical Files using Logical File

    I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.

    nhewage50 pointsBadges:
  • How are DB2 files different from Physical files in AS/400?

    May i know how database tables are different from Physical files in as400

    Geek51185 pointsBadges:
  • Create join logical file using two physical files

    Can we create a join logical file using two multimember physical files?

    mohankrishna2115 pointsBadges:
  • Create a physical file in the model

    What are the steps to create a physical file in the model?

    sandybeachy5 pointsBadges:
  • Reading the Physical file Using RRN

    Hi All, I have a physical file file1, have the field Status, which holds the value of: Status Y      rrn1 Y      rrn2 N      rrn3 Y      rrn4 Y      rrn5 My question is: How can I read the Physical file to fetch the record as rrn3,rrn1,rrn2,rrn4,rrn5? Which means I want to display...

    srivijay1320 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