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

    ITKE346,250 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...

    ITKE346,250 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...

    ITKE346,250 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...

    ITKE346,250 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)...

    ITKE346,250 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...

    ITKE346,250 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...

    ITKE346,250 pointsBadges:
  • I’m having trouble with a simple query in DB2 for AS/400

    I know I'm an amateur when it comes to AS/400. I have this "easy" query but I still can't do it. Here's what I have:A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1And this is how I want it returned:A B C 1 1100 10 2 1200 8 3 1300 6I tried this but it's only...

    ITKE346,250 pointsBadges:
  • Impacted RPG programs

    Hi,I want to change the file structure in a PF which has no LF, How can I indentifyall the impacted programs without using any utility. I believe i can do find string and get the list but copybooks may also have used in those programs, which could not be found right?Please advice,Thanks,Dev

    as400dev480 pointsBadges:
  • How to use QtmmSendMail API

    I want to use the API QTMMSENDMAIL for sending multiple attchments in a single email , the description for this API on IBM info centre says that one needs to save a file in IFS folder in the ASCII MIME format .I am not aware about this format and how to convert a file of AS400 into this format .I...

    asakla240 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE346,250 pointsBadges:
  • Problems in iSeries with Entity Framework

    Working in AS/400 withDB2Connect with Entity Framework, trying to create a EDMX file in iSeries. I can see that records have been produced but cannot save them. I get this error message: ERROR [55019] [IBM][AS] SQL7008N REXX variable \"INVENTORY \" contains inconsistent data. My initial research...

    ITKE346,250 pointsBadges:
  • Parameter issues in VB.NET for AS/400

    I am having problems getting parameters to work within a VB.NET query written to AS/400. Any time I include a parameter in my query (ex. @MyParm) it doesn't work. I get the following error: SQL0206: Column @MyParm not in specified tables Here's my code: Dim da As New OleDbDataAdapter Dim dt As New...

    ITKE346,250 pointsBadges:
  • Strange compute function results in AS/400 while using Cobol

    Can someone help me solve this problem using the COMPUTE function in AS/400. 01 WSAA-AMOUNT-A PIC S9(15)V9(02) COMP-3. 01 WSAA-AMOUNT-B-01 PIC S9(16)V9(02) VALUE 0. 01 WSAA-AMOUNT-B-02 PIC S9(13)V9(05) VALUE 0. 01 WSAA-AMOUNT-C PIC S9(16)V9(02) VALUE 0. 01 WSAA-RESULT PIC S9(15)V9(02) VALUE 0. MOVE...

    ITKE346,250 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