• I Series Client Access download

    Hi, I am downloading a keyed file using Client access in BIFF8 excel format to my PC. The process run fine but the problem is that the records are not in key sequence. Pls help!!! Regards, Alok

    shwetashlok5 pointsBadges:
  • Is it possible to connect PHP to iSeries OS/400?

    I need to desperately connect our website (which uses PHP5/Apache 1.3/OpenBSD 4.1) to our back end system that is running on a iSeries OS/400 V5R3. We need to access several tables that are stores in there. But, I've run into some problems.First, the DB2 extensions / software from IBM can only run...

    ITKE345,295 pointsBadges:
  • iSeries native job scheduler -QJOBSCD

    I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It's still active and the job scheduler is working fine.

    Dinnu360 pointsBadges:
  • 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:...

    ITKE345,295 pointsBadges:
  • Select Query in iSeries is running very slow

    I'm writing a query to pull different sets of data from a single table.  I tried the following SELECT query using Data Transfer in iSeries: SELECT INFOR.PFAC , INFOR.PPAR FROM MAINSYSTEM.INFOR INFOR WHERE ppar = '240XXX2A' It takes upwards of 4 minutes for the query to return the data I need. Here...

    ITKE345,295 pointsBadges:
  • Keep getting “Name or Indicator is not defined” error message

    A good friend of mine has been recently taking introductory courses on IBM iSeries and Rational Developer. And he's having trouble with one of the code problems in his class. When he's compiling a program "MARKSRPG.RPGLE, he keeps getting the error: "The Name Or Indicator Is Not Defined", His...

    ITKE345,295 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...

    ITKE345,295 pointsBadges:
  • I can’t figure out how to organize RPGLE subversion repository

    My company has a ton of RPGLE-sources for their in-house application but they want to adopt a more modern style of coding. Basically, I'm "modernizing" the whole coding process and the open source subversion of OS/400 is working great but there are two issues during installation. Here's the code:...

    ITKE345,295 pointsBadges:
  • AS/400 iSeries code exceptions

    I'm trying to connect to a AS/400 server using the .net classes.  Also, I'm running a 64 bit version of Windows 7. The reference is to IBM.Data.DB.iSeries using the following code: var conn = new iDB2Connection("DataSource=111.111.111.111;UserID=xxx;Password=xxx; DataCompression=True;");...

    ITKE345,295 pointsBadges:
  • Having issues connecting DB2 with .NET

    I'm trying to connect to a DB2 database (an iSeries version) using .NET by referencing a .DLL and not installing software on my server. I currently have IBM.Data.DB2.iSeries.dll installed as part of iSeries access for Windows. Is there an easy way to connect from .NET to DB2 by referencing a .DLL...

    ITKE345,295 pointsBadges:
  • Java program crashes with RPGLE interface

    A good friend of mine recently created a Java program that creates PDF files that are based to GNUPDF. It's running great when he's using a native Java code but when it's used through RPGLE, the program crashes when it processes images. He tracked it down when of them to loading an image from a...

    ITKE345,295 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,580 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE345,295 pointsBadges:
  • Manual Impact Analysis

    Hi,I used to work with Hawkeye to perform impact analysis.Is there any way manually, to find out the programs got affected, respective to the changes done.

    HABBIE820 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...

    ITKE345,295 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...

    ITKE345,295 pointsBadges:
  • Location for Java applications to iSeries

    We currently have a Java application, which we will call remotely using CommandCall. As of right now, we have placed it in "home/username" folder and specify the folder in the "CLASSPATH" parameter of the Java command.We have to ship the applications to various clients, which could be a number of...

    ITKE345,295 pointsBadges:
  • EXTPGM

    Hi, I am start-up kid on Iseries. Can I know the usage of EXTPGM keyword.

    HABBIE820 pointsBadges:
  • Is it possible for a RPG program to call something external?

    More of a general question here but I was wondering if there's a way for a RPG program to call a web service? I would perfer if it was ASP.NET but I would be fine with a WinForm app too.I want to make an Internet service available to iSeries by creating a gateway. Thanks!

    ITKE345,295 pointsBadges:
  • iSeries: Command that accepts object name as parameter

    I've been trying (and trying) to create a new command on iSeries, where the parameter has the same file name using the LIBRARY/FILE MEMBER syntax. Something like this:MYCMD FILE(MYLIB/MYFILE MYMEMBER)Or this:MYCMD FILE(MYLIB/MYFILE) MEMBER(MYMEMBER)I've tried several things including:Create a PARM...

    ITKE345,295 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