Rafael Victoria-Pereira

 

  Sort By:
  Display:
Published Title Category Hits
15 May 2020 SQL 101: A Data Definition Language Hands-on Tour, Part 1 SQL | Programming 5,686
06 May 2020 RPG Academy: Database Modernization - Methodology, Part 8 RPG | Programming 4,717
10 April 2020 SQL 101: Using ILE RPG Functions as SQL UDFs SQL | Programming 8,893
01 April 2020 RPG Academy: Database Modernization - Methodology, Part 7 RPG | Programming 7,888
13 March 2020 SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 2 SQL | Programming 10,249
04 March 2020 RPG Academy: Database Modernization - Methodology, Part 6 RPG | Programming 7,812
14 February 2020 SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 1 SQL | Programming 6,125
05 February 2020 RPG Academy: Database Modernization—Methodology, Part 5 RPG | Programming 7,084
17 January 2020 SQL 101: Flipping It—Using RPG Code in SQL SQL | Programming 6,613
08 January 2020 RPG Academy: Database Modernization—Methodology, Part 4 RPG | Programming 5,052
13 December 2019 SQL 101: Embedding Other SQL Statements in Your RPG Code SQL | Programming 10,296
04 December 2019 RPG Academy: Database Modernization - Methodology, Part 3 RPG | Programming 5,977
06 November 2019 RPG Academy: Database Modernization—Methodology, Part 2 RPG | Programming 5,678
11 October 2019 SQL 101: Ultra-Flexible Cursors—The Beauty of PREPARE SQL | Programming 6,745
04 September 2019 RPG Academy: Database Modernization - Methodology, Part 1 RPG | Programming 6,324
16 August 2019 SQL 101: Killing Open Query File Operations with SQL Cursors SQL | Programming 7,348
07 August 2019 RPG Academy: Database Modernization - Tools to Help the Modernization Process Programming - Other | Programming 4,828
12 July 2019 SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 2 SQL | Programming 9,327
03 July 2019 RPG Academy - Database Modernization: Entity Relationship Diagrams General | IT Infrastructure - Other | IT Infrastructure 11,009
14 June 2019 SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 1 SQL | Programming 7,453
05 June 2019 RPG Academy - Database Modernization: A Bit of Database Theory General | IT Infrastructure - Other | IT Infrastructure 8,691
01 May 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 3 RPG | Programming 5,745
01 May 2019 A #GSORT User's Primer to Open Query File Business Intelligence | Analytics & Cognitive 13,404
12 April 2019 SQL 101: Your First Embedded SQL Function SQL | Programming 6,986
03 April 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 2 RPG | Programming 5,954
15 March 2019 SQL 101: Embedding SQL in RPG Code, Part 2 SQL | Programming 7,192
06 March 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 1 RPG | Programming 5,749
06 February 2019 RPG Academy – Modernization: Setting Your Modernization Goals RPG | Programming 5,222
18 January 2019 SQL 101: Embedding SQL in Your RPG Code, Part 1 SQL | Programming 7,883
09 January 2019 RPG Academy - Modernization: Tips to Avoid the Pains of Modernization RPG | Programming 5,616
05 December 2018 RPG Academy - Modernization: Let’s Talk About the Benefits RPG | Programming 5,618
07 November 2018 RPG Academy—Modernization: Is Your Application Worth Modernizing? RPG | Programming 5,073
18 September 2018 3 Steps to Better Application Modernization RPG | Programming 5,795
14 September 2018 SQL MERGE Statement Tricks DB2 | Analytics & Cognitive 36,156
05 September 2018 RPG Academy – Modernization: Is Restructuring the Database the Way to Go? DB2 | Analytics & Cognitive 7,699
05 September 2018 Embedding SQL in Your IBM i RPG Code SQL | Programming 35,246
01 August 2018 RPG Academy – Modernization: Why, What, Where, and How RPG | Programming 6,701
11 July 2018 RPG Academy: Debug Done Right – Debugging Batch Jobs RPG | Programming 9,287
15 June 2018 Improve Your Database with Normalization DB2 | Analytics & Cognitive 7,987
16 May 2018 A Small Intro to Big Data, Part 4: Are Machine Learning and Artificial Intelligence the Same Thing? Business Intelligence | Analytics & Cognitive 8,098
02 May 2018 RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 2 RPG | Programming 7,165
07 March 2018 RPG Academy: Debug Done Right - You Can Debug Anything! RPG | Programming 11,602
07 February 2018 Make Your IBM i Database More User-Friendly SQL | Programming 10,158
03 January 2018 RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 1 RPG | Programming 8,001
01 November 2017 RPG Academy: Debug Done Right - Working with Watch Conditions RPG | Programming 11,932
31 October 2017 A Small Intro to Big Data, Part 3: HFDS and the MapReduce Algorithm Business Intelligence | Analytics & Cognitive 7,146
06 September 2017 RPG Academy: Debug Done Right - Working with Breakpoints RPG | Programming 14,894
31 August 2017 A Small Intro to Big Data, Part 2: Introducing the Hadoop Framework Business Intelligence | Analytics & Cognitive 9,117
20 July 2017 Book Review: 21st Century RPG: /Free, ILE, and MVC RPG | Programming 31,715
04 July 2017 RPG Academy: Debug Done Right - Starting a Debug Session RPG | Programming 9,971
Rafael Victoria-Pereira

Rafael Victória-Pereira has more than 20 years of IBM i experience as a programmer, analyst, and manager. Over that period, he has been an active voice in the IBM i community, encouraging and helping programmers transition to ILE and free-format RPG. Rafael has written more than 100 technical articles about topics ranging from interfaces (the topic for his first book, Flexible Input, Dazzling Output with IBM i) to modern RPG and SQL in his popular RPG Academy and SQL 101 series on mcpressonline.com and in his books Evolve Your RPG Coding and SQL for IBM i: A Database Modernization Guide. Rafael writes in an easy-to-read, practical style that is highly popular with his audience of IBM technology professionals.

Rafael is the Deputy IT Director - Infrastructures and Services at the Luis Simões Group in Portugal. His areas of expertise include programming in the IBM i native languages (RPG, CL, and DB2 SQL) and in "modern" programming languages, such as Java, C#, and Python, as well as project management and consultancy.


MC Press books written by Rafael Victória-Pereira available now on the MC Press Bookstore.

Evolve Your RPG Coding: Move from OPM to ILE...and Beyond Evolve Your RPG Coding: Move from OPM to ILE...and Beyond
Transition to modern RPG programming with this step-by-step guide through ILE and free-format RPG, SQL, and modernization techniques.
List Price $79.95

Now On Sale

Flexible Input, Dazzling Output with IBM i Flexible Input, Dazzling Output with IBM i
Uncover easier, more flexible ways to get data into your system, plus some methods for exporting and presenting the vital business data it contains.
List Price $79.95

Now On Sale

SQL for IBM i: A Database Modernization Guide SQL for IBM i: A Database Modernization Guide
Learn how to use SQL’s capabilities to modernize and enhance your IBM i database.
List Price $79.95

Now On Sale

LATEST COMMENTS

Buyer's Guide Search

Popular Products

Nexus Portal
44,601
IPCharge
39,320
IPCharge
39,320
Barcode400
38,013
WebSmart ILE and PHP
37,589
Presto
37,227
Catapult
36,129
Catapult
36,129
EDI Software - EZConnect iSeries EDI/XML Software Solutions
25,965
EDI Software - EZConnect iSeries EDI/XML Software Solutions
25,965