• Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER . After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • Logical files in mimix are in *HLDERR

    How to troubleshoot and resolve, if the logical files are *HLDERR status.

    Praveen195 pointsBadges:
  • Logical file DDS change

    Hello all, if I change a logical dds and recompile it only with the physical. Do I need to recompile the program, because I check the program has the same file level identifier as that of newly compiled logical.

    koolsid78625 pointsBadges:
  • Logical file source

    If we have object of logical file, how can I find the source wrt object?

    koolsid78625 pointsBadges:
  • How to track members in a logical or physical file

    Dear all, I have the question. Before the system was running full backup then Members name over 19,000. After the system was backup finish and Administrator's Application is missing control Members in PF/LF, so submit job (SBMJOB) many the jobs, such as everyone known, Maximum number of members in...

    Hvphong031160 pointsBadges:
  • Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath007760 pointsBadges:
  • How can I delete LF in the database that is currently active? Is it possible?

    I wanted to delete a library on AS/400. It failed due to object dependencies.can I delete logical file that is depending on object located in a currently used physical file.

    ejaaje150 pointsBadges:
  • Difference between logical join file vs. view

    What is the difference between a Logical Join file and a view in DB2/400?

    RBauer92525 pointsBadges:
  • AS/400: Insert duplicate records through PF

    We have two logical files with unique keyword using the same physical file without unique keyword. Can we insert the Duplicate Records through PF

    mahalak75 pointsBadges:
  • 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:
  • Create join logical file using two physical files

    Can we create a join logical file using two multimember physical files?

    mohankrishna2115 pointsBadges:
  • File read with RRN

    I want to delete record from one logical file and delete from another logical file based on RRN. Both logical files are from same physical file. How to achieve this?

    prdevghare25 pointsBadges:
  • Logical file changes and SQL

    I need to make a change to a logical file. I have a program that is accessing this logical via an SQL statement. If I recompile the logical, do I have to recompile the program as well? (the file is not listed in the 'F' specs, it's only referenced in the SQL statement.

    NJSTATEBOB25 pointsBadges:
  • MIMIX Synchronization of Logical Files

    What method is used to re-synchronize a Logical File in MIMIX V7.1

    bjburgoyne15 pointsBadges:
  • Update join logical file

    I have seen one topic here before which saying that join logical file can be updated and it has been many years. But I have tried to update a join logical file either using DFU or STRSQL.Neither succeed. Could someone help on this? Thanks a a lot.

    Gaoshen10035 pointsBadges:
  • Best way to permit two values in a logical file

    Hello, I have a physical file called RTIP that has 4 logical files: RTIP00, RTIP01, RTIP02, RTIP03. What I need to do is to permit values in two columns: CDSTF and CDRMT. What is the best way to do this change knowing that my file has about 10 million rows? The best performance is achieved using...

    hamzahir85 pointsBadges:
  • Can a join logical file only select highest value when multiple records are found?

    Have a file of students (stu # as key), want to join to enrollment file & get the most recent activity date (could be many records for one student or one record for a student). Can a join logical file be created that would give me that? SQL can select via max operand. Does DDS have something...

    BillGood15 pointsBadges:
  • Logical files – V5R4

    Hi, we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical files name only known is it possible to fetch the Physical files name on whom it is dependent? Happy New Year and best wishes to all! Ram

    ten20081,150 pointsBadges:
  • How to find a logical file in AS/400

    I need to find all of the logical files associated with a single physical file.

    fasthorses8975 pointsBadges:
  • Locate logical files in System i Navigator

    How do I locate logical files in System i Navigator?

    rizkkr5 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.

Thanks! We'll email you when relevant content is added and updated.