In The Spotlight
The last few articles served as a recap of the Data Definition language. This and the next ones will do the same for the Data Manipulation Language (DML). Keep reading to learn or refresh your knowledge in this area.
By Rafael Victória-Pereira
In this new subseries on DDL, all the most important DDL instructions (CREATE, ALTER, and DROP) and objects (TABLE, VIEW, and INDEX) will be discussed. However, the discussion won’t focus on their syntax but will instead cover how to convert physical files to SQL tables and how to create self-managing unique keys.
By Jim Martin
Editor's Note: This article is excerpted from chapter 8 of Free-Format RPG IV: Third Edition, by Jim Martin.
In this excerpt series, we explore those options, which include assignment statements, a large stable of built-in functions, and operations for converting dates and times.
Date and Time Operations
Date operations such as Adddur and Subdur came to RPG IV with the beginning of the date, time, and timestamp data types. Free-format RPG IV doesn’t support these operation codes. Instead, new built-in functions are available to provide this functionality.
When cloud-based applications aren’t performing as well as is needed, investigating “cloud accelerators” might seem to be a logical next step. But that term means different kinds of products and services, depending on the context.
By John Ghrist
“Cloud accelerators” sounds like a generic term for solutions that might provide better performance of cloud-based applications. While it’s true that it’s used that way, simply googling those words and sitting back to page through the options isn’t going to be as simple as it might appear. These remedies have the goal of speeding up app performance but dissimilar methods and points of use.
Once your business has decided to switch to an enterprise resource planning (ERP) software system, the next step is to implement ERP. For a business to see the benefits of an ERP adoption it must first be deployed properly and efficiently by a team that typically includes a project manager and department managers as well.
This process can be complicated and feel overwhelming, depending on the needs of your organization. However, once new software is implemented successfully, organizations will ideally see the increases in productivity and cost savings benefits an ERP system can bring to your business. The switch to an ERP system can streamline your business needs and be beneficial to both the end user and entire organization.
Current Events All Events
12:00 to 12:30 CST
Db2 on IBM i is a fantastic platform for SQL. In fact, almost all the latest Db2 enhancements have been to further improve SQL performance and capabilities. That’s great news for developer productivity and for those who want to use a consistent data access language across multiple database types and platforms.
But not all SQL requests—internal or external—are created equal. Some can even bring your system to its knees!
Join our IBM i monitoring experts on December 14th for a webinar on how to tackle the two faces of SQL on IBM i. We demonstrate how you can both monitor SQL activity on your system while also creating user-defined SQL statements to retrieve and monitor nearly anything automatically for unlimited flexibility. You’ll learn how to:
- Tailor monitoring for QZDASOINIT and QZDASSINIT jobs
- Bring visibility to the SQL statement for offending jobs
- Add user-defined SQL statements for custom application analysis
- Allow IBM Services calls for even more flexibility
You’ll also see a live demonstration of Robot Monitor highlighting its real-time monitoring and notification capabilities.
Note: This webinar is offered at 5:00 A.M. CDT (11:00 A.M. GMT) and 12:00 P.M. CDT. Please choose the time most convenient for you.
- 14 December 2023 - 14 December 2023
- World Wide Web
Wed, Dec 13, 2023
8:00 PM - 9:00 PM MST
With end of support dates fast approaching for POWER8 the clock is ticking, and now is the time to consider your options in order to future-proof your infrastructure and protect your business.
Join Ash Giddings (Maxava Product Manager), John Dominic (Maxava Global Vice President) and Tonny Bastiaans (IBM Worldwide Offering Manager IBM Power Systems Virtual Server) on this free webinar, where they will dissect the options available to POWER8 environments. You will learn:
• What being out of support means.
• The risks of being out of support.
• What options are available both on-premise and in the cloud.
This webinar is aimed at IBM i System Administrators and personnel responsible for the IBM Power Systems estate.
- 13 December 2023 - 13 December 2023
- World Wide Web
Wow the holiday season is in full force and we hope you had a wonderful Thanksgiving. We have had a slight speaker change. Ryan Moeller will be covering for Scott Forstie, Ryan is a member of the Db2 for i team and we are very excited to have him present for us.
December is always Steak and Cheesecake as December is Jim Buck's Birthday month, so a huge Happy (early) Birthday to Jim!
A bit about Ryan:
Ryan Moeller is a Staff Software Engineer working on the SQL Query Engine (SQE) team within Db2 for i. Ryan joined the Rochester development lab in 2020, and he specializes in query optimization and database development, query performance analysis, SQL, and the latest and greatest Db2 for i tooling.
4:30pm to 5:30pm
Db2 for IBM i tools in VS Code
IBM is excited to share that we're working on database functionality inside of Visual Studio Code. At this session, we'll demonstrate and explain the new Database extension found within Code for IBM i. You will see the speed and simplicity of working with Db2 for i, alongside developing modern applications, all in one space.
Come to this session to meet your new best buddy... the Code for IBM i Database Extension!
7:30pm to 8:30pm
Navigator - As you've never seen it before
In this new session, Ryan & Tim will explore Navigator features and demonstrate how this feature rich GUI is built upon the shoulders of SQL.
We'll cover some of the most recent enhancements!
We'll explain some of the better and best practices!
Finally, Ryan will show how users can start with Navigator, but finish with ACS, for those situations not handled by Navigator.
We hope to see you there in person or virtually online!
- 14 December 2023 - 14 December 2023
- Alioto's Bar & Grill
- 3041 N Mayfair Rd Milwaukee, WI 53222 US
Support MC Press Online
Support MC Press with a contribution of any size.
Your support helps MC Press deliver free quality information about the new and legacy technologies you rely on to IT Professionals everywhere. Our goal continues to be helping you become more productive on the job and get more out of your career. Every contribution, regardless of size, furthers that goal.