• Download data from iSeries to Excel

    How do I download data from iSeries to Excel?

    lr538615 pointsBadges:
  • OPNQRYF to emulate a joined logical file

    Hello everyone, I'm in a bit of a bind here. Hope you could help me.We have a requirement where we should modify an CLLE program to switch reading a file between two libraries (depending on the entry parameter). This would then be read by a called RPGLE program.Switch 1: Read environment...

    Vsevilod135 pointsBadges:
  • Monitoring an iSeries server (With PowerHA)

    Hi I have a question regarding an iSeries server P770 that has PowerHA replicating on another P770.  My question is how can we monitor this iSeries server. Would the PowerHA work with an SNMP monitoring tool like Zenoss?

    yosra12310 pointsBadges:
  • Writing Records from a Display file

    Hi,I am new to this technology.Cleared all the basics & started programming.I just want to add some records to a physical file from a display file, using RPG/RPGLE .Could you please let me know the outlines how to code this. Thanks

    HABBIE795 pointsBadges:
  • iSeries font libraries

    I need to install the QFNT libraries on my iSeries but I'm not sure where they are located.

    msteinbugl5 pointsBadges:
  • How to pull a list of userprofiles and group profiles in an iSeries

    Need a list that differentiates usrprf and grpprf.

    harisudhan211,005 pointsBadges:
  • 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...

    ITKE334,795 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:...

    ITKE334,795 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...

    ITKE334,795 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...

    ITKE334,795 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...

    ITKE334,795 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:...

    ITKE334,795 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;");...

    ITKE334,795 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...

    ITKE334,795 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...

    ITKE334,795 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...

    ITKE334,795 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.

    HABBIE795 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