Coding in RPG (IBM i/AS400). Using SELECT to update data

preview_player
Показать описание
New example video!

This is a very simple and little video, just showing how to use a SELECT sentence in the client access SQL utility, for changing data fields...
It is very useful, and I wanted to share it if you didn't know it ...

Check it, have fun, and comment, please.

#sql #sqlibm #sqlrpg #ilerpg #rpgile #rpg #rpgle #ibm #ibmi #rpgnewfunctions #as400 #ibmcoding #ibmtraining #rpgtraining #newvideo #common #pub400 #visualstudiocode #vscode #clientaccess
  1. Christian Larsen
  2. ibmi
  3. rpg
  4. ilerpg
  5. rpgile
  6. sql
Рекомендации по теме
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 OPTIONS(*CONVERT)

Coding in RPG 0:06:13

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

Coding in RPG 0:09:16

Coding in RPG (IBM i/AS400). How to use Regular Expressions in RPG.

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:07:22

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

Coding in RPG 0:06:10

Coding in RPG (IBM i/AS400). Copying information from a table to another without duplicating data

Coding in RPG 0:07:01

Coding in RPG (IBM i/AS400). Using the 'static' keyword.

Coding in RPG 0:12:07

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

Coding in RPG 0:16:33

Coding in RPG (IBM i/AS400). Using LIMIT and OFFSET.

Coding in RPG 0:14:23

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

Coding in RPG 0:13:22

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

Coding in RPG 0:13:54

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

Coding in RPG 0:09:06

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

Coding in RPG 0:14:36

Coding in RPG (IBM i/AS400). Using %RIGHT and %LEFT

Coding in RPG 0:07:17

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

Coding in RPG 0:10:49

Coding in RPG (IBM i/AS400). Using BLOB SQL fields in RPG to store and retrieve data.

Coding in RPG 0:08:33

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

Coding in RPG 0:05:35

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

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:05:20

Coding in RPG (IBM i/AS400). Creating a simple RPG program with VScode

Coding in RPG 0:02:12

Coding in RPG (IBM i/AS400). Using SELECT to update data

Coding in RPG 0:11:19

Coding in RPG (IBM i/AS400). Using the Merge SQL statement

Комментарии
Автор

hey Christian great video! very clear and useful... question: when debugging, which combination of keys is the equivalent of "F11" from Windows on Mac to "Display Variable"? Thanks in advance!

manuelsanchez