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)