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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    ITKE345,295 pointsBadges:
  • Sending IFS attachments via iSeries?

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

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

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