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

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

    ITKE357,100 pointsBadges:
  • PMIS rebuild

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

    onetwothreefourfive5 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