Coding in RPG (IBM i/AS400). Creating and using a VIEW.

preview_player
Показать описание
In this video I'd like to show you how I've improved a code just creating a SQL VIEW and using it from a service program.
I'm using as always, vscode with the "Code for IBM i" extension, Github, deployment function...

Have fun!

#ilerpg #rpgile #embeddedsql #sql #rpgsql #rpg #rpgle #ibm #ibmi #rpgnewfunctions #as400 #ibmcoding #ibmtraining #rpgtraining #rpgandjson #sqljson #json #jsonrpg #jsonquery #newvideo #common #pub400 #restserver #systools
  1. Christian Larsen
  2. ibmi
  3. rpg
  4. ilerpg
  5. rpgile
  6. sql
Рекомендации по теме
Coding in RPG 0:18:49

Coding in RPG (IBM i/AS400). Creating and using a VIEW.

Coding in RPG 0:17:15

Coding in RPG (IBM i/AS400). Converting file operations in RPG to embedded SQL operations in RPG.

Coding in RPG 0:07:22

Coding in RPG (IBM i/AS400). Templates.

Coding in RPG 0:06:13

Coding in RPG (IBM i/AS400). Comparing occurs with other structures

Coding in RPG 0:12:38

Coding in RPG (IBM i/AS400). Using Deploy tool in VS Code/Code for IBM i

Coding in RPG 0:11:28

Coding in RPG (IBM i/AS400). Using SQL to look for object locks.

Coding in RPG 0:03:36

Coding in RPG (IBM i/AS400). Using the option *convert.

Coding in RPG 0:12:37

Coding in RPG (IBM i/AS400). Using SQL to look for jobs information.

IBM i, AS400 0:13:55

IBM i, AS400 Tutorial, iSeries, System i - Introduction to RPG programming for Beginners_ENGLISH

Coding in RPG 0:11:52

Coding in RPG (IBM i/AS400). Subroutines and subprocedures.

Coding in RPG 0:08:33

Coding in RPG (IBM i/AS400). Improving a process with activation groups.

Coding in RPG 0:14:23

Coding in RPG (IBM i/AS400). Using *nopass and *omit parameter options

Coding in RPG 0:14:36

Coding in RPG (IBM i/AS400). Using pointers.

Coding in RPG 0:07:17

Coding in RPG (IBM i/AS400). Using WHEN-IS and WHEN-IN

Coding in RPG 0:13:22

Coding in RPG (IBM i/AS400). Creating a service program.

Coding in RPG 0:12:26

Coding in RPG (IBM i/AS400). Creating IFS files using RPG and SQL

Coding in RPG 0:05:35

Coding in RPG (IBM i/AS400). Recursion in subprocedures.

Coding in RPG 0:13:54

Coding in RPG (IBM i/AS400). Activation Groups.

Coding in RPG 0:12:03

Coding in RPG (IBM i/AS400). Using CREATE FUNCTION and CREATE PROCEDURE

Coding in RPG 0:12:07

Coding in RPG (IBM i/AS400). Using SQL history tables.

Coding in RPG 0:07:47

Coding in RPG (IBM i/AS400). Reading Data Areas using SQL.

Coding in RPG 0:07:07

Coding in RPG (IBM i/AS400). Using ON EXIT.

Coding in RPG 0:09:06

Coding in RPG (IBM i/AS400). RPG & VScode & make, adding a display file

Coding in RPG 0:08:04

Coding in RPG (IBM i/AS400). When to create a SQL index.