• iSeries stored procedure isn’t returning value when calling RPG program

    Our team currently has a stored procedure that calls an SQLRPGLE program. It's running great as we have verified the debugger and it sends the return value as expected. But the problem is what is returned when we're looking at cmd.Parameters["@ISMATCH"].Value = {} Here's our stored procedure:...

    ITKE364,180 pointsBadges:
  • Like in SQLRPGLE

    Hi, I am using the below query in SQLRPGLE Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" . The tpnumber is a character field(10a). Sample file is a flat file I even tried '%' +:tpnumber+" '%' and '%'...

    Prashanth123255 pointsBadges:
  • Data from RPG to Java isn’t properly ordered

    We're sending "foreign data" (from a different language) from a RPG program to a Java program but some of the data isn't coming in properly. The RPG program is currently running on an iSeries machine and Java is through a remote method invocation. The data is received by the Java program in logical...

    ITKE364,180 pointsBadges:
  • Was your RPG to Java migration successful?

    Basically our company uses IBM iSeries for the majority of our data processing. Almost 99% of our internal applications are written in RPG. We realize IBM is trying to push companies towards Java/J2EE / we're trying to modernize our apps with a GUI interface. Not to beat around the bush but our...

    ITKE364,180 pointsBadges:
  • Receiving error message when calling Java method from RPG

    I've been having a lot of trouble with a "ClassNotFoundError" when I'm trying to call a Java method from RPG. This has been happening with several other users as well. It seems that it could be a problem with CLASSPATH or access to JAR files. I've give a better description: We have a RPG program...

    ITKE364,180 pointsBadges:
  • Programming an alarm in RPG with AS/400

    I need a little help building an alarm for unlocking blocked cells when a particular action takes place.  Here is the code I've written, but it doesn't work right.  I'm using RPG with AS/400. volatile bool interrupted; main() { sigaction(SIG_ALARM, myhandler) // register handler alarm(3) // set...

    ITKE364,180 pointsBadges:
  • How can I manipulate a string in RPG?

    I know this might sound like a "beginner" question but I know most of the time strings in RPG have a fixed length (but more importantly, have a finite length). But I'm pretty much lost on how to write a procedure for string manipulation.How can I write a procedure that takes care of a string of...

    ITKE364,180 pointsBadges:
  • Can my friend call a remote Java program on iSeries from RPG?

    One of my good friends (who's a programmer) is looking to invoke a Java program from RPG running on iSeries V5R4. His remote program is a web services client, running in WebSphere. He would like to call it direct from RPG...is that possible? Does he have to create a program to run on iSeries and...

    ITKE364,180 pointsBadges:
  • Verifying user, password and open menu of RPGs

    I currently have a login module in my AS/400 application where the user name and password are verified and only if the password matches the user, they are given access to the Menu screen (with contains RPG programs). I'm trying to find out if it's possible to achieve that when the user is verified,...

    ITKE364,180 pointsBadges:
  • Reading liblist through an ILE program

    Our part of the company controls what objects our programs on our AS/400 work, running them with different liblists. But we know that some operations can't be controlled by this. Our program needs to read the liblist and decide on some of the libraries in it (and how to act).But we couldn't find...

    ITKE364,180 pointsBadges:
  • How can I access RPG on iSeries from Java?

    I'm pretty much a beginner on all things AS/400 related so I'm trying to find out if other professionals have had good experiences of talking direct to RPG programs running on a v5r4 iSeries machine from Java. What pitfalls should I try to avoid with this?From what I've read, I can use...

    ITKE364,180 pointsBadges:
  • DSPFD and DSPDBR

    Hi, Difference in the no of physical file count in a library using the DSPFD command and DSPDBR. DSPFD FILE(/) TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(/File1) OUTMBR(*FIRST *ADD) When I try to take the count of this outfile for type ='P' the value is 1000(For eg). But when I store the results of DSPDBR...

    Prashanth123255 pointsBadges:
  • Execute SQL statement using an RPG variable

    I'm trying to pass a cursor and data structure to a procedure. That procedure should populate the structure with the next row from a SQL cursor. Here's what I'm trying to do: ***************************************************** * * Fetch the next row from a cursor * * @param cursor - the name of...

    ITKE364,180 pointsBadges:
  • How to tell why a program is failing in RPG

    Is there a way that an RPG program can log what happens when a program call fails? I need to know if what I am running is failing due to an authority issue or because it could not find the program. How would I do this?

    ITKE364,180 pointsBadges:
  • Could we set compiler options for activation groups in RPG/CL program?

    In most of our AS/400 programs, we need to change the handling of the activation group (since the default behavior is not useful). When I compile one of those programs, I have to remember to set the complier options. (Depending on the program)enter 14, hit F4, change DFTACTGRP from *YES to *NO, hit...

    ITKE364,180 pointsBadges:
  • RPGLE: Conditional Compilation?

    This is more of a general question but I'm wondering if I can include a section of code that's based on whether a variable is defined in my program or is the preprocessor completely not able to access this info (only compilation conditions)? This is what I'm looking for:/IF DEFINED(myVariable) D...

    ITKE364,180 pointsBadges:
  • Remote Java Program for zip codes in RPG

    I'm designing a remote Java program to look up zip codes for RPG running on iSeries V5. Its a web client service running in Websphere. Is there a way I can set this up so that the calls go through RPG instead of having to create another Java program to handle it?

    ITKE364,180 pointsBadges:
  • RPG: INLR statement

    I've recently been looking at some legacy programs, such as the following code:C/free Dow 1=1; SubRoutine(); EndDo; *INLR = *On; /end-freeThe program that I'm questioning is a "server-like" program, where the sub routine handles incoming requests over the network. I feel like the *INLR=*On...

    ITKE364,180 pointsBadges:
  • How can I run an RPG function in Java?

    Within Java, how can I call a RPG Function that can pass parameters, return result sets, and output parameters?

    ITKE364,180 pointsBadges:
  • RPG programming: Are nulls not permitted?

    I know this might be an off-topic discussion but I was recently told by one of our RPG programmers that none of our AS/400-based DB2 database tables can permit nulls because "they're really difficult to program" for in RPG. Is this true? If so, what makes the basic database feature so difficult in...

    ITKE364,180 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