AS400 and SQL Tricks
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, Pointers in CL, CL commands, Operations
- SQL, Embedded SQL, SQLRPGLE, SQL performance management, Common Table expression (CTE)
- FTP
- IFS
- SQL UDF (User defined function), External UDF, UDTF (User Defined Table function)
- SQL Stored Procedure, External Stored Procedure
- SQL Trigger, External Trigger
- ACS Tool
- Fixed & /Free & Fully Free RPG
- DDS(PF, LF, DSPF, PRTF)
- Subfile (Load-All, Expandable and Single Page)
- Source/String parsing, SQL source Parsing
- DDS to SQL conversion
- Unicode conversion, DBCS handling, CCSID Codepage concepts
- IBM APIs, Catalog tables in IBM DB2
- RDi, I-Series Navigator
- AS400 Production Support
- AS400 Basic concepts
- Interview Questions and Answers (RPG, CL, SQL, DB2, ILE)
- Web in AS400
- IBM i & Java Integration
- MI functions (Machine Instructions)
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