About the Webinar

Our Lunch and Learn session – Batch Support for Remote Database leveraging Data Definition Mapping (DDM)and SQL, aims to present the approaches that can help with data management and processing across remote databases in a batch-oriented manner.

Data Definition Mapping (DDM) helps define and map data structures between the local and remote databases, facilitating data interoperability between systems. Meanwhile, Structured Query Language (SQL) helps with data querying and manipulation in relational databases. Regarding batch support for remote IBMi databases, SQL can perform batch operations in remote databases, ensuring data processing efficiency.

Combining DDM and SQL can help with batch process design and execution, including accessing, retrieving, and updating data on remote databases from the IBMi system. This approach improves data management efficiency and flexibility, enabling seamless data integration and processing across various systems.

In this session, we will discuss the different approaches for leveraging DDM and SQL to streamline data management in batch processes for remote databases.

Key Takeaways

  • Investigating batch jobs, tackling various errors (also called Message Waits) that occur during runtime
  • Exploring updates on the latest IBMi Advanced Job Scheduler (WRKJOBJS) and configuring them to receive email notifications on ‘successful/unsuccessful completion’ of the scheduled jobs.
  • Creating SQL statements that connect databases on remote IBM i/AS400 systems
  • Using the DDM file to transfer data from one server to another