• Help with embedded SQL in RPG. Dang thing hates the delete statement?

     H OPTION(*NODEBUGIO:*SRCSTMT)                             *******************************************************  FWRLDSHP   IF   E             DISK                       FWRLDSHP1  O  A E           K...

    nitzinger385 pointsBadges:
  • Reorganizing AS/400 Files While Active

    I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must have journaling...

    GHENDER190 pointsBadges:
  • DSPF How to use Moubtn with Pshbtnfld and pshbtnchc

    Hi, I have a DSPF with two format FMT01, FMTCM. In FMT01 I have defined MOUBTN(*ULP CF21) so when I push left button of the mouse on a specific field, *INKV(CF21) is activated and the program RPGILE do a call to a window.In FMTCM that is used as feet of the DSPF I have defined PSHBTNFLD with...

    Marzio35 pointsBadges:
  • AS400 RPG – last three digits of microseconds always zero!

    We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits....

    Koohiisan5,020 pointsBadges:
  • Days of the week in AS/400 V5R4

    I know how to determine the day of the week a date falls on. However, I was wondering if there was an easy way to figure the following information: 02/01/10 was the 5th Monday of year 2010, 01/07/11 is the 1st Friday of 2011, etc.?

    GHENDER190 pointsBadges:
  • AS/400 – RPG ILE – Procedures

    Please provide sample program(s) to illustrate the procedures/subprocedures in RPGLE?

    sudheer794315 pointsBadges:
  • RPG III to RPG IV conversion

    how to convert rpg iii code into rpg iv?

    sahithi643630 pointsBadges:
  • How to create menu using RPG program?

    how to create menu using rpg program

    1307845 pointsBadges:
  • RPG Free Array Processing

    I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr variable. In any...

    ShawnKF5 pointsBadges:
  • RPG Free Array Processing Problem

    If you've seen this question before it's because when I add my code and submit and view it, it is unreadable. I'm trying to get a "clean" representation of my question. Thanks for your patience. I have loaded a data structure from a database file with three 3 byte fields, i.e. 100101102. It loads...

    SKF75 pointsBadges:
  • RPG /Free Local Data Area definitions

    I am trying to define the LDA with an external definition in RPG /free. Any help?

    Rstinsonindy15 pointsBadges:
  • how many programmes are using any perticular database file in as400

    hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

    Ambrish 82310 pointsBadges:
  • Debug batch job

    hi all,     how to debug batch job please give me in details... thnx

    chakramdhar65 pointsBadges:
  • Two subfiles in same screen

    I am working with 2 subfiles in the same screen, both have some options that call others programs. There is a function key F12 - cancel that should be return to the last screen after run these programs. The program is using command UPDATE LSTSFL (subfile name). It is working well for the first...

    BTF5 pointsBadges:
  • Command to track how many spool files users have

    I have certain users who never clean out their spool files. Is there any command I can run which will tell me how many spool files a user has out there? I am currently on version V5R4 of the operating system

    GHENDER190 pointsBadges:
  • Reorganization of V5R4 while active

    We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

    GHENDER190 pointsBadges:
  • How to tell if a specific record comes before or after another specific record?

    In RPG ILE, I have an externally described file. I am chaining out to the logical file with a key & find the first record. Now, I want to know if the second record I'm looking for is before or after the first record in the file.

    Stckrb5 pointsBadges:
  • Embedded SQL in RPGILE

    For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?

    TNKR130 pointsBadges:
  • get an i-Series *LIBL in a .NET program

    I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started...

    ToddN200013,050 pointsBadges:
  • Runtime Session resolution change

    I want to change seesion resolution from 24X80 to 27X132 in runtime through RPG ILE. Please help me on this regard, by giving sample code.

    Bubaimess5 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