• CL/400 OPNQRYF returning empty records.

    hey there, I got an issue to be corrected. Current CL has and OPNQRYF select which sometimes return blank records. I need to add a condition which should check for such blank query result and by pass a call program. Can you guys help me in giving a hint on which way I can bypass this blank record...

    itkr125 pointsBadges:
  • AS/400 Record Count

    I need a command to use in a CL program that will give me the record count for all records in a file. RTVMBRD will do it for a single member, but I need it for MBR(*ALL). I know I can dump a *MBRLIST to a file and tally it up form there, but if someone already has this, why reinvent the wheel.

    CharlieBrowne39,790 pointsBadges:
  • How to insert records in a physical file using input subfile

    have to insert records to a physical file ,the input records should be taken from an input subfile

    Rr123480 pointsBadges:
  • When using IfNull in my SQL, records are ignored

    I know my data table has nulls in it. If my select statement doesn't include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here's my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,' ')...

    Frydaze120 pointsBadges:
  • Key Mapping Error when writing records in AS/400

    When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error

    C.naveen09140 pointsBadges:
  • Reading all AS/400 records

    i want to read all the records in a file.. and there are no locks on the file during this process.. how will i read the records in fastest possible manner in AS400

    Nutangujar895 pointsBadges:
  • When will AS/400 record lock?

    Hi Guru's , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain or setll operation codes) ? If I will...

    SARKNS30 pointsBadges:
  • AS/400 records

    Suppose i have 3 members. how to read the records from all the members without using OVRDBF

    Hemavijay85 pointsBadges:
  • Is there any way to tell who added a record to the system reply list?

    Is there any way to tell who added a record to the system reply list?

    taekwondo90 pointsBadges:
  • Prevent record lock scenario with AS/400 ?

    Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...

    Supriyoas400130 pointsBadges:
  • Record existence

    How do you know if a record exists without doing a READ and CHAIN?

    Minuvinu35 pointsBadges:
  • AS/400 Query Join Duplicate Records

    I have three files A, B, C in my join query. Test is between A - B, B - C. The type is 2 (match records to primary file). When I run the query, it is returning duplicates. What am I doing wrong?

    lorit365 pointsBadges:
  • How use CPYTOPCD to record 240 long

    I have tried to create a file where every record is 240 characters long. Every record should be filled with spaces if the record is shorter than 240 char. In my program I use CPYTOPCD option TRNFMT(*NOTEXT) but the record is cut on 132 characters.Please, anybody could help me to solve this?

    Xaviers5 pointsBadges:
  • How do you know if a record exists without doing a READ and CHAIN?

    How do you know if a record exists without  doing a READ and CHAIN? is it possible with BIF's or ?

    721115 pointsBadges:
  • Avoid reading uncommitted records in AS400…

    is it possible to avoid reading uncommited records in AS400?

    As400xyz25 pointsBadges:
  • test value of list in AS/400

    What is the definition of the test value list?

    Qwerty545 pointsBadges:
  • Sequenced Records

    In one of our tables there is a sub-table that keeps records based on sequence numbers. These numbers vary from record to record. Is there any logic statements within as400 queries that will tell it to just pick the most recent and Active sub-record for each record? Any help you can give would be...

    JMarks224815 pointsBadges:
  • DSPFD – Asking for some explainin about a field in DSPFD output

    Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.

    QPFRADJ155 pointsBadges:
  • AS/400 SQL Update for matching records

    I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...

    Marshphil5 pointsBadges:
  • Maximum number of records that can be stored

    What is the Maximum number of records that can be stored on an as400 data file.

    JohnsonMumbai1,160 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