• 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,420 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?

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

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

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

    mohit123200 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

    Geek51180 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:
  • PF in Cobol program

    I am currently working on a Cobol program, on a AS/400, where I had to revise the PF layout and made adjustments to the source program and compiled it. Problem is, the program is still picking up the 'old' PF layout instead of the newly revised layout? Any thoughts or suggestions that I missed? I...

    Bigdogg5 pointsBadges:
  • Writing record to a file through CLLE

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

    Anisanju5 pointsBadges:
  • What is the syntax for a file override that renames the field name prefix?

    Chasing down an obscure bug and a possibility is a hanging field value (many logicals over one physical file in program)

    aceofdelts2,190 pointsBadges:
  • Adding and updating physical file

    I have a physical file with no key. I want to add new record to it and if record is added if I want to update it. How can I do it without a key?

    supreet8515 pointsBadges:
  • Copy Spooled File to a Source Physical File Member

    How do I copy a spooled file listing into a member of a source physical file? I accidentally deleted the source member, but have a spooled copy taken via option 6.  I would like to convert the spooled file back into the deleted member.

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