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

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

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

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

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

    ITKE345,065 pointsBadges:
  • Base compiler program in SQLRPGLE

    I'm writing a compiler program in SQLRPGLE that will be used in a lot of programs that will run throughout my system. Obviously, I want to get it right so that I don't have a bunch of problems down the road, and right now it doesn't work.  Could you take a look at what I'm trying to do and suggest...

    ITKE345,065 pointsBadges:
  • How to see a timeout in connect/send in AS/400?

    My team and I recently created a socket client in RPG that calls a Java server socket. However, the problem that we're running into is that connect()/sent() operations blocks and we have a requirement that if the connect/send couldn't be done in a matter of a second per say, we have to just log it...

    ITKE345,065 pointsBadges:
  • Soft menu configuration in AS/400

    Hi, I would like to know the approach to configure menu to different user profile based on their authority. For eg:- user A should see only 1-10 menus and User B should see only first 5 menus. Previously this was done with simple display file and message files. Now this has to be changed to a soft...

    RamvishakRamesh2,505 pointsBadges:
  • Easy and faster way to pull data from a server using ODBC (VBA)

    I am looking for couple of options to pull data from AS/400-ODBC connection and manage data in Excel.

    xxsinghxx20 pointsBadges:
  • Other technologies for Mainframer

    I am working as a developer in Mainframe technology since last 2.5 years. I want to learn new twchnology. I have heared that learning java can help me as it's used at font end and mainframe at back end. I also came to know learning hadoop is also good option for mainframer. Can you please recommend...

    Chinmay145 pointsBadges:
  • Manual Impact Analysis

    Hi,I used to work with Hawkeye to perform impact analysis.Is there any way manually, to find out the programs got affected, respective to the changes done.

    HABBIE820 pointsBadges:
  • Can my friend call a remote Java program on iSeries from RPG?

    One of my good friends (who's a programmer) is looking to invoke a Java program from RPG running on iSeries V5R4. His remote program is a web services client, running in WebSphere. He would like to call it direct from RPG...is that possible? Does he have to create a program to run on iSeries and...

    ITKE345,065 pointsBadges:
  • DB2/iSeries clean up

    I'm trying to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k string records but I'm having a ton of trouble with my DB2 environment.After doing some searching, and I thought replacing with the "REPLACE()" and "CHR()" functions could work, but it's not...

    ITKE345,065 pointsBadges:
  • How to link AS/400 with Java?

    I'm trying to figure out how to connect AS/400 to Java. I'm not a very experienced programmer in either system. Could someone provide me with links to very simple explanations on how to do it? Thanks!

    ITKE345,065 pointsBadges:
  • HTML, Excel, AS400

    can we post/store an excel file on the HTML site and link to the AS400 to pull data

    xxsinghxx20 pointsBadges:
  • Verifying user, password and open menu of RPGs

    I currently have a login module in my AS/400 application where the user name and password are verified and only if the password matches the user, they are given access to the Menu screen (with contains RPG programs). I'm trying to find out if it's possible to achieve that when the user is verified,...

    ITKE345,065 pointsBadges:
  • negative sign in physical file copy process

    this is regarding copy file.I have a physical file P1 and physical file P2. Now in P1 i have a zoned decimal field and in P2 i have a packed decimal field. let us assume i have the negative data in P1. after performig the CPYF to copy the P1 to P2, i am getting some junk characters ( '}', 'M', 'S'...

    sivakesava280 pointsBadges:
  • Reading liblist through an ILE program

    Our part of the company controls what objects our programs on our AS/400 work, running them with different liblists. But we know that some operations can't be controlled by this. Our program needs to read the liblist and decide on some of the libraries in it (and how to act).But we couldn't find...

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