• SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400380 pointsBadges:
  • Explain diiferent data types in AS400

    Hi, Can anyone please explain me different data types in AS400 What is the difference between Packed decimal and zoned decimal. Since in our project we have both .Net and AS400 technolgy. Some times .Net guys usually retrieve data from AS400 system into their tables that time they used to ask me...

    Mohan K695 pointsBadges:
  • Using CLOSE & OPEN commands IN RPG ILE program

    What is the best technique of using CLOSE & OPEN commands for USROPN DB files, if I need use CLOSE more then one time in program?

    Yuriy4425 pointsBadges:
  • 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...

    GHENDER215 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,045 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.?

    GHENDER215 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:
  • 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:
  • 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

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

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

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

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

Thanks! We'll email you when relevant content is added and updated.

Following