• 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,335 pointsBadges:
  • Local F specs in V5R4

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

    ITKE351,335 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,335 pointsBadges:
  • problem installing iseries access

    i can't install iseries access(V5R3M0) on windows 8 enterprise

    fischeprov5 pointsBadges:
  • subfiles

    can any one share a link where i can read a example of auto refresh subfiles.... thanks

    Durgesh813370 pointsBadges:
  • I need help creating a delimitted string in DB2

    Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...

    ITKE351,335 pointsBadges:
  • RPGLE: Can’t see print to command window

    I'm hoping someone can help me! In my RPGLE program, I currently can't see the DSPLY 'some text' output in the command window. I'm using IBM WebSphere development studio client for iSeries to create a simple RPGLE program. I'm compiling the program with no errors or programs but I can't see the...

    ITKE351,335 pointsBadges:
  • Remote Java Program for zip codes in RPG

    I'm designing a remote Java program to look up zip codes for RPG running on iSeries V5. Its a web client service running in Websphere. Is there a way I can set this up so that the calls go through RPG instead of having to create another Java program to handle it?

    ITKE351,335 pointsBadges:
  • Are logical files and indexes the same thing?

    My background is certainly in MSSQL and I've asked people at my company if they have created indexes on certain columns. They always says yes but point me to logical files.When I'm using iSeries Navigator, logical files show up under the "Views" category. However, when I click "Indexes", nothing...

    ITKE351,335 pointsBadges:
  • Scheduling join queries in AS/400

    I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?

    ITKE351,335 pointsBadges:
  • RPG: INLR statement

    I've recently been looking at some legacy programs, such as the following code:C/free Dow 1=1; SubRoutine(); EndDo; *INLR = *On; /end-freeThe program that I'm questioning is a "server-like" program, where the sub routine handles incoming requests over the network. I feel like the *INLR=*On...

    ITKE351,335 pointsBadges:
  • Install GIT on AS/400 system running PHP

    Is it possible to install GIT on an AS/400 system running PHP?

    ITKE351,335 pointsBadges:
  • AS400 – displaying window in *DS3 screen size over SFL in *DS4 screen size

    I want to be able to display a window with a 24x80 screen size, without removing the background SFL which is displayed with a 27x132 screen size. Haven't been able to do it. I have tried 2 different formats in one display file, using 2 line and position definitions per field (one for DS3 and...

    Zack250 pointsBadges:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE351,335 pointsBadges:
  • How can I run an RPG function in Java?

    Within Java, how can I call a RPG Function that can pass parameters, return result sets, and output parameters?

    ITKE351,335 pointsBadges:
  • AS/400: I’m trying to call a RPG program from PHP

    We're currently using an AS/400 system. I was asked by my boss to to look for a way to call RPG programs from PHP on our Apache server. The only solution I've come up with was installing Zend server to AS/400 and using the i5 PHP API Toolkit. Since I don't fully understand AS/400, I haven't tried...

    ITKE351,335 pointsBadges:
  • Mochasoft tn5250

    Hi, I have recently downloaded the Mochasoft trial version. I installed the same in my personal laptop for my basic learning. Now the problem I'm having is I'm not able to connect to the AS/400 server. Can anyone please share the IP address which can be connected to AS/400 for public usage? Or tell...

    mgkrish5 pointsBadges:
  • CASE keyword statement in DB2 for IBM iSeries

    I've been recently writing queries for DB2 on an IBM iSeries box. I know about the "CASE" keyword, but it's not working for me. I keep receiving this error message: Keyword CASE not expected. Here's one of my sample code: IF EXISTS ( SELECT * FROM MYTABLE WHERE KEY = xxx ) THEN UPDATE MYTABLE SET...

    ITKE351,335 pointsBadges:
  • Does anyone know how to suppress form feed and Carriage return characters in a print file (AS/400 spool file).

    Does anyone know how to suppress form feed and Carriage return characters in a print file. I am sending a Spool file to a xerox printer. When I display the spool file I don't see any of these special characters. However, when the xerox gets the file, these special characters are present. This is...

    ahshehab85 pointsBadges:
  • AS/400: Error while trying to display file in module

    I've recently been doing some research on trying to create modules and service programs in ILE, but I'm having trouble finding information on defining a display window (prompt screen) inside a module. Here's the code I've tried (I keep getting an error that the RECNO parameter (RNN here) is not...

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