Subtracting Date/Time AS400 V5R4
I am familiar with the subdur command. I have used it to get the # of days between 2 dates and the number of minutes between 2 times. How do I get the difference in minutes when the times fall on separate days. I guess I need to know how to calculate the interval between [...]

Answer Question   |  September 8, 2010  12:37 PM
RPG, RPG Date Formatting, RPGLE, V5R4

AS/400 unit testing
  Hi,   Im doing one application with coding of RPG and CL.Im new in this tech.I want to clarify one thig.Please cany any body tell me?   When can i start unit testing and when can i end the unit testing?Pleae give me example please?   What is mean by documentation?How can i write [...]

Answer Question   |  July 29, 2010  4:59 AM
AS/400, CL Commands, RPG, RPG Code

How To get The Cursor position on particular field?
My display File Contains three Fields as like name= ……..  Roll =……..  Marks=…….  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To cursor On Mark [...]

Answer Question   |  July 28, 2010  10:28 AM
AS/400, Cursor operation, DSPF, RPG, RPGLE

RPG communicate with USB device?
Can an RPG program running in a 5250 session on a pc communicate with a USB device on that pc? I’ve used sockets to communicate with devices on the network, but never with a device without an IP address. thanks, rick metzger

Answer Question   |  July 20, 2010  1:42 PM
AS/400, Client Access Express, i5/OS, RPG, RPGLE, USB

How to make password characters invisible in AS400?
I am designing a login screen in AS400 box. How do I make the characters invisible while entering the password? Need Help!!

Answer Question   |  July 2, 2010  11:09 AM
AS/400, AS/400 development, DSPF, RPG, RPG ILE

RPG with Embedded SQL needs journaling
When I try updating data in a PF via embedded SQL I get a message saying I need to turn journaling on..   *  change dates on a set of records   C/EXEC SQL                             C+ UPDATE ACC02602P                    C+   SET   CSSTR8 = :$NEWSTR,          C+         CSEND8 = :$NEWEND           C+   WHERE CSSTR8 = :$CSSTR8  AND      C+         CSEND8 = :$CSEND8  [...]

Answer Question   |  October 15, 2010  8:39 PM
AS/400, Embedded SQL, iseries v5r4, RPG

Any Python use?
I know of a port to iSeries from way back. Wondering if there much use? I find that for some tasks, it can be more expressive than RPG. Especially useful if you have an ORM to help with table / SQL generation. Or if you want object orientation.

Answer Question   |  October 10, 2010  8:15 AM
AS/400, Python, RPG, SQL

How Do I Prevent RPG Low-Order Truncation When Storing Data In A File??
I am calculating GPA to print on a report and store in a secondary file via RPG on an AS400.  When I print the GPA on the report, there is no low-order truncation; however, when I store this same field in my secondary file, low-order truncation occurs.  How do I prevent this?? Code as follows: [...]

Answer Question   |  May 19, 2010  3:24 PM
AS/400, RPG, RPG Truncation

Unable to use delete statement How can I delete multiple duplicates in a PF leaving only one in SQLRPG
Background… I use OCL and SQLRPG. I am having an issue after I have built a file of records from my Select. This file contains duplicates that I need to remove. I have a EXEC SQL DELETE clause in the RPG after my “DO” loop ends. The command does nothing, however, when I drop the command [...]

Answer Question   |  May 6, 2010  2:06 PM
AS/400 SQL, RPG, RPGLE

record lock handling in ILE RPG
Hi all, I’ve some questions regardings… whwn a pf is used in Updated mode in RPG 1. what could be conditions when records would be in lock 2. how can we avoid record lock Thanks

Answer Question   |  April 22, 2010  12:44 PM
AS/400, RPG, RPGLE

PDF password protected
How to password protect a PDF file from a non-authorized user when viewed or downloaded from the internet. The content of this PDF file are list of customers and its billing information. These information were extracted from AS400 then downloaded to the pResdesigner software/application to create and design a billing statement and convert it into [...]

Answer Question   |  April 30, 2010  4:30 AM
AS/400, PDF, RPG, Web

debugging a program object on i-series
Hi anybody tell me if it is possible to debug a program object CLP/CLLE/RPG/RPGLE if i dont have the source with me.

Answer Question   |  April 16, 2010  12:30 PM
AS/400 debugging, iSeries, RPG, RPGLE

how to change AS/400 Textbase application to windowslike application
Hey, who can give me advice, or has experince, to change an textbase AS/400 RPG & DDS application to an windowslike application?

Answer Question   |  May 19, 2010  1:46 PM
Applications development, AS/400, DDS, RPG

how to control subfile end
my subfile size is 500, SFLPAG is 10. but actual record to display is only 30. How to ignore *More and display Bottom after reach 30th record. Currently it display *More in empty pages

Answer Question   |  April 5, 2010  7:20 AM
RPG, SFLEND, SFLSIZ

leading zeros on numeric
In RPG how can I have a numeric field that keeps leading zeros?

Answer Question   |  April 2, 2010  12:58 PM
leading Zero, Numeric, RPG

Underline extends beyond text when printing from AS/400
I defined a 24-character field in DDS using fgid 4919 (goudy) with the underline keyword.  When I print the field from my RPG program the underline extends beyond the characters contained in the field.  The length of the underline varies depending on the number and width of the characters in the field.   How can [...]

Answer Question   |  April 2, 2010  7:51 PM
AS/400, DDS Character Input, iSeries printer output, RPG

how to add a number of blank-spaces in free-format RPG
My requirement is: I need to concatenate different fields having different values into the flat-string(blank initially), separated by a number of blanks(spaces), which may vary from field to field. for e.g. MyStr = ‘FIRST_NAME LAST_NAME 20060101 STREET1 CITY11 STATE111 … ‘ and so on where MyStr = Flat String, FIRST_NAME, LAST_NAME, 20060101 etc., are my [...]

Answer Question   |  April 1, 2010  4:09 PM
AS400 ile, RPG

XML-INTO – No data retrieved
Hi, I am trying to read the contents of an XML file that resides on the IFS in folder XMLTEST. My program runs without error but does not retrieve any data. If I remove the AllowExtra and AllowMissing keywords I get error RNQ0353 XML document does not match RPG variable, reason code 5. Any ideas would be [...]

Answer Question   |  March 25, 2010  8:56 AM
RPG, XML, XML Parser Messages

AS400 CL, RPG TUTORIALS
Hi Can anyone sugguest a good website that provides free turtorials on CL & RPG. Mabey with PDF downloads. Thanks  

Answer Question   |  March 23, 2010  4:38 PM
AS/400, CL, RPG

Caloin Webservice From RPGLE
I need to call a webservice from RPGLE.. I know all the examples out there. Anyone actually do it yet? If so did you have any problems with getting out from the 400?  Code examples would be good or a quick reference on what steps were done would be awesome.  Thanks  

Answer Question   |  July 16, 2010  7:57 PM
RPG, WebServices