Invidious
AS400 and SQL Tricks
Subscribe | 6.1K
 RSS

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)

View channel on YouTube
Switch Invidious Instance
Videos
Shorts
Courses
Playlists
Posts
newest
oldest
popular
Next page  

1:00

Part of library list and Maximum libraries in IBM i

AS400 and SQL Tricks

Shared 55 years ago

782 views

1:00

How do you declare more than one file in CL program

AS400 and SQL Tricks

Shared 55 years ago

465 views

1:00

How do you read a DSPF and Database file in CL program

AS400 and SQL Tricks

Shared 55 years ago

439 views

1:00

What is the difference between DOW and DOU loop

AS400 and SQL Tricks

Shared 55 years ago

480 views

1:00

What is the difference between PACKED and ZONED decimal in as400

AS400 and SQL Tricks

Shared 55 years ago

465 views

1:00

What is the default data type for decimal 0 in PF

AS400 and SQL Tricks

Shared 55 years ago

313 views

1:00

What is the default data type of DS subfields in RPGLE AS400

AS400 and SQL Tricks

Shared 55 years ago

303 views

1:00

What does EXFMT do in RPGLE AS400

AS400 and SQL Tricks

Shared 55 years ago

275 views

1:00

what is a spool file in AS400

AS400 and SQL Tricks

Shared 55 years ago

395 views

1:00

How do you pass parameters in CL program

AS400 and SQL Tricks

Shared 55 years ago

300 views

1:00

How to debug a job that is in MSGW state in AS400

AS400 and SQL Tricks

Shared 55 years ago

506 views

1:00

Difference between RENAME and PREFIX in RPGLE AS400

AS400 and SQL Tricks

Shared 55 years ago

372 views

1:00

Difference between ITER and DO in RPGLE AS400

AS400 and SQL Tricks

Shared 55 years ago

349 views

1:00

Difference between READC and SFLNXTCHG in AS400

AS400 and SQL Tricks

Shared 55 years ago

431 views

1:00

How can we display data from a flat file in AS400

AS400 and SQL Tricks

Shared 55 years ago

331 views

1:00

What is the maximum length of a variable name in the CL program

AS400 and SQL Tricks

Shared 55 years ago

265 views

1:00

How to retrieve the RRN value of the file record in RPGLE

AS400 and SQL Tricks

Shared 55 years ago

459 views

1:00

What are those commands which can only be executed in CL program but not in the RPG program

AS400 and SQL Tricks

Shared 55 years ago

273 views

1:00

Can we use a file with the same file name and same record format name in RPGLE

AS400 and SQL Tricks

Shared 55 years ago

344 views

1:00

How we can execute a CL command from within RPG program without calling a CL program

AS400 and SQL Tricks

Shared 55 years ago

377 views

1:00

How to check if a record is locked in RPGLE

AS400 and SQL Tricks

Shared 55 years ago

364 views

1:00

What operations we can perform on Indicators

AS400 and SQL Tricks

Shared 55 years ago

187 views

1:00

Use of *INLR in as400

AS400 and SQL Tricks

Shared 55 years ago

357 views

1:00

What is the difference between *INLR = *ON and RETURN

AS400 and SQL Tricks

Shared 55 years ago

331 views

1:00

What is the difference between PLIST and KLIST

AS400 and SQL Tricks

Shared 55 years ago

207 views

1:00

What are mandatory keywords for a Subfile

AS400 and SQL Tricks

Shared 55 years ago

245 views

1:00

Difference between CRTDUPOBJ and CPYF command

AS400 and SQL Tricks

Shared 55 years ago

297 views

1:00

What is CPF4131

AS400 and SQL Tricks

Shared 55 years ago

172 views

1:00

What is the purpose of using VARYING

AS400 and SQL Tricks

Shared 55 years ago

193 views

1:00

Why do we use the EXTMBR keyword in RPGLE

AS400 and SQL Tricks

Shared 55 years ago

258 views

1:00

Why do we use the USROPN keyword in RPGLE

AS400 and SQL Tricks

Shared 55 years ago

192 views

1:00

How to see all the record format in a file

AS400 and SQL Tricks

Shared 55 years ago

225 views

1:00

How to check all members of a file

AS400 and SQL Tricks

Shared 55 years ago

148 views

1:00

How to see all the objects in the library and their size

AS400 and SQL Tricks

Shared 55 years ago

173 views

1:00

Which library gets loaded first when we login to IBM i

AS400 and SQL Tricks

Shared 55 years ago

221 views

1:00

How can we avoid using indicators in RPG

AS400 and SQL Tricks

Shared 55 years ago

206 views

1:00

What is the disadvantage of a global variable in IBM i (AS400)

AS400 and SQL Tricks

Shared 55 years ago

199 views

1:00

What is the length of the variable in DCL VAR(&VAR2) TYPE(*DEC) in CL AS400

AS400 and SQL Tricks

Shared 55 years ago

239 views

1:00

What is the length of the variable in DCL VAR(&VAR1) TYPE(*CHAR) in CL as400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

185 views

1:00

How to find the dependent of a file in AS400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

359 views

1:00

What do we call the program variable used with embedded SQL in RPG AS400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

477 views

1:00

Why do we use *INLR = *ON in RPGLE as400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

809 views

1:00

What is *PSSR in IBM i AS400

AS400 and SQL Tricks

Shared 55 years ago

474 views

1:00

What can we do from O specs in RPG AS400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

336 views

1:00

Can you update a file in CL AS400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

308 views

1:00

How do you monitor the message in CL AS400 (IBM i)

AS400 and SQL Tricks

Shared 55 years ago

340 views

1:00

CA versus CF keys in IBM i AS400 (Command Attention || Command Function)

AS400 and SQL Tricks

Shared 55 years ago

437 views

1:00

How to check the end of the file in CL IBM i AS400

AS400 and SQL Tricks

Shared 55 years ago

515 views

Next page