• Change numeric field to character field in free-format RPGLE program

    I wanted to change Numeric Field to Character field. I am using Free format RPGLE Program. I have used %Char to do this operation. It is moving 2 to Character field, While trying to move 02 to Character field. I am expecting '02' in Character field. How to achieve this in Free format RPGLE Program?

    rajeshece1,215 pointsBadges:
  • Return control to program in self-expanding subfile

    How to return the control to the program in self expanding subfile while pressing page up?

    Tomseb0 pointsBadges:
  • Single Page Subfile code

    Hi i have started learning Subfile and i've written a Load All Subfile code to display all the records in a PF. Iit is working fine.But I want to know what else should i include in this code to make it accodring to coding standard. Also i need help in writing the single page Subfile program.So what...

    ITKBHARAT120 pointsBadges:
  • How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • How to convert RPG source into RPGLE

    I tried the command CVTRPGSRC to convert RPG source into RPGLE but getting run time error that says: "Format name in log file QRNCVTLG library QGPL not the same as format name of model. Conversion terminated."

    Nikrajpapa230 pointsBadges:
  • Style error while opening

    I have a program (RPGLE, iSeries) which creates XML Excel. This program is running fine on almost 20 LPARS but on one LPAR, we are getting style error while opening Excel. When saw the XML code in notepad generated by program in color(XML code), # is replace by Ä. It should be (ss:Color="#0000FF")...

    Rajeev singh Chandel5 pointsBadges:
  • AS/400 RPGLE batch job

    How do I batch job end?

    AS190 pointsBadges:
  • AS/400 RPGLE system date

    How do I retrieve the system date in RPGLE? And is coding needed for me?

    AS190 pointsBadges:
  • Calling a stored procedure on a remote server using embedded SQL in a RPGLE program

    I have written a RPGLE program in which I access a remote SQL server and then call a stored procedure on this SQL server. There are no parameters. I just call the stored procedure using embedded SQL in my RPG program. The program comes back with a -204 error code. It almost seems as if it cannot...

    GHENDER190 pointsBadges:
  • Modify display file in runtime

    I need to change field attribute in display file within runtime, is there any way to do that?

    SyriANgel15 pointsBadges:
  • Read the same file twice in a loop

    I have a scenario like this. FileA has a keyfield MVDT(8A - it has a character field which has date in yyyymmdd). I have an RPG program which accepts start date as parameter. I do a SETLL with the start date and reading the file till eof. Inside the loop, am reading another file which has another...

    RamvishakRamesh2,505 pointsBadges:
  • Why cursors are less efficient than RPGLE?

    I had created two programs for reading a PF and writing into another PF. 1) In RPGLE -- Runs very faster 2) IN SQLRPGLE using cursor -- Takes more time.. Why this CURSOR is slow? Both are AS/400 utilities right?

    dinuas400510 pointsBadges:
  • Can we debug a procedure?

    I am having an RPGLE program from which a procedure is called and when I'm debugging the RPGLE program, I'm not able to step into the procedure. Kindly share your ideas.

    dinuas400510 pointsBadges:
  • Edit code and edit word

    What is difference between edit code and edit word in AS/400? In which place should each of them be used?

    dinuas400510 pointsBadges:
  • Stored procedures in RPGLE

    I'm new to stored procedures. I learned how to create and now I want to learn, how to debug the stored procedure when called from java client application. On which AS/400 job can I start the debug, so that if some action is being performed on the client application, I can have the break point...

    Varun123190 pointsBadges:
  • How to use the value of a display file field in RPGLE Program

    I have a display file. In this display file user is entering a name. So how do I pull this name in the RPGLE program for further use?

    ankit2002770 pointsBadges:
  • Flat file in an RPGLE program

    I am loading a flat file in an RPGLE program. The file will be downloaded to a server and converted to .txt and .dbf. The recipient, a benefits provider, states in the file specifications that their must be a carriage return/linefeed at the end of each record. Can you provide some direction on how...

    Crickett0 pointsBadges:
  • Stored procedure error in RPGLE program

    I've to use stored procedure in RPGLE program. My code is CallP     OESP_PORD_001(IPAT#:OPNXT#:PRJUK) I get error name or indicator not defined...I checked the library, parameters and everything are in place....Am I calling the SP with the right syntax? I tried to then change this whole using...

    Nutangujar895 pointsBadges:
  • SQL system date

    I have a beginner SQL question. I'm new to using SQL on the iSeries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...

    RonKoontz1,780 pointsBadges:
  • Call to Windows subfile

    From a subfile, can I make a "call" to a window subfile?

    aldo40020 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