AS400 and SQL Tricks

6.33K subscribers

806 videos

AS400 and SQL Tricks is the YouTube channel aims to provide the coding and conceptual videos on programming such as: - RPG, ILE in RPG, Pointers in RPG - CL,...

Latest Videos

How to retrieve source member type in AS400

How to retrieve object text in AS400

How to find string in source members in AS400

How to copy Spool file in AS400

How to clear program message queue in AS400

How to change object description in AS400

How to retrieve source member change date in AS400

creating outfile in as400

open query file(OPNQRYF) - Join Files using opnqryf command

open query file(OPNQRYF) - Final Total only processing without specifying group by fields

open query file(OPNQRYF) - Group by and aggregate functions

open query file(OPNQRYF) - specify a record format for the query records using OPNQRYF

open query file(OPNQRYF) - unique-key processing using OPNQRYF

open query file(OPNQRYF) - specify dynamic keyed sequence access path

open query file(OPNQRYF) - using sort sequence and language identifier

open query file (OPNQRYF) - how to map field using opnqryf MAPFLD parameter in OPNQRYF command

Open Query File (OPNQRYF) - using wildcard function on selection

Open Query File (OPNQRYF) - specify multiple field on selection

Open Query File (OPNQRYF)- Using Contains (%CT) function on selection

Open Query File (OPNQRYF)- Using %Range function on selection

Open Query File (OPNQRYF) - compare CL variable on selection

Open Query File (OPNQRYF)- Using CPYFRMQRYF and RUNQRY

Open Query File (OPNQRYF)- Using GT operator on selection

Using Open Query File (OPNQRYF)

CPF0000 vs CPF9999

MONMSG

WRKQRY tutorial for beginners

GET FTP command

CD directory name FTP command

LCD directory name FTP command in AS400