• Rebuilding Logical Files

    What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

    Dcantwell480 pointsBadges:
  • Logical file with Substring fields

    I have a Physical file field 100 characters long. But it has more than one data elements with various data types in this field. I know these sub fields’ types, starting positions and lengths. I tried to create a Logical file to describe these sub fields using “SST” function. But I got an...

    nhewage50 pointsBadges:
  • DB2 logical files

    HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

    ten20081,150 pointsBadges:
  • CL/400 CRTLF

    while creating an object for a logical file we will use in CL/400 CRTLF FILE(library/logical-file-member) SRCFILE(SARKNS/FIVE) But I need to give the logical-file-member name as a field like this pgm Dcl var(&var1) type(*char) len(10) chgvar var(&var1) value('logical-file-member') CRTLF...

    Khadar90 pointsBadges:
  • Position to in Single page subfile

    Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)

    S2235 pointsBadges:
  • Selecting Fields in Logical File

    If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?

    Programmer2320 pointsBadges:
  • Override to a Logical File

    hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...

    Ninoo35 pointsBadges:
  • join logical files

    Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks

    ten20081,150 pointsBadges:
  • AS/400: Unique records in file

    hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...

    Ambrish 82310 pointsBadges:
  • FORMAT keyword in non-join logical files — what and how?

    How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?

    AS400 - Ask the Expert485 pointsBadges:
  • View Data

    We have several master files that contain 2 companies data. Right now our system allows each company to view each other's data. I need to only allow each company to view their own data. Each file has a company code that I can use. Currently each file contains several logicals now that we use to...

    AS400HELP5 pointsBadges:
  • joing logical files?

    can we join two logical files if yes then how?

    6r2,460 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.

Following