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

    ITKE355,620 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

    ITKE355,620 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...

    ITKE355,620 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...

    ITKE355,620 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?

    ITKE355,620 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?

    ITKE355,620 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?

    ITKE355,620 pointsBadges:
  • iSeries: Channel transfer problem with NIO file

    One of my good friends has been having trouble with Java NIO code running on iSeries box (JDK 1.5). From what he's told me, the code is splitting a file up into chunks (part of the file to another smaller file). The same code has been operating on other iSeries boxes for some time with no problems....

    ITKE355,620 pointsBadges:
  • security for iSeries client access data transfer

    I like to know how we can block user from using client access data transfer?

    CHL5 pointsBadges:
  • I’m trying to connect to AS/400 using .NET

    I'm looking to build a .NET web application using SQL (to query an AS/400 database). This is actually my first time I'm working with AS/400.What do I have to install on my machine in order to connect? Is it IBM iSeries Access for Windows? What are the components of the connection string? Any help...

    ITKE355,620 pointsBadges:
  • AS/400 and DB2: Pagination query

    I'm currently working on a project in which I'm trying to create PHP web-based paging for our tables that have over a million rows. I've figured out that I have three options:Retrieve all rows in resultset (Not possible due to the size)Retrieve 1,000 rows, put in temporary table and create an...

    ITKE355,620 pointsBadges:
  • Scraping AS/400 screens

    I'm looking for an innovative (read: free) way to scrape an AS/400 screen using PHP? Over time, we've had a number of programmers writing AS/400 applications and now I've been tasked with finding a way to make the screens they've developed available outside of AS/400. My first thought is to use...

    ITKE355,620 pointsBadges:
  • RPG programming: Are nulls not permitted?

    I know this might be an off-topic discussion but I was recently told by one of our RPG programmers that none of our AS/400-based DB2 database tables can permit nulls because "they're really difficult to program" for in RPG. Is this true? If so, what makes the basic database feature so difficult in...

    ITKE355,620 pointsBadges:
  • Problems with Commitment Control in iSeries

    I'm running an iSeries ILE program and trying to end commitment control with ENDCMTCTL.  Unfortunately, instead of this working correctly, I get the following error message: CPF8355 - ENDCMTCTL not allowed. Pending changes active What is the proper way to do this without simply signing out and...

    ITKE355,620 pointsBadges:
  • Receiving error message in DB2/400 drop column

    I'm looking to drop a column, known as "id", which would auto incrementing PK. Here's the SQL:alter table "CO88GT"."XGLCTL" drop column id cascade;And I've been this error:Error: [SQL0952] Processing of the SQL statement ended. Reason code 10. SQLState: 57014 ErrorCode: -952I'm not sure but it...

    ITKE355,620 pointsBadges:
  • RPGLE programs: Memory leaks

    I've been putting into production some RPGLE code, which uses "%alloc" and "dealloc" to allocate memory. I know programmers shouldn't worry about resulting memory leaks but I'm worried about if it actually does happen.So here's my question: If a programmer messes up and there actually is a memory...

    ITKE355,620 pointsBadges:
  • Sending IFS attachments via iSeries?

    I need to send an email with an attachment from IFS. Is this possible using an iSeries terminal?

    ITKE355,620 pointsBadges:
  • Free IT Book: AAA Identity Management Security

    This week's free IT book is your complete, authoritative guide to implementing, configuring, and managing AAA with CiscoSecure ACS. For a chance to win AAA Identity Management Security, answer one of the questions listed below and post the link to your answer in the discussion section of this...

    MelanieYarbrough6,345 pointsBadges:
  • Source size limit in SQLRPGLE

    I've been having some problems compiling a 25,000 line program and I'm figuring that a line limit is causing all of my errors. Is there a limit to what the SQL pre-complier can handle for a SQLRPGLE source object?

    ITKE355,620 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