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

    ITKE56,495 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:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • Execution preferences for select and ommit in logical files

    For select and omit conditions in logical file, is there any preferences will be applied while in execution, like ++,-- in C language?

    sivakesava240 pointsBadges:
  • About files

    I have a physical file and a logical file, on that physical file in a library and now I want to copy the object of that physical and logical file to another library. I copied the object of the physical file to another library which happened good but when I am copying the object of the logical file...

    JSDHFKJHA335 pointsBadges:
  • Record lock on physical file

    When a logical file is open in update mode to read and update the record, while performing read operation on logical file, lock applies on which file(logical or physical)? I have a scenario where one logical holds a lock and when another logical tries to read it shows 'Record is already lock to...

    sivakesava240 pointsBadges:
  • Getting the error CPF5257 when trying to write record in Logical File

    RPGLE Program crashing with the error CPF5257 (Failure for device or member &4 file &2 in library &3) when trying to write record in Logical File.

    vipin2m55 pointsBadges:
  • logical based on physical file member

    I want to create a logical file over the data contained in one member of a muiltiple member phyisical file. I can find nowher that allows me to specify the member name of the PF.

    authoron15 pointsBadges:
  • Logical file update during FTP

    When are the associated logical files updated when a physical file is receiving data via FTP?

    Chandlerbing81840 pointsBadges:
  • Clear a logical file

    Is there any command to clear a Logical File?

    RamvishakRamesh2,410 pointsBadges:
  • Logical file Error.

    i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID            5        A            LNAME      ...

    Nikrajpapa225 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:
  • What does a Logical File in AS/400 contain?

    Does it contain data. If not then why do we need a member for alogical file?

    AXM5 pointsBadges:
  • how many programmes are using any perticular database file in as400

    hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

    Ambrish 82310 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell465 pointsBadges:
  • as400 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:
  • Can an AS/400 COBOL pgm have a logical & physical file open and referenced at the same time

    In the COBOL program, using calls to IO modules, can the same file be opened with a physical fiile definition and a logical file definition at the same time? Or can it be opened as a physical file and then read by logical key and updated with physical key? Or does the file have to be opened as...

    khalon15 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