• Receiving result sets in RPG (prior to release 7.1) from an SQL SP

    I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

    MapleLeafDeveloper5 pointsBadges:
  • Can you embed SQL statements in RPG program

    I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???

    Shwesmile20 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,020 pointsBadges:
  • Wierd messages in ISDB

    Hi, I have an elaborate program stream that starts with a CL which calls an RPG program that builds an OPNQRYF statement and selects records. After that, there are 9 RPG programs, one of which I’m trying to debug using ISDB. When I try to step through the RPG program, I receive a group of message...

    Floyd02320 pointsBadges:
  • Advanced Trigger question for *insert *before to allow update of field value

    I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values of the fields in the after...

    Dcdc5 pointsBadges:
  • Need help debugging RPG program

    John is trying to debug (STRISDB) a RPG program that has a ton of copy source in it. He said debug isn't working correctly; it seems to bounce all over the place. He said he made sure that the source and object match. Is there something special he has to do to debug RPG with copy source in it? --...

    MichelleDavidson330 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:
  • Help with scan

    Please could you submit a sample RPG program to scan specific letters in a string that contains numbers, letters and special characters. Thank you!

    Patricia7745 pointsBadges:
  • About Program Described input files

    hi all, Can anyone explain me what is meant by Program described input files and what is the use of this files compared to Externally Described files and please give one complete example program of using Program described files with I SPECS and explain me about Record identification codes

    Mohan K695 pointsBadges:
  • Link for download subfile programming in RPG ILE

    HI , i am working on ile rpg , & i just started to work on subfile programming . i want to lean subfile programming because i didn't work on it yet. i dont have any source like any document . i have downloded a pdf file for subfile programming its good but it is only For RPG not for ile. does it...

    Ambrish 82310 pointsBadges:
  • RPGLE arrays

    Please provide me the solution or at least a hint to this problem. Lets Suppose I have an array having 4 elements ( A, B, C, D). I would like to have all the possible combination of the 4 elements with no repetition (i.e. in mathematical terms 4C1 + 4C2 + 4C3 + 4C4 = 15). How can we do this in...

    BrentSheets6,875 pointsBadges:
  • Debugging an RPG module thru STRDBG

    Hi, As fate will have it one of our programmers did the majority of his code as modules. He passed away and now the code needs to be changed. He left no notes or comments on how he compiled things (e.g. if he used bound directories, etc) No one in the department has any knowledge of modules. I have...

    NYRANGER245 pointsBadges:
  • How To get The Cursor position on particular field?

    My display File Contains three Fields as like name= ........  Roll =........  Marks=.......  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To...

    Sms121185 pointsBadges:
  • RPG communicate with USB device?

    Can an RPG program running in a 5250 session on a pc communicate with a USB device on that pc? I've used sockets to communicate with devices on the network, but never with a device without an IP address. thanks, rick metzger

    RickMe110 pointsBadges:
  • Caloin Webservice From RPGLE

    I need to call a webservice from RPGLE.. I know all the examples out there. Anyone actually do it yet? If so did you have any problems with getting out from the 400?  Code examples would be good or a quick reference on what steps were done would be awesome.  Thanks  

    RonKoontz1,780 pointsBadges:
  • How to make password characters invisible in AS400?

    I am designing a login screen in AS400 box. How do I make the characters invisible while entering the password? Need Help!!

    vssagar70 pointsBadges:
  • Using the command RCVMSG

    There are numerous reports which automatically print throughout the day. Often there may be a message waiting on the printer and because no one was expecting any reports, no one discovers the problem until hours later. (By this time there may be quite a few reports waiting to print) I was...

    GHENDER175 pointsBadges:
  • Padding with zeros in Synon/2e

    How can we implement Padding with zeros (concept in rpg) in Synon/2e?

    MAGIC205 pointsBadges:
  • how to change AS/400 Textbase application to windowslike application

    Hey, who can give me advice, or has experince, to change an textbase AS/400 RPG & DDS application to an windowslike application?

    BERA40 pointsBadges:
  • How Do I Prevent RPG Low-Order Truncation When Storing Data In A File??

    I am calculating GPA to print on a report and store in a secondary file via RPG on an AS400.  When I print the GPA on the report, there is no low-order truncation; however, when I store this same field in my secondary file, low-order truncation occurs.  How do I prevent this?? Code as follows:...

    Pixieprogrammer110 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