• Problem with CPYTOIMPF command

    Hi , I have a PF abc in my library ,now i want to move it to IFS directory /home/xzy. I am using CPYTOIMPF with TOSTMF option as /home/xzy/abc.txt but it is failing saying "The copy did not complete for reason code 11"..please help

    munduuu435 pointsBadges:
  • AS/400 – Convert physical file with multi record to single record

    This is AS/400 question, any idea to convert a multi-record physical file to a single record.  Example: [strong]FILE A[/strong] 000000     AAAAA 000000     BBBBB 000000     CCCCC 000000     DDDDD Convert to [strong]FILE B [/strong]000000    AAAAABBBBBCCCCCDDDDD Many thank ur...

    Nivlac35 pointsBadges:
  • Send an AS/400 physical file without using SNDDST

    Hi, my SNDDST is not working ..Please let me know if there is some method to send a PF(which is in my library) through email....

    munduuu435 pointsBadges:
  • How do I change the field length in a physical file using chgpf command?

    Hi,  This is giri.Im looking to change the field length in pf using chgpf command?Please give me what are the steps i have to do?How can i change the field?

    Girilabs130 pointsBadges:
  • Arabic characters in AS/400 file

    Hi , I have  insert some ARABIC  Charaters in  in P.F. if i am going to upddta and trying to insert cherates the cgarters are showing as ????????. Pls help  .   Thanks , Bisht   

    BISHT321245 pointsBadges:
  • AS/400 file restore help: Physical file and dependent members deleted

    Help!! I had a damaged physical file and deleted it and its dependent logical files. I tried to restore the objects but I get a file mismatch error and it won't restore. I have the backup of the library but can't get my objects to restore. I even tried restoring the entire library and everything...

    Debbie050815 pointsBadges:
  • DB2 physical file

    how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice ))...

    Hodish40635 pointsBadges:
  • Create more member to single physical file

    I TRYED TO CREATE MORE MEBERS TO THE PF WITH CRTPF COMMAND AND ALSO GAVE *NOMAX OPTION TO PF .BUT IT IS NOT POSSIBLE FOR ME?HOW TO CREATE A MORE MEMBERS TO PERTICULAR PF ? PLEASE GIVE ME CLEARY?

    3months15 pointsBadges:
  • Apply Journal Change to Object of Different Lib

    I got PF obj, in two Libs. I want to apply change into the second obj using the journal entries of first object. How can I do it??

    Fybscit5 pointsBadges:
  • CLLE – Openqry Files

    Using opnqry files, we create any key field for physical file for temporarily usage.Instead of creating another logical can i create opnqry? Please give code

    Sudheerk9950 pointsBadges:
  • passing variable in CL Program using QMQRY and SQL

    Hi, I'm setting up a process where I can add or delete a record in a physical file. I'm using a simple CL program that runs a couple QM Queries. QMQRY - REVEALADD INSERT INTO mylib/myfile (myfile) VALUES(user) QMQRY - REVEALDLT DELETE FROM mylib/myfile WHERE myfile = '&USER' CL code...

    Bggas400160 pointsBadges:
  • FTP PUT command adding an extra (carriage return?) character

    I have a physical file on the iSeries which I am sending to a Windows server. When the file gets to the server, an extra line has been added with what is (I think) an end of file or carriage return character. The software that is processing the file on the server doesn't handle this character well....

    Wlakesearcher100 pointsBadges:
  • 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:
  • 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:

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