• 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:
  • Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 pointsBadges:
  • Unable to override a PF member

    Hi, I am trying to override a physical file using CL. The CL program is being called by a CBLLE program. In the CBLLE program, I want to process the overridden member.But,all the processing is going on the first member only.It looks like as soon as the CL program terminates DLTOVR gets executed...

    Prabhjot8515 pointsBadges:
  • Working with STRSQL command in AS/400

    How to select a particular member from Physical file through STRSQL. Can anyone give me the sample sql statement to access a particular member from Physical file ? Thanks in advance.    

    AmuthaTPT30 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:
  • Convert as400 file to Excel and Pdf

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

    As400programm10 pointsBadges:
  • CHGPF doesn’t change the based on LFs

    I used the CHGPF command to change the record layout of a Physical File but the based on Logical Files were NOT changed - the Format Level Identifier still had the old value. 

    QCDT25 pointsBadges:
  • physicalfile records updation in subfile

    i have created one subfile and records are also dsplayed ,but i want modify one record three times but i want second time modification record value ,so how to acess that record value?       please give me example program and subfile desion.

    RAMUas40030 pointsBadges:
  • Create a LF based on a particular member in a multimember PF

    Hi,  How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?

    0 pointsBadges:
  • Moving the unused source in AS/400

    Hi , I want to MOVE unused  sources from source PF . How can avoid copying individual memeber (opt 3) . Is there any coomand like MOVOBJ . I have the list of the sources and the source physical file name . Thanks , Bisht 

    BISHT321245 pointsBadges:
  • Want to delete objects of type ‘File’ except ‘source physical file’

    I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type '*FILE' and object attribute 'PF' but the problem is I don't want to delete 'Source physical files'. I just want to delete files except 'Source physical file'. can anybody suggest how to do that ?

    pankaj2r100 pointsBadges:
  • Journal in AS/400

    hi, please help. can someone tell me how to journal my PF file?

    NEON40 pointsBadges:
  • Store data in physical file

    i have a pf name is emp,in this not unique key,so i am enter duplicates records in that pf,now i want to find out the what records are repeated eno that record find out after store into other file,how to do

    madhuchowdary350 pointsBadges:
  • AS/400 (ALDON)

    Can anyone please tell me how to add a Trigger program to a physical file in ALDON and promote it??? ALDON is change management tool.

    C.naveen09140 pointsBadges:
  • Is there any conflict if create 2 different unit in as400 with the same objects and same ownership.

    Is there any conflict if create 2 different unit in as400 with the same objects and same ownership. Are the LF's will the PF's dependencies (the LF) will not mixed?

    Jimmy0315 pointsBadges:
  • Without using RCVF command can we retrieve AS/400 physical file

    Hi frnds, I have two PF say as PF1 & PF2 and in the both files there are records such as Name, ADDR & PHNO: and now i want fetch data of repeated names in the both PF's. But without using RCVF command can we fetch records or data... Thanks

    chakramdhar60 pointsBadges:
  • Find AS/400 string

    hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec    objname       10A    objType        10A    Libraryname  10A   ...

    madhuchowdary350 pointsBadges:
  • AS/400 Physical File update history

    How can we find out the sequence of programs that have updated the fields of the given file. For eg. If I have a file ABC and 10 programs have updated the file ABC, then how can we find out in which sequence the programs have updated the file ABC and what was the value in fields after each...

    VivekSharma120 pointsBadges:
  • CPYTOIMPF – PC .TXT file displaying as ‘garbage’

    Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was working correctly until we recently...

    SallyMackay15 pointsBadges:
  • AS400 – Physical Files

    Hi I have some qusetion in AS400 How can we convert rows into columns and columns into row for a PF in AS400. Please send me the coding for this requirement. Thanks

    iiiiiiiiiiiii335 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