Email Alerts
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400. News | 04 Sep 2008
-
Tracking data changes on IBM i with triggers
Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes. Tip
-
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. Tip
-
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. Tip
-
How to use the binder language to manage service programs -- Part 3: Examples and pitfalls
In Part 1, Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In Part 2, he discussed the very simple binder language and how you use it to create service program signatures. In ... Tip
-
How to use the binder language to manage service programs -- Part 2: Understanding the binder langua
In his previous tip Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In this installment, he discusses the simple binder language and how you use it to create service program s... Tip
-
How to use the binder language to manage service programs -- Part 1: Service program signatures
Learning to use the ILE binder language is essential to managing all but the simplest service programs on your iSeries. Before you can do that, however, you should understand the role of service program signatures. Ron Turull explains how you can use... Tip
-
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 ma... Tip
-
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. Tip
-
Solving difficult problems with recursion -- Part I
Recursion is one of the most powerful problem-solving techniques in computer science, and learning to use it will give you a decided edge in boosting your programming skills. Tip
-
Optimize your programs to increase performance
If you're not using program optimization, now is the time for administrators to consider it, especially if your system is getting sluggish. Tip
- See more Tips on iSeries ILE programming
-
Searching fields for values
In AS/400, if you need to find database fields that contain a specific value, in ILE RBG the field to use is D1FIND. The trick is that you have to add code to turn all search terms into uppercase, or the program won't recognize the search term if it'... Ask the Expert
-
Searching part of a name or address in AS/400
In ILE RPG code can be written to conduct the search on part of a name or address using the field D#SFLN. Ask the Expert
-
Passing parameters in an ILE RPG module
iSeries application development expert John Blenkinsop explains about passing parameters in an ILE RPG module. Ask the Expert
-
Slow system performance
Ask the Expert
-
New option within the WRKSYSACT command
Ask the Expert
-
Retrieve a program statement/line number
Ask the Expert
-
Going from CL's QTEMP to batch QTEMP
Ask the Expert
-
Using API QtmmSendMail in an RPGLE program
Ask the Expert
-
ILE COBOL error when dividing by zero
Ask the Expert
-
SQL external UDFs
Ask the Expert
- See more Expert Advice on iSeries ILE programming
-
Tracking data changes on IBM i with triggers
Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes. Tip
-
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. Tip
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400. News
-
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. Tip
-
Searching fields for values
In AS/400, if you need to find database fields that contain a specific value, in ILE RBG the field to use is D1FIND. The trick is that you have to add code to turn all search terms into uppercase, or the program won't recognize the search term if it'... Ask the Expert
-
Searching part of a name or address in AS/400
In ILE RPG code can be written to conduct the search on part of a name or address using the field D#SFLN. Ask the Expert
-
Passing parameters in an ILE RPG module
iSeries application development expert John Blenkinsop explains about passing parameters in an ILE RPG module. Ask the Expert
-
How to use the binder language to manage service programs -- Part 3: Examples and pitfalls
In Part 1, Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In Part 2, he discussed the very simple binder language and how you use it to create service program signatures. In ... Tip
-
How to use the binder language to manage service programs -- Part 2: Understanding the binder langua
In his previous tip Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In this installment, he discusses the simple binder language and how you use it to create service program s... Tip
-
How to use the binder language to manage service programs -- Part 1: Service program signatures
Learning to use the ILE binder language is essential to managing all but the simplest service programs on your iSeries. Before you can do that, however, you should understand the role of service program signatures. Ron Turull explains how you can use... Tip
- See more All on iSeries ILE programming
About iSeries ILE programming
Programming your iSeries using ILE (integrated language environment) news and advice, including iSeries programming tips and ILE commands.