AS400 and SQL Tricks

@UCBtye8Y8UMmZFXCum_SDZTA - 6.3K subscribers

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)

Home Videos Live Playlists

How to retrieve source member type in AS400?

How to retrieve source member type in AS400? AS400 and SQL Tricks

495 views - 1 year ago

How to retrieve object text in AS400?

How to retrieve object text in AS400? AS400 and SQL Tricks

265 views - 1 year ago

How to find string in source members in AS400?

How to find string in source members in AS400? AS400 and SQL Tricks

425 views - 1 year ago

How to copy Spool file in AS400?

How to copy Spool file in AS400? AS400 and SQL Tricks

463 views - 1 year ago

How to clear program message queue in AS400?

How to clear program message queue in AS400? AS400 and SQL Tricks

267 views - 1 year ago

How to change object description in AS400?

How to change object description in AS400? AS400 and SQL Tricks

145 views - 1 year ago

How to retrieve source member change date in AS400?

How to retrieve source member change date in AS400? AS400 and SQL Tricks

183 views - 1 year ago

creating outfile in as400

creating outfile in as400 AS400 and SQL Tricks

565 views - 1 year ago

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

open query file(OPNQRYF) - Join Files using opnqryf command AS400 and SQL Tricks

559 views - 1 year ago

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

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

150 views - 1 year ago

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

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

171 views - 1 year ago

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

open query file(OPNQRYF) - specify a record format for the query records using OPNQRYF AS400 and SQL Tricks

160 views - 1 year ago

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

open query file(OPNQRYF) - unique-key processing using OPNQRYF AS400 and SQL Tricks

134 views - 1 year ago

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

open query file(OPNQRYF) - specify dynamic keyed sequence access path AS400 and SQL Tricks

155 views - 1 year ago

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

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

246 views - 1 year ago

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

open query file (OPNQRYF) - how to map field using opnqryf || MAPFLD parameter in OPNQRYF command AS400 and SQL Tricks

193 views - 1 year ago

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

Open Query File (OPNQRYF) - using wildcard function on selection AS400 and SQL Tricks

142 views - 1 year ago

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

Open Query File (OPNQRYF) - specify multiple field on selection AS400 and SQL Tricks

117 views - 1 year ago

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

Open Query File (OPNQRYF)- Using Contains (%CT) function on selection AS400 and SQL Tricks

65 views - 1 year ago

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

Open Query File (OPNQRYF)- Using %Range function on selection AS400 and SQL Tricks

60 views - 1 year ago

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

Open Query File (OPNQRYF) - compare CL variable on selection AS400 and SQL Tricks

138 views - 1 year ago

Open Query File (OPNQRYF)- Using CPYFRMQRYF and RUNQRY

Open Query File (OPNQRYF)- Using CPYFRMQRYF and RUNQRY AS400 and SQL Tricks

221 views - 1 year ago

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

Open Query File (OPNQRYF)- Using *GT operator on selection AS400 and SQL Tricks

75 views - 1 year ago

Using Open Query File (OPNQRYF)

Using Open Query File (OPNQRYF) AS400 and SQL Tricks

541 views - 1 year ago

CPF0000 vs CPF9999

CPF0000 vs CPF9999 AS400 and SQL Tricks

872 views - 1 year ago

MONMSG AS400 and SQL Tricks

343 views - 1 year ago

WRKQRY tutorial for beginners

WRKQRY tutorial for beginners AS400 and SQL Tricks

1.6K views - 1 year ago

GET FTP command

GET FTP command AS400 and SQL Tricks

182 views - 1 year ago

CD directory name FTP command

CD directory name FTP command AS400 and SQL Tricks

122 views - 1 year ago

LCD directory name FTP command in AS400

LCD directory name FTP command in AS400 AS400 and SQL Tricks

259 views - 1 year ago

Using SQL to retrieve the Job library list

Using SQL to retrieve the Job library list AS400 and SQL Tricks

284 views - 1 year ago

Initialize SQL columns during SQL INSERT

Initialize SQL columns during SQL INSERT AS400 and SQL Tricks

137 views - 1 year ago

Using SQL to retrieve system values

Using SQL to retrieve system values AS400 and SQL Tricks

186 views - 1 year ago

Using SQL to search History log

Using SQL to search History log AS400 and SQL Tricks

196 views - 1 year ago

Using SQL to convert date to words

Using SQL to convert date to words AS400 and SQL Tricks

134 views - 1 year ago

Using SQL to get information about user profile AS400 and SQL Tricks

240 views - 1 year ago

Using SQL to get Job log message in IBM i

Using SQL to get Job log message in IBM i AS400 and SQL Tricks

291 views - 1 year ago

Using QSHELL to execute SQL commands || Run SQL statements in QSHELL

