• 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:
  • DBCS “open data type” problem – time-critical situation

    BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software's database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type "A" to data type "O". Our case tool is recognizing...

    Choyle100 pointsBadges:
  • AS/400 compare files

    I want to compare two files without using SQL and logical file. I have written a code but I didn't get exact out put. Please look into the below code and help me guys. File:test1 Keyfield=accid ACCID   ACCNAME 1   siva 2   hari 3   vinayaka File:test2 no key field here ACCID   ACCNAME...

    chowas400615 pointsBadges:
  • AS/400 logical files

    A PF has 10 LF’s. Normally, when the PF is updated, the data in the LF is immediately reflected. However, there is a scenario wherein when the PF is updated, I (the user) do not want to see the updated data reflected in any of the LF. How do you achieve this objective?

    As400am5 pointsBadges:
  • CL program to delete dependent files

    Could any one please help me with the steps to write a CL program. I want to write a program in CL or any other language eg. RPGLE which will take physical file as an input and based on DSPDBR dependent logical files can be deleted.

    abhisheka1405 pointsBadges:
  • Save physical file too small in AS/400

    I would save a PF (800G with about 3 billion records) and one of its logical file. OS is v6r1. However it said the save file is too small. I remember that this limitation of save file is 2T while the size of my physical file and logical file no more than 1 T. Anyone can help me? Thanks a lot.

    liushiqiang15 pointsBadges:
  • How to compile 100 logical file single operations?

    How can I compile 100 logical files in a single operations?

    Maali20 pointsBadges:
  • How to delete 100 logical files for single operation?

    How can I delete 100 logical files delete in a single operation?

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