19
Sun, May
7 New Articles
  1. You are here:  
  2. Home
  3. Archive
  4. Authors
  5. Rafael Victoria-Pereira

Rafael Victoria-Pereira

 

  Sort By:
  Display:
Published Title Category Hits
04 November 2016 TechTip: C# for RPGers - More on Arrays and a Different FOR Loop General | Programming - Other | Programming 4,864
02 November 2016 RPG Academy: Write Better Code - More Tips for Organizing Your Modules and Service Programs RPG | Programming 4,668
19 October 2016 SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1 SQL | Programming 8,079
05 October 2016 RPG Academy: Write Better Code—Tips for Organizing Your Modules and Service Programs RPG | Programming 4,420
30 September 2016 TechTip: C# for RPGers—Introducing Arrays and the FOR Loop General | Programming - Other | Programming 4,555
21 September 2016 SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date Tricks SQL | Programming 4,425
07 September 2016 RPG Academy: Write Better Code - Naming Conventions for Physical and Logical Files RPG | Programming 4,787
26 August 2016 TechTip: C# for RPGers: Not All Strings Are Born Equal General | Programming - Other | Programming 3,727
17 August 2016 SQL 101: Date-Related Functions, Part 3 - Extracting Information from Dates SQL | Programming 4,033
03 August 2016 RPG Academy: Write Better Code — Choosing Appropriate Names for Variables, Procedures, and Functions RPG | Programming 5,592
29 July 2016 TechTip: C# for RPGers—Learn More About C#’s Methods and Properties General | Programming - Other | Programming 3,120
20 July 2016 SQL 101: Date-Related Functions, Part 2—Time-Saving Functions SQL | Programming 4,089
06 July 2016 RPG Academy: Write Better Code—A Few More Naming Variables Guidelines RPG | Programming 4,172
24 June 2016 SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or Timestamp SQL | Programming 5,704
03 June 2016 TechTip: C# for RPGers: More C# and RPG Basic Data Types Compared General | Programming - Other | Programming 2,897
01 June 2016 RPG Academy: Write Better Code – Naming Variables Guidelines, Part 1 RPG | Programming 4,353
13 May 2016 SQL 101: String-Related Functions, Part 5—Cutting and Stitching Strings SQL | Programming 3,921
04 May 2016 RPG Academy: /FREE Your Code - Convert Fixed-Format Code to Free-Format, Part 3 RPG | Programming 4,271
29 April 2016 TechTip: C# for RPGers – C# and RPG Basic Data Types Compared, Part 1 Scripting | Programming 4,426
20 April 2016 SQL 101: String-Related Functions, Part 4—“Stringscaping” with TRIM and Related Functions SQL | Programming 4,564
06 April 2016 RPG Academy: /FREE Your Code - Converting Fixed-Format Code to Free-Format, Part 2 RPG | Programming 7,359
25 March 2016 TechTip: C# for RPGers – Anatomy of a C# Program General | Programming - Other | Programming 3,733
11 March 2016 SQL 101: String-Related Functions, Part 3 - Pulling Strings Around with REPLACE and INSERT SQL | Programming 4,824
02 March 2016 RPG Academy: /FREE Your Code - Convert Fixed-Format to Free-Format, Part 1 RPG | Programming 8,095
26 February 2016 TechTip: C# for RPGers: Visual Studio's Code-Assistance Tools General | Programming - Other | Programming 4,285
05 February 2016 SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and More SQL | Programming 7,741
03 February 2016 RPG Academy: /FREE Your Code – What the Most-Used Operation Codes Look Like in Free-Format RPG | Programming 4,925
20 January 2016 How Much Do You Really Know About Modern RPG Programming? RPG | Programming 8,577
15 January 2016 TechTip: C# for RPGers: Creating Your First C# Program and a Quick Tour of the IDE General | Programming - Other | Programming 5,011
06 January 2016 RPG Academy: /FREE Your Code - It's /FREE, But It Has Rules RPG | Programming 3,929
11 December 2015 SQL 101: String-Related Functions, Part 1 - Converting Almost Anything to a String SQL | Programming 5,819
09 December 2015 Finally, Data Definitions in RPG Look "Modern"! RPG | Programming 17,627
04 December 2015 TechTip: C# for RPGers - Start Here Scripting | Programming 6,233
02 December 2015 RPG Academy: /FREE Your Code: Free-Format Pros and Cons RPG | Programming 5,378
18 November 2015 Procedures: How, When, and Why to Build Them RPG | Programming 4,859
13 November 2015 SQL 101: Aggregate Functions: Discovering SQL's Hidden Gems SQL | Programming 5,293
04 November 2015 RPG Academy: BIF Up Your Code! Use BIFs to Perform Time Operations RPG | Programming 4,644
23 October 2015 SQL 101: Getting Rid of DFU with the Update and Delete Statements SQL | Programming 6,971
07 October 2015 RPG Academy: BIF Up Your Code! Retrieve the Day of the Week with %DIFF RPG | Programming 9,125
09 September 2015 A C# Primer for RPG Programmers General | Programming - Other | Programming 10,099
02 September 2015 RPG Academy: BIF Up Your Code! Using BIFs to Perform Date Operations RPG | Programming 6,141
28 August 2015 SQL 101: A Simple Way to Add Data to the DB: the Insert Statement SQL | Programming 15,040
05 August 2015 RPG Academy: BIF Up Your Code! Building Excel's PROPER Case Function and Testing Chg_Case RPG | Programming 5,667
10 July 2015 SQL 101: Writing More Complex Queries SQL | Programming 9,089
01 July 2015 RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE RPG | Programming 5,593
17 June 2015 RPG Academy: BIF Up Your Code! Building MS Excel-like LEFT and RIGHT Functions Using BIFs RPG | Programming 5,620
12 June 2015 SQL 101: The Simplicity and Flexibility of the SELECT Statement SQL | Programming 8,257
08 May 2015 SQL 101: SQL vs. RPG: Different Names for the Same Things SQL | Programming 8,875
06 May 2015 RPG Academy: BIF Up Your Code! Part 5, Easily Find and Replace Text in Strings with BIFs RPG | Programming 6,208
01 April 2015 RPG Academy: BIF Up Your Code! Part 4, Simplifying String Operations with BIFs RPG | Programming 5,429
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