Problem solve

RPG iSeries programming

• Enhancing RPG with external SQL stored procedures

  Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Continue Reading

• Introduction to SQLRPGLE on IBM i: Making a report

  Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program. Continue Reading

• Making the most of RPG data handling on IBM i

  By virtue of being bult-in to the AS/400, RPG has speed for some operations that SQL cannot touch. Learn how RPG works with indexing to retrieve data from your IBM i. Continue Reading

• Allow access to data from a stored procedure result set using COBOL or RPG

  For COBOL and RPG programs to process the data after the stored procedure call completes, you need to direct the SQL stored procedure to place the result set in a global temporary table. COBOL and RPG cannot access embedded SQL as of V6R1. Continue Reading

• EGL Rich UI on IBM i: Do you Dojo?

  Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn ... Continue Reading

• Documenting nested program structures on the AS/400

  Documenting nested program structures on AS/400 is a complex task and is sometimes overlooked or not updated. The XPGMSTR command automates documentation in a structured and reliable way, eliminating the human-error (or lazyness) involved in the ...Continue Reading

• Eight steps for creating program documentation using AS/400 utilities

  To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Continue Reading

• Chain operation error after converting RPG3 to ILE RPG (RPGIV)

  RPGIV will 'think of' incoming integer fields as binary, and then will redefine them in the program structures as PACKED. So, when you chain a record, the incoming data has to be converted from integer (which RPGIV thinks is Binary) to packed. This ...Continue Reading

• Dynamic SQL statement in an RPG program

  DB2/400 and DB2 UDB expert Kent Milligan discusses how to substring a character field on an SQL join statement.Continue Reading

• RPG dynamic value calculation versus hard-coded values

  iSeries RPG expert Kevin Ketlzer illustrates dynamic value calculation in this example on programming on the iSeries.Continue Reading

• System i date conversions in RPG

  Date conversion in RPG is something that we do without too much hassle. Years ago, we'd use wacky calculations, which are now deemed harmful to proper processing. The old multiply by 100.0001 is a bad way to go. System i programming expert Andrew ...Continue Reading

• Embracing RPG IV

  RPG IV is much more then just an extension of RPG III. Enhancements in the language provide new ways of doing things, which, in turn, necessitate a change in day-to-day coding practices.Continue Reading

• Java for RPG Programmers, Third Edition -- Chapter 10

  This chapter, "Exceptions," will help you to understand the various roles of Java in today's applications, learn the core Java language, discover how to use the Java Development Kit (JDK) and much more.Continue Reading

• RPG SELEC statements: Improve the performance

  According to systems management expert Ron Turrull, the performance of your RPG programs may be suffering if you use the SELEC statement. Ron says that the SELEC op-code is a great, recently added feature in RPG used to create multi-conditioned, ...Continue Reading

• Free form RPG: Are you /FREE?

  System i (AS/400) programming expert Paul Tuohy attended a recent Common User Discussion Social (CUDS) recently where the conversation centred on free form RPG. Paul shares some of the points discussed, highlighting the highs and lows of using free...Continue Reading

• Qualified data structures: Why you should be using them

  Application development expert Paul Tuohy has been receiving quite a few questions about qualified data structures and whether or not they are of much use. According to Paul, they are and you should be using them.Continue Reading

• iSeries software converts green screen programs to Web

  iSeries software provider Profound Logic has released a new version of RPGsp, which allows developers to take RPG-coded green-screen applications and convert them to HTML for easier viewing in Web browsers.Continue Reading

• The Modern RPG IV Language, Fourth Edition -- Chapter 13

  "Web Programming Interfaces" covers all the new functions and facilities available in V5R4 RPG IVcovers all the new functions and facilities available in V5R4 RPG IV.Continue Reading

• CGI application programming interfaces: Quiz

  Think you know all there is about CGI application programming interfaces? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of "The Modern RPG IV Language, Fourth Edition" ...Continue Reading

• Dynamic memory in V5: Harness the power -- part 1

  Report Program Generator (RPG) programmers have been able to use dynamic memory (or "heap storage" as IBM likes to call it) for a number of years now, but not until V5 hit the streets had it been fully implemented. With RPG's dynamic memory built-in...Continue Reading

• A simpler way to name RPG indicators

  Here's a simpler way to name RPG indicators.Continue Reading

• Make the most of arrays

  In this tip Paul Tuohy examines some of the features of defining and using arrays in RPG IV.Continue Reading

