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

    ITKE56,495 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...

    ITKE56,495 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?

    ITKE56,495 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...

    ITKE56,495 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?

    ITKE56,495 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...

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

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

    ITKE56,495 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...

    ITKE56,495 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?

    ITKE56,495 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...

    ITKE56,495 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...

    ITKE56,495 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...

    ITKE56,495 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

    ITKE56,495 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...

    ITKE56,495 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...

    ITKE56,495 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?

    ITKE56,495 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?

    ITKE56,495 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