• Deleting the physical files without deleting logical files

    Hi, Can anybody tell me how to delete the physical file(PF-DTA) without deleting its dependent files (LF). Actually we are having Mimix running in our live and DR system, in the DR I want to delet PF only and resync with the live.

    Syedm180 pointsBadges:
  • Reducing Impact of increasing a field length of AS400 file

    I am currently working on a project where there is a file which has a field of length 3 (packed decimal). Under the project, we need to increase that length to 5 packed decimal.But this change is causing a lot of impact on the system as lot of programs and queries need to be changed/recompiled. Is...

    sanras12330 pointsBadges:
  • Convert spool file to physical file in AS/400

    How to convert result file to physical file?

    Ckishorekumarr25 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • Add a new field in PF

    Is it possible to add a new field in an existing PF without deleting the records that are present in it?

    jainamit380 pointsBadges:
  • how to copy column-headings from a PF

    how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

    svankipu560 pointsBadges:
  • Problem in Changing CCSID

    Hi , I am trying to change the CCSID of My physical file from 836 to 937 , but it automatically gets set to 28709 . I am facing the same problem in changing other CCSID sets also.I m using V5R2M0 version of AS400. Please suggest a way to get throgh this problem.    

    TcsEmployee5 pointsBadges:
  • What are the steps needs to be followed while removing Key Fields from PF.

    Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm....

    Mohan K695 pointsBadges:
  • Limit to physical files in journal

    why we can add only 50PF in a jrnl?i need to create a jrnl for usr who has 65PF in his lib?Plz help me

    Rajasekhar151,395 pointsBadges:
  • Physical File record length

    how to change PF record length?

    Rajasekhar151,395 pointsBadges:
  • AS/400 PF to IFS with CCSID 935

    I have a file on the as/400 which contains mixed language data.  Some fields are coded as 'O' to accomodate DBCS Chinese Characters.  This all works fine.  If I pull the data up in Excel using the iseries add in, it comes up great.  I need to take this file and place it on an IFS to be...

    GirlScout10 pointsBadges:
  • How can I retrieve multi-members List to physical files

    How can i retrive the Mutli members list to a Physcial file.i tried the below command. i got the error code   DSPFD      FILE(AMLIB/DEMOPF) TYPE(*MBRLIST) +                OUTPUT(*OUTFILE) FILEATR(*PF) +                 OUTFILE(AMLIB/DEMOPF2)                        ...

    Progrmmer5 pointsBadges:
  • Getting the number of deleted records from Physical file

    My requiremnt is to get the number of deleted records from a physical file. This will clear more.When we give DSPFD File name, at bottom we can see the number of records deleted from the so how to pull that field which consist of the value of number of deleted records

    ankit2002770 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:
  • 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:
  • 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:
  • 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:

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