• Record locking in iSeries

    My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to check the ROLBK....

    Kar425 pointsBadges:
  • SELECT with LIMIT in AS/400

    Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT...

    junioras400250 pointsBadges:
  • Records limited when downloading from AS400 to Excel

    When downloading from AS400 to excel, my records are limited to 16383. I can't find the place on Iseries FTP Version 5 release 2 to stop it from limiting the records. Please help.

    Worksalot15 pointsBadges:
  • 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.

    CharlieBrowne62,055 pointsBadges:
  • Reorganizing AS/400 Files While Active

    I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must have journaling...

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

    Supriyoas400250 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:

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