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

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

    abhisheka1400 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:
  • MIMIX Synchronization of Logical Files

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

    bjburgoyne15 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:
  • 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:
  • Are logical files and indexes the same thing?

    My background is certainly in MSSQL and I've asked people at my company if they have created indexes on certain columns. They always says yes but point me to logical files.When I'm using iSeries Navigator, logical files show up under the "Views" category. However, when I click "Indexes", nothing...

    ITKE352,565 pointsBadges:
  • PMIS rebuild

    is there any way to rebuild PMIS without implementing 112841 sap note?

    onetwothreefourfive5 pointsBadges:
  • Altering keyfields inside RPG Program

    Hi all, I have a  Physical file PF with 5 different logical files (LF). PF don't have any keys at all. In RPG program I need to perform a CHAIN on this file with 2 key-fields in which 1 of the key is defined as key field in some LF's. But the other is not. Now I was asked to perform CHAIN without...

    Sai4AS4001,420 pointsBadges:
  • Help with iSeries CRTLF command

    I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I...

    mgrady15 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries.  Everything is going extremely well other than 2 files that I need to access use members.  These are the only ones that do on the entire system.  I was told that...

    mgrady15 pointsBadges:
  • Compile all dependent logical files at once

    I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Logical Files , which are depended on PF1. I am writing code...

    Khadar90 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