• How to increase the no. of records accomodated in a sequence no. field of 6-digit (Numeric Field) length?

    Dear all! My situation is..... I have a field (Sequence Number) which is a numeric-field (Len 6,0). Now the records this field can accommodate is limited/restricted to a maximum of 999999. This application has been running for years together now. Therefore the demand to accommodate maximum no. of...

    svankipu620 pointsBadges:
  • Fetching multiple rows in SQLRPGLE

    Hi, When I try to fetch more records, I couldn't do it. Please see my code below and explain. Thanks.

    as400dev505 pointsBadges:
  • F8 key in AS/400

    iSeries Access for Windows was recently installed on my PC. Would it be possible to customize the F8 key whereby when the F8 key is held down, it goes through the records continuously?!

    DIAS400Newbie40 pointsBadges:
  • AS/400 – Chain file

    I wanted to do Chain Kfld File1 If Found And Fld1 = 'Y' Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve this?

    rajeshece1,215 pointsBadges:
  • About AS/400 record

    A file is opened in a program in input mode and he turned the parameter 'file addition' to 'A'. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?

    JSDHFKJHA335 pointsBadges:
  • Copying records

    Hi, I need to copy file with records from one server to another server. For example, File1 from server1 has 1000records. I need to bring this to server2.

    22917515 pointsBadges:
  • Copying records

    Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.

    22917515 pointsBadges:
  • AS/400 Record Lock

    CL control program Starts commitment control STRCMTCTL LCKLVL(*CHG) CMTSCOPE(*JOB) Calls a complex sequence of RPGLE programs Issues COMMIT Issues ENDCMTCTL A rather complicated series of RPGLE programs: open files for update read records sometimes update records sometimes call other programs...

    philpl1jb51,355 pointsBadges:
  • DB2/400 basics

    How will I find out total number of records in a DB file without causing any I/O operation?  Also How will I detect the existence of a record in a DB file without causing any I/O operation?  I think I can use INFDS and the field *RECORD but not sure how this works. Thanks, Nutan

    Nutangujar895 pointsBadges:
  • Chain function to find a specific record

    Hi everyone. I need to use CHAIN function to find a specific record. The key is composed from 4 field but I know only two of them. It is possible? Thanks a lot (and sorry for my bad english!! :-( )

    GiuGia20 pointsBadges:
  • AS400 Query: Date Concatenation

    I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily to other files? Not...

    Sblackshaw25 pointsBadges:
  • Read record from multi record format LF using RPGLE

    is it possible, read records from multi record format LF using RPGLE. if it is possible, how to do this... 

    TomLiotta125,585 pointsBadges:
  • AS/400 Query – wild card for LIKE test

    When I select records usinf the LIKE test, what wild card character do I use? LIKE 'air%'?

    CooperDuper5 pointsBadges:
  • delete hstry

    how to delete hstry of a job from log?

    Rajasekhar151,395 pointsBadges:
  • AS/400 Scenario

    Q. I have a file with millions of records and I want to read the last record from that file.But the conditions are as follows(assume): 1. The file do not have any key field. 2. The file do not give any RRN Number(Assume). 3. We are not allow to use the loop till EOF as we have millions of records....

    ankit2002770 pointsBadges:
  • AS400 record lock

    I have a issue with a record lock. One of the user has locked and updated the record. He has signed off from the system. I want to update the same record but an error message is displayed saying the record is still locked. Kindly help.

    AS400RPG5 pointsBadges:
  • Records lock error

    I keep getting a records lock error even after I change the setting to no records lock.

    Tbartlett20105 pointsBadges:
  • Record Locking in SQLRPGLE

    Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program... if any data structure supports, whats the position of it... -Varun

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

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