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

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

    ITKE342,450 pointsBadges:
  • DB2/iSeries clean up

    I'm trying to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k string records but I'm having a ton of trouble with my DB2 environment.After doing some searching, and I thought replacing with the "REPLACE()" and "CHR()" functions could work, but it's not...

    ITKE342,450 pointsBadges:
  • How to link AS/400 with Java?

    I'm trying to figure out how to connect AS/400 to Java. I'm not a very experienced programmer in either system. Could someone provide me with links to very simple explanations on how to do it? Thanks!

    ITKE342,450 pointsBadges:
  • HTML, Excel, AS400

    can we post/store an excel file on the HTML site and link to the AS400 to pull data

    xxsinghxx20 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,...

    ITKE342,450 pointsBadges:
  • negative sign in physical file copy process

    this is regarding copy file.I have a physical file P1 and physical file P2. Now in P1 i have a zoned decimal field and in P2 i have a packed decimal field. let us assume i have the negative data in P1. after performig the CPYF to copy the P1 to P2, i am getting some junk characters ( '}', 'M', 'S'...

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

    ITKE342,450 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...

    ITKE342,450 pointsBadges:
  • Differing Results With SBMJOB Command

    We are having a problem using SBMJOB to run a long EXECUTE SQL command string on one of our environments. When we run the string from the command line, it runs. When we embed it in the SBMJOB command, it fails with a message indicating a missing apostrophe. Looking at the job log, the command seems...

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

    ITKE342,450 pointsBadges:
  • Having difficultly making my DB2 queries case sensitive

    I'm been having a lot of problems making my DB2 (AS/400) queries case sensitive. Here's an example of what I'm trying to do: SELECT * FROM NameTable WHERE LastName = 'smith' That returns zero results but this returns 1000's or results: SELECT * FROM NameTable WHERE LastName = 'Smith' Does anyone...

    ITKE342,450 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:
  • Creating attendance records using RPGLE

    Hi everybody! I'm tasked with developing an attendance system for work and I'm using RPGLE. The physical file contains the following fields: User ID(key field),Date,Time In,Time Out ...... I need the system to display records by the highest value of Time Out for a given day, and then use the Time...

    ITKE342,450 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...

    ITKE342,450 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?

    ITKE342,450 pointsBadges:
  • Subfile Identification

    Hi,Is it possible to find out , what kind of a subfile(Load All/Load Forward/Single page) it is? By just seeing the subfile screen itself.

    HABBIE810 pointsBadges:
  • Receiving error message while invoking RPG program through Java

    When I'm trying invoke RPG program using Java, I keep receiving this error message:**Application error. RNX9001 unmonitored by ZM30000R at statement N, instruction X'0000'.*Does anyone have an idea about what could be the reason for this error?

    ITKE342,450 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...

    ITKE342,450 pointsBadges:
  • EXTPGM

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

    HABBIE810 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