• CGIDEV2: Building native iSeries Web pages

  IBM's CGIDEV2 Web toolkit offers a high quality, low cost alternative that requires a set of skills that closely match those commonly found in most iSeries development shops.Continue Reading

• How to compare spooled files

  Search400.com member Phillip Smith provides his methond to compare spooled filesContinue Reading

• Command to manage longer addresses

  One user wirtes, "I am working with an iSeries application that uses the commands: strpccmd/strpco to redirect the user to a Web page on a local server. I would like the application to redirect to a different Web page but the address is too long ...Continue Reading

• VARPG -- Reprocess changed records

  Scenario: You're validating data in changed records of a subfile, but you need to keep those records in a changed status to be processed by a future readc operation.Continue Reading

• Useful date expressions in V5R3/Free RPG

  These are some useful expressions for working with dates in V5R3/Free RPG. They could be used directly in code, or encapsulated within functions.Continue Reading

• Variable-length fields in RPG IV

  One Search400.com user writes, "Is there a way to utilize variable-length fields in RPG IV? We do not use free form yet." Application development expert John Blenkinsop responds.Continue Reading

• Display attributes made simple

  What do you do when a legacy application you're maintaining is out of indicators and you want to control the display attributes? Steve Croy has the solution -- a very simple service program -- right here. He has created a prototyped procedure that ...Continue Reading

• Making sense of integer representation in RPG code

  There seems to be an increased use of integer data types in RPG code, as well as in D specs to define work fields. However, Steve Croy points out that not everybody understands the nature of integer data types.Continue Reading

• Solving difficult problems with recursion -- Part II

  In Part I of this series, Ron Turull discussed what recursion is and how it works. Now he looks at how to implement it programmatically.Continue Reading

• Free-Format RPG IV -- Chapter 3

  This chapter takes a look at the operations, options and built-in functions now available for database I/O, as well as for workstation I/O and printer output.Continue Reading

• Free-format RPG only half-way free

  Columnist Steve Croy points out that free-format RPG isn't quite as restrictive as fixed-format RPG, but it isn't totally free either. The implementation stops short of making RPG a free-format language in the nature of Java, C or HTML.Continue Reading

• Have you got the time?

  Date and time of day functions are convenient have in a service program. There are times, however, when a timestamp can be more convenientContinue Reading

• How do you read a formatted dump of an SQL RPGLE program?

  Continue Reading

• Run SQL with output to an Excel file

  Follow these samples to learn how to run SQL with output to an Excel file.Continue Reading

• Using HTTP in an RPG app running on iSeries

  Continue Reading

• Step-by-step power compiler

  This utility finds and adds all the needed libraries for your RPG IV program and compiles it.Continue Reading

• Character limit causes problems

  Continue Reading

• Code examples to determine future end of month based on any given date

  Several users submitted code to help IBLearning determine the future end of month based on any given date. Here are three code examples that they sent in.Continue Reading

• Embrace the new; don't fight change

  New programming techniques are not just about style, says columnist Daniel Holden. There are real merits to using them.Continue Reading

• API to select a number at random

  Continue Reading

• Lines of code in an RPG program

  Continue Reading

• Creating files within an RPG source code

  Continue Reading

• Writing a timestamp field from an RPG program

  Continue Reading

• Coding forward, stepping back

  New programming techniques have their advantages, but sometimes older methods better fit the bill.Continue Reading

• Technical documentation: Pictures worth a thousand words

  Andrew Borts takes a look at how you can use screen shots to improve your technical documentation after you modify a program.Continue Reading

• A program to access stored text files

  Continue Reading

• Freeware to edit RPG source code

  Continue Reading

• Find and Replace in a string

  Learn an easier way to insert the parameters in the submit string.Continue Reading

• Accessing iSeries files from within an Oracle application

  Keep your eyes open when accessing iSeries files from within an Oracle application.Continue Reading

• Slow system performance

  Continue Reading

• New option within the WRKSYSACT command

  Continue Reading

• How does RPG talk to a browser?

  Using your existing RPG skills and a little knowledge of HTML, you can be programming for the Web in no time.Continue Reading

• Illustration of multithreading in the iSeries

  Learn how multithreading is a general purpose programming technique that reduces the complexity and overhead of concurrent programming.Continue Reading

• How to generate reports using stored procedures

  Third-party reporting tools aren't always the best option when generating reports from data on several types of databases. External stored procedures can do a better job.Continue Reading

