• 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:
  • Listing Joined Files in as/400

    How can I get a listing of logical join files within a library?

    64techie25 pointsBadges:
  • Update done in physical file which does not reflect in Logical file

    Hello All,   1.I need to know when an update happens to Physical file the updates should not reflect in the corresponding logical file. Please let me know what needs to be done for this.  2. How will we update a field in a physical nd not the whole record in RPG IV. Please explain with an...

    Ponsasikumar5 pointsBadges:
  • How to calculate logical file size

    Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

    Gilly40023,730 pointsBadges:
  • Logical file

    I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just...

    Bubbles120 pointsBadges:
  • DDS with temporary name for Physical file

    Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !

    Lenny2113115 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:
  • iSeries Navigator V5R3M0

    Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ 'I') A ICTIPC COMP(EQ '1') How can I make this index using "a comparison value for fields" on Iseries Navigator ? Thanks Silvarb

    RBDSILVA550 pointsBadges:
  • 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?

    Dcantwell470 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?

    6r1,520 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