Using QSHELL to execute SQL commands || Run SQL statements in QSHELL AS400 and SQL Tricks

304 views - 1 year ago

Using SQL to perform mixed case search in Table in IBM i || SRTSEQ(*LANGIDSHR)

Using SQL to perform mixed case search in Table in IBM i || SRTSEQ(*LANGIDSHR) AS400 and SQL Tricks

175 views - 1 year ago

Using SQL to delete spool files in IBM i

Using SQL to delete spool files in IBM i AS400 and SQL Tricks

411 views - 1 year ago

Generate QR code in spool file and converting a spool file with QR code to PDF in IBM i

Generate QR code in spool file and converting a spool file with QR code to PDF in IBM i AS400 and SQL Tricks

1.7K views - 1 year ago

Generate barcode in spool file and converting a spool file with bar code to PDF in IBM i (AS400)

Generate barcode in spool file and converting a spool file with bar code to PDF in IBM i (AS400) AS400 and SQL Tricks

485 views - 1 year ago

What are the steps to copy multiple spool files into single pdf in IBM i

What are the steps to copy multiple spool files into single pdf in IBM i AS400 and SQL Tricks

291 views - 1 year ago

Using SQL to get Output Queue entries information || OUTPUT_QUEUE_ENTRIES view and table function

Using SQL to get Output Queue entries information || OUTPUT_QUEUE_ENTRIES view and table function AS400 and SQL Tricks

157 views - 1 year ago

Using SQL to create pdf || GENERATE_PDF

Using SQL to create pdf || GENERATE_PDF AS400 and SQL Tricks

393 views - 1 year ago

Using CPYSPLF to create pdf

Using CPYSPLF to create pdf AS400 and SQL Tricks

384 views - 1 year ago

Print Queries Using QPQUPRFIL default Printer file for Run queries || Create PDF from spool file

Print Queries Using QPQUPRFIL default Printer file for Run queries || Create PDF from spool file AS400 and SQL Tricks

134 views - 1 year ago

How to check if PTF present and applied on IBM i

How to check if PTF present and applied on IBM i AS400 and SQL Tricks

663 views - 1 year ago

Unzip file in ifs using IBM api QZipUnZip in RPGLE program

Unzip file in ifs using IBM api QZipUnZip in RPGLE program AS400 and SQL Tricks

91 views - 1 year ago

creating zip file in ifs using IBM api QZipZip in RPGLE program

creating zip file in ifs using IBM api QZipZip in RPGLE program AS400 and SQL Tricks

102 views - 1 year ago

Using CPYFRMARCF to Unzip file in IFS

Using CPYFRMARCF to Unzip file in IFS AS400 and SQL Tricks

126 views - 1 year ago

Using CPYTOARCF to create Zip file in IFS

Using CPYTOARCF to create Zip file in IFS AS400 and SQL Tricks

220 views - 1 year ago

UnZip the zip file in ifs using QSHELL Jar command and copy the .csv file back to dds pf

UnZip the zip file in ifs using QSHELL Jar command and copy the .csv file back to dds pf AS400 and SQL Tricks

170 views - 1 year ago

Unzip the Library or Save file in ifs using QSHELL Jar command and FTP and restore in IBM i (AS400)

Unzip the Library or Save file in ifs using QSHELL Jar command and FTP and restore in IBM i (AS400) AS400 and SQL Tricks

156 views - 1 year ago

Zip the IBM i Library or Save file in ifs using QSHELL Jar command in AS400

Zip the IBM i Library or Save file in ifs using QSHELL Jar command in AS400 AS400 and SQL Tricks

269 views - 1 year ago

creating zip file in IFS as400 using QSHELL command by first changing current directory

creating zip file in IFS as400 using QSHELL command by first changing current directory AS400 and SQL Tricks

336 views - 1 year ago

How to ZIP multiple files in IFS using Java QSHELL command JAR(Java Archive) on IBM i (AS400)

How to ZIP multiple files in IFS using Java QSHELL command JAR(Java Archive) on IBM i (AS400) AS400 and SQL Tricks

153 views - 1 year ago

How to create IBM i ZIP files in IFS using Java QSHELL command JAR(Java Archive) on AS400

How to create IBM i ZIP files in IFS using Java QSHELL command JAR(Java Archive) on AS400 AS400 and SQL Tricks

275 views - 1 year ago

Macros|| Macros in IBM i || Macros in AS400 || Macros in ACS || Recording Macros || Create Macros

Macros|| Macros in IBM i || Macros in AS400 || Macros in ACS || Recording Macros || Create Macros AS400 and SQL Tricks

1.4K views - 1 year ago

SQL versus traditional file access Terminology in IBM i AS400

SQL versus traditional file access Terminology in IBM i AS400 AS400 and SQL Tricks

118 views - 1 year ago