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

    ITKE1,000,705 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...

    ITKE1,000,705 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...

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

    ITKE1,000,705 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...

    ITKE1,000,705 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?

    ITKE1,000,705 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?

    ITKE1,000,705 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...

    ITKE1,000,705 pointsBadges:
  • EXTPGM

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

    HABBIE895 pointsBadges:
  • goldmine version 6.0 single user

    Will goldmine 6.0 run single user on 64 bit windows 7 Home Premium? I used goldmine 3, 4,5, & 6 single user and later on a 5 user network until goldmine moved on to their web based versions. I loved the program. I still have version 6.0 disks, and wonder if there is any way to use them single...

    smsincv5 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!

    ITKE1,000,705 pointsBadges:
  • in which jobd is lib

    I want to delete a lib. How can I find out in which jobd it is?

    nipponexpress5 pointsBadges:
  • Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE1,000,705 pointsBadges:
  • Creating Objects

    is it possible to create a spool file without creating object? If possible suggess me the steps..

    thambiyannanvignesh50 pointsBadges:
  • Creating an integer in RPGLE

    Looking for a way to create an integer in RPGLE in a way that is similar to the int command in Java. Is there anything like this?

    ITKE1,000,705 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...

    ITKE1,000,705 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...

    ITKE1,000,705 pointsBadges:
  • Can I select the identity value from an insert statement?

    Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically,...

    ITKE1,000,705 pointsBadges:
  • Locating active procedures in iSeries SQL

    I have a strange problem in iSeries SQL. I'm running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist...

    ITKE1,000,705 pointsBadges:
  • Trying to call a DB2 stored procedure in IBM System i Access

    I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database. My big question: What is the syntax to execute a stored procedure that takes in a parameter /...

    ITKE1,000,705 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.

Thanks! We'll email you when relevant content is added and updated.

Following