• Question on SETGT

    Suppose if my logical file has records arranged in descending order of key field..say the LF has the following records EMPNO 10020 10015 10012 10011 10008 10005 10004 Now if I do SETGT with search argument as 10013, will the file pointer position on 10015 and the read operation will read 10015, the...

    A1b2c3335 pointsBadges:
  • Zip files on AS400

    I want to zip without the nested directories added to my zip file. I do not want to work in the root, i do not want to change my current directory, and I do not want to install a product. I want to pass the full path of the file to zip the full path of the zip file. When i open the zip i do not...

    JIMMUEHE35 pointsBadges:
  • How to get number of modified rows in subfile(SFL)?

    If READC function reads only modified records of a Subfile(SFL), I would like to know if there is any system function or it is any way to know the amount of modified records on a subfile(SFL) using an RPG file.EjemploREADC SUBFILE1; DOW %EOF = *OFF; IF VAR_FIELD_1 = 'A'; SUM = SUM + 1; ENDIF;...

    DaniPertuz5 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • Who is using an AS/400 file

    I want to clear a file in RPG, but find that it is in use. How can I determine, programatically, what user(s) is locking the file?

    Jck5 pointsBadges:
  • RPG stored procedures

    Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?

    junekotey50 pointsBadges:
  • Why a program works in debug mode, but doesn’t work at run time?

    I modified program(A) that calls another program(B)to generate a spool file. When I debug (STRDBG)program(A) and break right before the call, it works. But when I got out and end the debug mode and try to run that same program(A), no spool was generated. Then, I bebug only the called program(B)and...

    Techman250 pointsBadges:
  • Automatic email notifications from iSeries

    Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He's a Windows guy, and doesn't know where to start. Can someone help him with the code and possibly send him steps on how to write it and where and...

    MichelleDavidson515 pointsBadges:
  • Using XML-into in RPG getting error

    Hello.. I am having an issue using xml-into when my xml has only an ending tag. I am receiving error "XML document does not match RPG variable". The vendor sending the xml file to me states it is still valid xml and should not cause error. How can I get around this error using xml-into. My xml...

    clauinger15 pointsBadges:
  • Free websites to access AS/400

    Hi, can anyone can tell me the free sites to access AS/400, where we can do the actual RPG coding?

    Sabarish60 pointsBadges:
  • Display two subfiles on same page in RPG

    How can I display two subfiles on same pages in RPG programming with sample program to display the screens at the same time?

    junekotey50 pointsBadges:
  • Cursor not open in joblog

    I have a SQLRPGLE program, where I'm performing few activities using cursor. When I view the joblog after the program is called, I see "Cursor not open" message. I understand the reason for this message. But, my doubt is, when I debug the program, I could also see other messages like "row not found...

    sri8707255 pointsBadges:
  • Compare file in RPG AS/400

    How to check if the file a contents are inside file b? File contains table q,w,e,r,t,y.file b contains q and w. I want to check whether q and w contents are same in file a and file b. If not, I want to display an error message.("FILE B IS NOT UPDATED")

    sampathrsk20 pointsBadges:
  • Compile a RPG36 source member

    I'm looking for ideas on what else to try. We stopped changing the programs still running in the System 36 environment. We're finally eliminating that, but a few program mods would be useful during conversion. Of course, the method I remember for compiling fails now. The old method was to do OVRDBF...

    aceofdelts2,550 pointsBadges:
  • Decimal data error for blanks in zoned values

    I have a Zoned decimal field where blanks are accumulated and hence job is throwing decimal data error. Can you please tell me decimal data error occurs because of the blanks in zoned decimal field?

    vishwaraj60 pointsBadges:
  • Program works in debug but not run time

    I have an RPGLE program that works when run in debug mode but will not update the file when run outside of debug. I have looked at the obvious, such as library list to ensure using same versions of programs. At a loss......

    Weklis0 pointsBadges:
  • How to receive data in XML format from mainframe in to AS/400 using webservice (SOAP) for below fields:-Field Name length Data Type

    Hi, How can I write RPG program which should fetch data from mainframe system for a file which has 4 fields let's say A,B,C & D with below length and data types:-Field Name length Data Type A 7 NUMERIC B 2 NUMERIC C 5 NUMERIC D 5 CHARACTER Main intention is to fetch data from mainframe in to...

    6r2,460 pointsBadges:
  • Move all fields in a record format at once.

    How can I move all the fields of a single record format at once? I need to move fields totalling 712 positions to a single flat-file record that is also 712 positions long. I really don't want to move one-field-at-a-time into a data structure if I can help it.

    Mahler215 pointsBadges:
  • Unable to use 9 digit field in RPG

    I am using one PF file in RPG program, The file field is 9 digit. I can't able to use the field in RPG program. Any suggestion?

    Santhzh1240 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