COMMON India

SQL Services on IBM i is a hot topic because there are so many ways that SQL Services can bring unique value and ease of use to anyone using an IBM i. Attend this session to understand which SQL Services have proven to be some of the most powerful and popular with IBM i users.

The session will also include many working examples, to help you get started today!

This session will unleash the advanced use of SQL in IBM i.
 
This session will help attendees to understand Query processing and provide guidance on techniques for performance optimization.
 
Takeaways:

1. Understand phases of query processing and Execution engines
2. Discover SQL best practices and optimization techniques.
3. Gain insight into tuning capabilities for Enhanced Query and System Performance.

To modernize IBMi development, integrating tools like Git, JIRA, Jenkins and IDEs is key. Integrating IBMi with modern DevOps tools enhances collaboration and automation across the development lifecycle. Git offers robust version control for RPG, COBOL, and CL, ensuring that code changes are tracked and managed efficiently.

JIRA allows teams to handle project management, linking issues directly to code commits and providing visibility into development progress. Jenkins streamlines CI/CD pipelines, automating builds, testing, and deployments across multiple environments, with custom scripts needed for IBM i-specific tasks.

Additionally, IDEs like RDi or VS Code, with IBM i plugins, provide modern interfaces for coding, debugging, and pushing updates. These integrations, while sometimes requiring customization, significantly boost development agility and operational efficiency for IBM i.

• Understand Git for Version Control: Learn how Git manages RPG, COBOL, and CL code, including branching, merging, and repository integration.
• JIRA for Project Management: Explore how JIRA tracks issues, links them to code changes, and integrates with the DevOps pipeline.
• Jenkins for CI/CD Automation: Discover how Jenkins automates builds, tests, and deployments on IBMi, using custom scripts where needed.
• Modern IDEs for IBM i Development: Learn how IDEs like RDi and VS Code integrate with DevOps tools for efficient coding, debugging, promotion.
• Custom Scripting for IBM i DevOps: Understand the role of custom scripts in adapting DevOps tools for IBMi environments.
•  Seamless DevOps Workflow: Grasp how integrating Git, JIRA, Jenkins, and IDEs enhances agility, collaboration, and operational efficiency in IBMi development.

Service programs have been around for quite some time.  Perhaps you’ve even bumped into one in your professional travels.  You will certainly find them on the road to application modernization.  This session focuses on what they are, how to implement them and making them a regularly used asset during your application development.   In this session we will discuss service programs, program signatures and using binder language source.