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

    ITKE351,965 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...

    ITKE351,965 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?

    ITKE351,965 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?

    ITKE351,965 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...

    ITKE351,965 pointsBadges:
  • EXTPGM

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

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

    ITKE351,965 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!

    ITKE351,965 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?

    ITKE351,965 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...

    ITKE351,965 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...

    ITKE351,965 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,...

    ITKE351,965 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...

    ITKE351,965 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 /...

    ITKE351,965 pointsBadges:
  • Local F specs in V5R4

    How does one simulate local F specs in V5R4 in a SRVPGM procedure?

    ITKE351,965 pointsBadges:
  • Can I convert single characters into integers in RPGLE?

    I'm looking for a way to convert single characters in RPGLE into integers. It would have to work for all inputs and provide a different integer for each input (or at the very least provide a different value for all common inputs). This is a sample code of how I would like it to work:characterData =...

    ITKE351,965 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