• How to read multi member Physical file through SQL?

    How to read multi member Physical file through SQL?

    rajeshece1,215 pointsBadges:
  • AS/400 COBOL

    one physical file have 6 key fields,now i want to retrive the 10th record based on one key field,how to retrive in cobol/400 with without using logical file ex:- emp pf have 6 key fields,and emp have records,now i want to retrive particular record in emp(10 th record only),in my cobol pgm some...

    madhuchowdary350 pointsBadges:
  • Physical Files with triggers

    I am implementing existing files that have triggers. Do these triggers need to be removed from the files before implementing the file changes and then added back after the changes are implemented? Thank you,

    vrs235535 pointsBadges:
  • Delete Physical file member data (selected)

    I have a physical file in AS/400 machine which has a member which contains history data. I tried to delete few records from the member using SQL statement. but there is no place to enter the member name in the SQL statement. So I need to know a method to delete few selected records in the file...

    kcs10 pointsBadges:
  • AS/400

    as 400

    mmohan39320 pointsBadges:
  • compare physical file

    can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?

    vibgyor280 pointsBadges:
  • AS/400 database

    which command is used to find out the total number of records in physical file? i heard there are 4 ways... 1. dspfd 2.  ?????? 3.  ?????? 4.  ?????? can you please share with me ?....

    anupsshelke420 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:
  • Physical File record length

    how to change PF record length?

    Rajasekhar151,395 pointsBadges:
  • Programs using a PF

    how can we see that what are all the programs that uses a single PF? is that possible to see it?

    Rajasekhar151,395 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:
  • AS400 COBOL one pf have one lf but key fields are different

    i have one physical file,that pf have one logical file,but pf have 4 key fields,logical file have 2 key fields,now both(pf,lf) are using in cobol/400 code   SELECT pf-file ASSIGN TO DATABASE-pf1 [Br _extended="true" />ACCESS IS dynamic[Br _extended="true" />ORGANIZATION IS INDEXED [Br...

    madhuchowdary350 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:
  • 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:
  • Question on Physical Files & Logical Files

    Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??

    mvrkrishna555 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:
  • Mask a password in as400

    how to mask a password with asteric which is retrieved from a physical file in rpgle(as400)

    Keo55 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