DATABASE
01. DOCUMENTS
Guru: Finding Data In The Forest – Exploring Three-Part Naming In SQL
Unlock the power of three-part naming in SQL for efficient data retrieval on IBM i systems.
READ_FILEGuru: Where’s The Table?
Explore the critical role of table structures in IBM i systems and their impact on data management and application pe...
READ_FILEDetermining the Ordinal date with SQL
Learn to accurately determine ordinal dates using SQL on IBM i systems for efficient data management.
READ_FILEDetermine the length of a string when using SQL
Learn how to accurately determine string length using SQL on IBM i systems.
READ_FILEGuru: Load A Varying-Dimension Array With One SQL Fetch
Master the technique to load varying-dimension arrays using a single SQL fetch for optimal performance on IBM i systems.
READ_FILEReducing the amount of unnecessary Index Advisor data
Streamline Index Advisor data for enhanced performance.
READ_FILEGiAPA Tracks SQL Performance Issues On IBM i
GiAPA effectively identifies SQL performance issues on IBM i.
READ_FILERetrieving the description for the Audit Journal Entry Types
Learn how to retrieve descriptions for Audit Journal Entry Types on IBM i systems.
READ_FILE02. VIDEOS
How to Connect DB2 With SQL Developer
What is IBM DB2? (History, Features & Why It Matters)
Database Autonomy (Miran Badzak, @IBM Ep 66)
DB2 SQL for Beginners: Write Your First Query
26. IBMi (AS400) Introduction to DB2 SQL
Database Comparison - Oracle, IBM DB2, Microsoft SQL Server, Sybase ASE
Mainframe - IBM DB2, Types of Database, DB2 Objects. #mainframes #kumaritchannel
Migrating Data from DB2 Backup to MS SQL Server
IBM Db2 AI for z/OS - Demo
