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

    Dcantwell480 pointsBadges:
  • How i can create LF View To More than One Library?

    how i can create LF View To More than One Lib.

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

    khalon25 pointsBadges:
  • Reading logical with different key fields scenario

    Hi, I have a physical file FILE with fields A, B and C. I am using these fields as KEY fields in logical file FILELF. But in my program, i have scenarios like:- a. Read FILE on the basis of key fields A ,B and C, if not found then b. Read FILE on the basis of key fields A,B or A,C or B,C, if not...

    Sangay635 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:
  • Derived field text in logical file

    I have a logical file I need to create in a separate environment(inqhist). The file exist in our company's primary environment, but we don't have the source for the file. When I use the dspffd command I see three of the fields I need with the description 'derived field text'.  They are date fields...

    DLM2007295 pointsBadges:
  • comparing two logical files with the same fields to find the difference in the field which hold amount

    i have two logical files which have the same fields.The contents of the fields are the same except the filed which contains amount.How do i get the difference of the amount in the two files

    Zabg15 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:
  • I have saved library with access path yes, however after restoring data file and index , the index path again takes time to create why?

    I have saved library with access path yes, however after restoring data file and later the corresponding index separately. While iam able to see the relationship using DSPDBR, however when i do as sql select i find the selection takes time. Do i have to restore both LF and PF in one command so...

    JohnsonMumbai1,480 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:
  • DDS Logical File

    How can i create one Logical File based to more than one Lib

    406310 pointsBadges:
  • Does CPYTOIMPF honor keys of a FROMFILE logical file?

    Does CPYTOIMPF command honor keys of a logical file?

    DWatk5 pointsBadges:
  • Logical File without Keyfield

    If i am using a logical file without key fields in RPG program , it will show any error ?   Jayanta

    2106198125 pointsBadges:
  • Help!! Physical file accidentally deleted, logicals still there. Is there hope?

    I made a HUGE mistake and realized it way too late!! I needed to do a copy of a physical file with *NOMAX on it for the errors because there were 10 corrupted files. Anyway, things went wrong, we restored from backup. Things were back to normal, or so I thought. I got back on the system a couple...

    Kristy112935 pointsBadges:
  • logical file

    what is the difference between OPNQRYF and LF

    Hemavijay85 pointsBadges:
  • Join Logical files and SQL views

    I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical files in...

    bogeybetsy560 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:
  • Copy logical to different physical

    using STRPDM I would like to create a copy of an existing logical over another physical. For example: Copy the logical F0911LA that is over the F0911 in TKDATA Production TO be created over a F0911 physical in the ARCDATA library in the same Lpar

    Tbc5 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