WRKQRY tutorial for beginners AS400 and SQL Tricks

​#ibmi #as400 #wrkqryIn this video, i have shown the practical examples to build your own query using WRKQRY utility,Example to create qry definition to select record from single file,example to create qry definition to join two tables,create database files using wrkqry,create *QRYDFN using wrkqry,RTVQMQRY command to retrieve SQL source of out of the *QRYDFN objectSpecify file selections, Define result fields , Select and sequence fields , Select records , Select sort fields , Select collating sequence , Specify report column formatting, Select report summary functions ,Define report breaks ,Select output type and output form,Specify processing options Read More 

Verified by MonsterInsights