06 RPGLE – Built-in functions
DCL-S str CHAR(20) INZ(‘Hello World’); DCL-S subStr CHAR(5); subStr = %SUBST(str:1:5); // Result is ‘Hello’ Date and Time Functions %DATE: Converts a character, numeric, or timestamp value to a date. rpg DCL-S date DATE; date = %DATE(‘2024-12-23’); // Converts to date value %TIMESTAMP: Converts a character or numeric value to a timestamp. rpg DCL-S timestamp […]
05 – Introduction to RPGLE Programming
RPGLE (RPG IV) stands for Report Program Generator Language Extension, and it is an advanced version of the RPG programming language used primarily on IBM’s AS/400 systems (now known as IBM iSeries or IBM Power Systems). Here’s an introduction to RPGLE programming: History and Evolution RPG II: The original RPG, introduced in the 1960s, was […]
04 – SQL way of creating and maintaining Database objects
Using SQL to create and maintain database objects on AS/400 (now known as IBM iSeries or IBM Power Systems) is efficient and flexible. Here’s a guide on how to create, manipulate, and manage database objects using SQL: 1. Creating Database Objects Creating a Table Use the CREATE TABLE statement to define a new table. sql […]
03 – DDS way of creating and maintaining Database objects
Data Description Specifications (DDS) is a powerful tool for creating and maintaining database objects on the AS/400 (now IBM iSeries or IBM Power Systems). Here’s a step-by-step guide to using DDS: 1. Access PDM (Programming Development Manager) Step: Use the PDM tool to access the source file that contains the DDS specifications. 2. Edit the […]
02 – Application Development Tools
AS/400 (now IBM iSeries or IBM Power Systems) offers a variety of application development tools to help developers create robust and efficient applications. Here are some key tools: 1. Rational Developer for i (RDi) Description: An Eclipse-based integrated development environment (IDE) that provides features like syntax highlighting, debugging, and project management. Usage: Used for developing […]
01 – AS/400 Basics & Terminologies
Basics AS/400: Originally named “Application System/400,” it is a multiuser, multitasking system designed for industries requiring secure data storage and processing. Integrated DB2 Database: Comes with an integrated DB2 database management system. Menu-Driven Interfaces: User-friendly menu-driven interfaces for ease of use. Multi-User Support: Supports multiple users simultaneously. Security: High levels of security for sensitive data. […]
