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

    ITKE409,400 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...

    ITKE409,400 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?

    ITKE409,400 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...

    ITKE409,400 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?

    ITKE409,400 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...

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

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

    ITKE409,400 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...

    Zack265 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?

    ITKE409,400 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...

    ITKE409,400 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...

    ITKE409,400 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...

    ITKE409,400 pointsBadges:
  • How to disable joblog on QZDASOINIT?

    When a webpage makes a ODBC query, it writes to the joblog on QZDASOINIT, but I don't want this to happen as it is flooding the log. Is there a way to disable this? I am working on AS/400 using PHP/PDO via a Linux Centos server, running iSeries

    ITKE409,400 pointsBadges:
  • Character counting in a string in RPGLE

    How does one automatically read the number of characters in a string in RPGLE? I want to do this so that spaces are not counted, but punctuation and other actual characters are. For example "test" would come back as 4 characters, while "test underway" would read as 12 and "test underway!" would...

    ITKE409,400 pointsBadges:
  • AS/400: ODBC call continues to hang

    My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC...

    ITKE409,400 pointsBadges:
  • How to replace Regex in iSeries

    How can I use Regex Replace with iSeries? I can see how to match Regex via C++ libraries, but not how to replace it. Any ideas?

    ITKE409,400 pointsBadges:
  • How should I use String.format in RPGLE?

    I'm looking to interface RPGLE with String.format which would take variable length arguments or an array. If it's possible, I would also like to pass numbers as well as strings, so I'm thinking the format is like this:"hello %s, you are %d years old"How should I prototype this in RPGLE?

    ITKE409,400 pointsBadges:
  • AS/400 command creation. Help Needed.

    I need some help creating an AS/400 command that has two parameters that will display when F4 is pressed, but they must not be filled at the same time. If both fill at the same time, the system should throw an error message. What do I need to do to create such a command?

    ITKE409,400 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