• Restoring Client Access Excel Data Transfer Add-In

  Learn how to restore Client Access Excel Data Transfer Add-In.Continue Reading

• Going from CL's QTEMP to batch QTEMP

  Continue Reading

• What's the difference between the three types of subfiles as in the DDS?

  Continue Reading

• Retrieve a program statement/line number

  Continue Reading

• The ins and outs of using constraints

  Paul Tuohy take a closer look at constraints, what they are and how you define them.Continue Reading

• iSeries calling an .exe

  From a CL, you can call the Windows standard calculator program.Continue Reading

• How to take advantage of DSM -- even in a non-ILE shop

  Ron Turull provides a "helper" program to let you save and restore the screen using two DSM APIs from a non-ILE program.Continue Reading

• Formatted work job scheduler

  Learn more about the formatted job scheduler report using API QWCLSCDE.Continue Reading

• RPG IV program for cover letters

  Continue Reading

• Displaying a window without deleting the underlying display

  Continue Reading

• Capturing the record change

  Continue Reading

• Using API QtmmSendMail in an RPGLE program

  Continue Reading

• Removing a comma from an alpha field

  Continue Reading

• How to save, restore the screen -- the quick and easy way

  This time we turn our attention to a couple of DSM APIs that can be used to take a "snapshot" of the screen, save it and restore it later using the saved data.Continue Reading

• Mixing free format code with embedded SQL

  Here's a neat trick to try when mixing free format code with embedded so you don't have to use the /end-free before each SQL code.Continue Reading

• SQL update a field in one file from a field in another file

  You can easily update a field in one file with SQL by using a field in another file where unique field matching is possible.Continue Reading

• Automate programming tasks

  Learn how to create programming tools that you can use to create sections of code.Continue Reading

• Options for sorting subfiles in RPG

  Continue Reading

• Printing with different fonts and different CPIs

  Continue Reading

• Easy code copying via the drag and drop method

  Learn haow code copying can be a lot easier using the drag and drop method.Continue Reading

• Easy way to compile my RPG programs

  These CL programs help you to compile an RPG III or ILE RPG program by putting the necessary commands into your RPG code.Continue Reading

• RPG documentation made easy

  Using a simple Client Access data transfer you can select which lines from a RPG source send to a *.txt file in order to document it.Continue Reading

• SQL vs. DDS -- The good, the bad and the downright ugly

  What does DDL offer over DDS and vice versa? Let's take a look.Continue Reading

• Copy stored procedures from one library to another

  Continue Reading

• Possible to automatically refresh display?

  Continue Reading

• Sharing access paths before use OPNQRYF command

  Continue Reading

• Easy code copying the EDTF way

  It is possible to copy directly from the integrated file system.Continue Reading

• Copy text to SRCMBR

  If you have a CL program in a text file on your PC, you can send this text to SCRMBR of QCLSRC and have the program ready.Continue Reading

• Quickly copy an RPG or CL source member from one iSeries to another

  Copying an RPG or CL program source from a remote iSeries into the iSeries you are currently on can be achieved using several ways. This tip review one of them.Continue Reading

• Debug value of pointer

  See what the pointer is pointing to when debugging ILE RPG.Continue Reading

• The Lazy Coder talks about highlighting your code

  Can't tell the difference between your comments and your program? It's time to highlight some of it.Continue Reading

• Take control of Query

  Create your own version of the WRKQRY command that allows you to determine how much time should be allotted for interactive queries.Continue Reading

• What or who changed the QAUDCTL value?

  Continue Reading

• CLRPFM and DLTF APIs

  Continue Reading

• Changing a PF with *NOMAX back to maximum record size

  Continue Reading

• Decommissioning the AS/SET case tool

  Continue Reading

• Send and receive data to data queues

  Continue Reading

• Retrieving permissions for all objects in our IFS

  Continue Reading

• Sending an e-mail from a CL program

  Continue Reading

• Working with COBOL Subfile RRN

  Continue Reading

• Changing attributes of an object

  Continue Reading

• Command Attention vs. Command Function keys (CA/CF)

  Continue Reading

• Generic trigger program to capture create/change date and time

  Instead of adding code to several programs to track data record changes, this program can be added to any physical file to track changes from any source.Continue Reading

• Easy code copying ... without CODE400

  Copy any Web source code in an iSeries source file in five steps.Continue Reading