• DDS in TPG logical file definition

    In spool severity 20 -keyword specified at incorrect level severity 30 number of join specifications not valid joining 2 files.

    pedlat5 pointsBadges:
  • OS/400 Logical file and object

    In OS/400, does a logical file has an object?

    rajat0135 pointsBadges:
  • Maximum size of iSeries logical file

    What is the maximum size that a logical file may reach on an iSeries before is causes program access application to halt (...go boom!...bring a casino floor down...)?

    WundersW5 pointsBadges:
  • Create a LF based on a particular member in a multimember PF

    Hi, How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?

    ITKE983,410 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 I...

    mgrady15 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • Logical files in mimix are in *HLDERR

    How to troubleshoot and resolve, if the logical files are *HLDERR status.

    Praveen195 pointsBadges:
  • Logical file DDS change

    Hello all, if I change a logical dds and recompile it only with the physical. Do I need to recompile the program, because I check the program has the same file level identifier as that of newly compiled logical.

    koolsid78625 pointsBadges:
  • Logical file source

    If we have object of logical file, how can I find the source wrt object?

    koolsid78625 pointsBadges:
  • How to track members in a logical or physical file

    Dear all, I have the question. Before the system was running full backup then Members name over 19,000. After the system was backup finish and Administrator's Application is missing control Members in PF/LF, so submit job (SBMJOB) many the jobs, such as everyone known, Maximum number of members in...

    Hvphong031160 pointsBadges:
  • Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath007760 pointsBadges:
  • How can I delete LF in the database that is currently active? Is it possible?

    I wanted to delete a library on AS/400. It failed due to object dependencies.can I delete logical file that is depending on object located in a currently used physical file.

    ejaaje170 pointsBadges:
  • Difference between logical join file vs. view

    What is the difference between a Logical Join file and a view in DB2/400?

    RBauer92525 pointsBadges:
  • AS/400: Insert duplicate records through PF

    We have two logical files with unique keyword using the same physical file without unique keyword. Can we insert the Duplicate Records through PF

    mahalak75 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:
  • Create join logical file using two physical files

    Can we create a join logical file using two multimember physical files?

    mohankrishna2115 pointsBadges:
  • 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:
  • 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:

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