• AS/400 query select count distinct

    Hello, does someone knows how I can count distinct values on a column via query select? (same as count distinct via SQL)

    WOES9995 pointsBadges:
  • Was your RPG to Java migration successful?

    Basically our company uses IBM iSeries for the majority of our data processing. Almost 99% of our internal applications are written in RPG. We realize IBM is trying to push companies towards Java/J2EE / we're trying to modernize our apps with a GUI interface. Not to beat around the bush but our...

    ITKE345,295 pointsBadges:
  • I can’t figure out how to organize RPGLE subversion repository

    My company has a ton of RPGLE-sources for their in-house application but they want to adopt a more modern style of coding. Basically, I'm "modernizing" the whole coding process and the open source subversion of OS/400 is working great but there are two issues during installation. Here's the code:...

    ITKE345,295 pointsBadges:
  • AS/400 iSeries code exceptions

    I'm trying to connect to a AS/400 server using the .net classes.  Also, I'm running a 64 bit version of Windows 7. The reference is to IBM.Data.DB.iSeries using the following code: var conn = new iDB2Connection("DataSource=111.111.111.111;UserID=xxx;Password=xxx; DataCompression=True;");...

    ITKE345,295 pointsBadges:
  • Receiving error message when calling Java method from RPG

    I've been having a lot of trouble with a "ClassNotFoundError" when I'm trying to call a Java method from RPG. This has been happening with several other users as well. It seems that it could be a problem with CLASSPATH or access to JAR files. I've give a better description: We have a RPG program...

    ITKE345,295 pointsBadges:
  • Programming an alarm in RPG with AS/400

    I need a little help building an alarm for unlocking blocked cells when a particular action takes place.  Here is the code I've written, but it doesn't work right.  I'm using RPG with AS/400. volatile bool interrupted; main() { sigaction(SIG_ALARM, myhandler) // register handler alarm(3) // set...

    ITKE345,295 pointsBadges:
  • Having issues connecting DB2 with .NET

    I'm trying to connect to a DB2 database (an iSeries version) using .NET by referencing a .DLL and not installing software on my server. I currently have IBM.Data.DB2.iSeries.dll installed as part of iSeries access for Windows. Is there an easy way to connect from .NET to DB2 by referencing a .DLL...

    ITKE345,295 pointsBadges:
  • RPGLE program to check data across 3 file systems

    I'm working on a project with RPGLE wherein we purge customer numbers from our files if there is no data behind the record. This purge will take place across three file systems. Of course, it's not as simple as a yes/no situation. In one of the file systems, we need to verify that there is no...

    ITKE345,295 pointsBadges:
  • Reducing Impact of increasing a field length of AS400 file

    I am currently working on a project where there is a file which has a field of length 3 (packed decimal). Under the project, we need to increase that length to 5 packed decimal.But this change is causing a lot of impact on the system as lot of programs and queries need to be changed/recompiled. Is...

    sanras12330 pointsBadges:
  • Java program crashes with RPGLE interface

    A good friend of mine recently created a Java program that creates PDF files that are based to GNUPDF. It's running great when he's using a native Java code but when it's used through RPGLE, the program crashes when it processes images. He tracked it down when of them to loading an image from a...

    ITKE345,295 pointsBadges:
  • AS400 – FTP, compiling objects

    Hi I have .txt source files in my desktop,i need to copy those .txt files in AS400 machine as a member in QDDSSRC/TEST library.how can i ftp those source files and compile those objects? Pls explain the steps to do it. Thanks

    iiiiiiiiiiiii335 pointsBadges:
  • AS/400 refresh options

    I have server with a userclass QPGM and no special authority. I need to refresh option instead of f5 & shift f7. condition as if I'm not interrupting the server within 15mns it's disconnected and I want to login again. Please give me solution and what they did, its act like?

    07091988ramya55 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,580 pointsBadges:
  • How can I manipulate a string in RPG?

    I know this might sound like a "beginner" question but I know most of the time strings in RPG have a fixed length (but more importantly, have a finite length). But I'm pretty much lost on how to write a procedure for string manipulation.How can I write a procedure that takes care of a string of...

    ITKE345,295 pointsBadges:
  • Building a .NET solution on an AS/400 system.

    I'm looking to build a .NET reporting solution on top of an existing AS/400 system. Before I do so, I have a few questions I'd like cleared up so that I can get the most value out of the setup. What would be the best integration technology to use. Should i develop the system so that logic calls are...

    ITKE345,295 pointsBadges:
  • FTP PUT problems in Windows PC to AS/400

    I'm trying to execute an FTP PUT command via a Windows PC to AS/400, but it isn't functioning correctly. This is the command (running as a batch file) I am running. Could anyone explain why its not working right? open ipAddress Kishore //user pwd //password quote RCMD CRTLIB LIB(TESTXA)...

    ITKE345,295 pointsBadges:
  • Exchange server

    Can I work with Exchange server without public IP? If yes, how?

    ikhaireddein20 pointsBadges:
  • Struggling to rest failed signon attempts to 0 in AS/400

    When I'm using AS/400 to authenticate a user's credentials (and I'm successfully connected), it's not resetting the "Failed signon attempts" to 0. Here's what I'm currently seeing:User profile . . . . . . . . . . . . . . . : BOB Previous sign-on . . . . . . . . . . . . . : 12/12/13 21:34:08...

    ITKE345,295 pointsBadges:
  • clear label printing

    I want to overprint on clear plastic labels on a Zebra ZM400. How do I do this? Can I add a black sensing mark at the edge of each label?

    nigelmclisky5 pointsBadges:
  • Slow performance from .NET to AS/400

    We're not big AS/400 experts but we are currently working on a .NET application that needs to access AS/400 for real-time We've been getting some varied results (on queries) over the past two weeks and can't figure out why. Our first request (SPROC on AS/400), it usually takes about 15 seconds to...

    ITKE345,295 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