• 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:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 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:
  • Damaged member in Physical file

    Any way to tell if the file was damaged is due to OS issue or application related issue?

    Leokoh40 pointsBadges:
  • db2/400

    Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

    Repaire45 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:
  • How to check a perticular record

    How to check a perticular record in aphysical file without using READ and CHAIN

    9633695 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