ILE RPGLE
I HAVE EXTERNALY DISCRIBE PRINTER FILE. I WANT TO WRITE 30 RECORDS IN ONE PAGE. I USED OFLIND KEY WORLD BUT PAGE BREAK NOT WORK. TWO HEADINGS ARE WRITE IN ONE PAGE PLEASE GIVE ANY ANSWER   BEST REGARDS, NADEE.

Answer Question   |  May 19, 2010  9:54 AM
ILE RPG, RPG ILE, RPG Records, RPGLE

EMP
How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file [...]

Answer Question   |  February 1, 2010  10:33 AM
CL, RPG, RPGLE

rtncsrloc in RPGLE
i am not able to use rtncsrloc keyword. should i define it in f spec or d spec and how we have to give the 3 argumnts to it… could you just give 1 example explaining all the steps.

Answer Question   |  February 1, 2010  7:54 AM
AS/400, RPGLE, rtncsrloc

converting num to character name in RPGLE
i have to convert any number inputted by the user into its character name…. like if i type 567.. it should be converted to five hundred and sixty seven… i am having problems relating it…

Answer Question   |  February 1, 2010  4:49 AM
AS/400, RPGLE

Does QCMD write to job log when called from RPG
If I have an RPGLE program that executes a CL command using a CALLP to to QCMD, will that CL command be written to the job log.  The LOGCLPGM paramaeter is set to *YES, if that matters.

Answer Question   |  April 30, 2010  2:14 PM
AS/400, RPGLE

OVRPRTF not chaning OUTQ
I have a program where the OVRPRTF command does not seem to be taking affect.  The output is going to the job’s default outq and not the overridden outq.  The following are consecutive lines from the job log:

Answer Question   |  January 21, 2010  2:12 PM
AS/400, CLLE, RPGLE

On the as/400 i series can one use SQL querys to update file
Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the [...]

Answer Question   |  January 20, 2010  9:55 PM
AS/400, RPGLE, SQL, SQL queries

RPGLE external stored procedure when called with OUT parameter having issues when called from C#
We have created some stored external procedure with paramter type OUT but these were giving memory protection at C# side.However when we call it from operation navigator ,it is running succesfully.I created some SQL stored procedure with OUT paramteres and these were working correctly when invoked from C#.What can be the issue with external Stored [...]

Answer Question   |  January 13, 2010  9:02 AM
RPGLE, RPGLE Stored Procedures, Stored Procedures

Unexpected results in data
I work with a TP software product that allows me to pass data back and forth from within that software using my custom program (RPGLE).  I have my custom RPGLE program that reads files in a main software I work with.  My RPGLE program sort of works like an API but it does not set on [...]

Answer Question   |  January 25, 2010  4:34 PM
RPGLE, unexpected data

AS400 – displaying window in *DS3 screen size over SFL in *DS4 screen size
I want to be able to display a window with a 24×80 screen size, without removing the background SFL which is displayed with a 27×132 screen size. Haven’t been able to do it. I have tried 2 different formats in one display file, using 2 line and position definitions per field (one for DS3 and one for DS4) and [...]

Answer Question   |  December 30, 2009  12:27 PM
AS/400 Display File, DS3, DS4, RPG/400, RPGLE

Using the command RCVMSG
There are numerous reports which automatically print throughout the day. Often there may be a message waiting on the printer and because no one was expecting any reports, no one discovers the problem until hours later. (By this time there may be quite a few reports waiting to print) I was trying to use the command rcvmsg (msgq qsysopr). [...]

Answer Question   |  May 25, 2010  2:23 PM
CL, CLP, CLPROGRAM, RCVMSG, RPG, RPG ILE, RPGLE, V5R4

embedded sql update
I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ(‘KY’)    D NEWWH           S              2    INZ(‘AR’)                                                        * Get all [...]

Answer Question   |  December 15, 2009  2:55 PM
Embedded SQL, RPGLE, SQL

Where is the source file of an ILE program?
Hi,  I need to find out the name of the source file of a ILE program. I am getting a blank using DSPOBJD. I know it can be rtrieved using dsppgm but I need to run the process in a program and strore the output in a file.  Pls help… !! This is kinda urgent…  [...]

Answer Question   |  December 11, 2009  8:00 AM
RPG, RPG ILE, RPG IV, RPGLE

API to send email messages from RPGLE
I need to send an email message to a couple of mail ids  with CC mail id also. Is there any API (which is not in java) which will enable me to send the mail ?

Answer Question   |  December 17, 2009  6:38 AM
API, RPGLE, RPGLE Program, V5R4

rpgle programming
when i call my rpg program the display screen is not exiting though i have added CF03 function in the DDS of the display file,or is something wrong with my program and here is the rpgle code to get the date for a particular id.. ******************************************************** FDSPF  CF E                   WORKSTN FDTLF   IF E                   DISK C                EXFMT          [...]

Answer Question   |  December 11, 2009  3:17 PM
RPGLE, RPGLE Program

RPGLE Program help
I have a scenario .. I have program   FColstatlf IF   E           k Disk                              FColstatkk O    E             Disk                              F                                                               C                   Read      colstatlf                         C                   Eval      *inlr = *on                       C                   Dow       Not (%Eof(Colstatlf))             C                   Eval      Tablcod = Tablcode                C                   write     rstatre                           C                   Read      Colstatlf                         C                                                               C                   Enddo                                       C                                                               C                   Eval      *inlr = *on                         In the above [...]

Answer Question   |  December 3, 2009  1:00 PM
RPGLE, RPGLE Program

RPGLE
When does a file defined in RPGLE program gets opened??

Answer Question   |  December 3, 2009  12:55 PM
RPGLE

RPGLE Convert negative number into decimal
Input field (CHGAMT) is defined as 17S 2 but has a negative value     (-14.00)  viewed as ’0000000000000140}’ I have to first move this value into a character field and get it into a decimal format again (17S 2) so I can use the value to compare to another field defined the same way.  Ultimately, I will need [...]

Answer Question   |  December 1, 2009  10:42 PM
RPGLE, RPGLE negative zoned decimal

Field exit keyword is not working
Hi,      i am trying to use the keyword CHECK(FE) in display file field. But it is not happening. Below is the way how the field is declared:           CAMT  R        B  8 14REFFLD(CAMTW) 64                                  DSPATR(RI)    64                                  DSPATR(PC)                                        OVRATR                                            EDTCDE(J)                                         [strong]CHECK(FE)[/strong]    

Answer Question   |  November 24, 2009  7:53 AM
Display File, DSPF, RPGLE

AS/400 display file
How to decide the position of Display file’s constant variable dynamically. I wanted to decide the position in RPGLE program.

Answer Question   |  November 21, 2009  1:41 PM
AS/400 Display File, RPGLE