Daily news about IBM i

Welcome to another edition of Talsco Weekly IBM i Brief:  🔗 ​LightEdge Acquires Connectria. 🚀​ Rocket DevOps Receives Major Update. AI:  ​IBM AI Adoption Index​. AI and the IBM i. Development:  ❓ ​A Basic Node.js Question. A Deep Dive Into Node.js Streams. Data:  🔍 ​CD Query emerges as an alternative to DB2 Web Query. Training:  The post Talsco Weekly: ​AI and the IBM i appeared first on IBM i (AS/400, RPG) Recruiting, Staffing & Consulting.

You know, you have a numeric field from a file, and you use a BIF to convert it to a character field. The second thing to keep in mind about BIFs is that while many use just one parm, most of them are going to have multiple parms that need to (or can be) passed within the parentheses.

IBM Administration Runtime Expert for i uses Dojo to render it’s web interface. Dojo 1.3.3 could allow an attacker to execute arbitrary code on the system, as described in the vulnerability details section. This bulletin identifies the steps to take to address the vulnerability as described in the remediation/fixes section.

More SQL Basics from the AI Archives How to initialize a timestamp variable using ibm i sql To initialize a timestamp in IBM i SQL, you can use the CURRENT TIMESTAMP special register which specifies a timestamp based on the reading of the time-of-day clock when the SQL statement is executed. If you need a

AI is getting clever. I’m honestly not too sure that AI is a good thing. We all watched the Terminator movies, right? But that being said, I like to use the Microsoft’s COPILOT AI, because it makes collating answers to questions so very simple. It certainly makes researching answers to quick questions just about a

Find out what virtual tape solutions bring to IT operations, including speed, flexibility and centralized management. Learn about integrating virtual tape and taking advantage of the advanced capabilities to streamline and enhance backup and recovery operations.

Understanding version conflicts—both potential and actual—is essential in any software development lifecycle. This video provides a succinct overview of how TD/OMS tackles version conflicts. We demonstrate why it’s critical not to jump the gun on confirming conflicts and emphasize the importance of confirming version conflicts at the Task level. Our guided tour includes an in-depth look at the ‘Version Conflict View’ within TD/OMS, illustrating how it can become a vital part of your team’s toolkit for managing versions effectively. Whether you’re a seasoned professional or new to TD/OMS, our walkthrough is packed with practical learning points to help you maintain harmony in your codebase.

Several years ago I wrote a post about the Db2 for i (SQL) Views about Views: SYSVIEWS:  Information about Views themselves SYSVIEWDEP:  Information about Views’ dependencies One of the things I talk about during presentations I give to Local User Groups, LUG, is the use of SQL Views and how they make my programming simpler. Therefore, I wanted to revisit these two Views and explain how they help me learn more about the Views in the partitions I use. Before I can show what kinds of information I can get from SYSVIEWS and SYSVIEWSDEP I am going to need some Views to play with. I am going to join a DDS file, TESTFILE, and a DDL table, TESTTABLE to create my first View. While it is not essential to know what the file and table look like I am just going to include their source code below. First TESTFILE: Read more »

The latest release of Rocket’s change management tool for IBM i brings several new capabilities, including improved support for VS Code and Free Form RPG. Rocket DevOps version 10.3.1 also brings better code testing capabilities and will help companies comply with new regulations, such as the EU’s Digital Operations Resilience Act (DORA). Rocket Software added support for the browser-based development environment VS Code last fall with the launch of Rocket DevOps version 10.2.2. Customers will find the new release of Rocket DevOps improves on that initial VS Code support, says Puneet Kohli, the president of the Rocket’s Application Modernization Business … The post Rocket DevOps Gets Update for Free Format RPG, VS Code, and DORA appeared first on IT Jungle.

The need for multi-factor authentication (MFA) has never been higher, as cybercriminals continue to compromise corporate and governmental systems to steal data and hold systems for ransom. That market need has led Raz-Lee Security to add several new features to its MFA solution that should help its customers stop, or at least significantly slow, unauthorized access to IBM i. Raz-Lee Security has sold MFA as part of its comprehensive iSecurity suite for several years, going back at least to December 2021, according to the company’s release notes for the product. With this month’s update to Raz-Lee MFA, the company has … The post Raz-Lee Simplifies MFA for IBM i appeared first on IT Jungle.

Access Client Solutions (ACS) users who are tired of waiting for database fields to resolve in the Run SQL Scripts (RSS) facility will be happy to hear that IBM felt their pain and RSS will return data much more quickly to return data with ACS version 1.1.9.5, which IBM shipped earlier this month. The speed-up of field resolution time was listed as a concern to at least one IBM i user, who took to IBM Power Ideas Portal to voice his or her concern. “Simply put the resolution of potential field makes content assist almost unusable,” the user wrote. “I … The post IBM Cranks Up the Performance for Run SQL Scripts appeared first on IT Jungle.

In this world, there are always more than two ways to skin a cat, but the best way to skin any cat is the way you already know how to do it. The same is true of application development from within a DevOps toolchain. When modernizing development processes on IBM i, the most efficient thing to do, always, is to make use of enterprise tools already in place within the organization and integrate these into a cohesive IBM i workflow that shepherds code from idea to production all along the way. It may seem obvious to say so, but trust … The post DevOps Means Using The Tools You Already Have Better appeared first on IT Jungle.

Million, billion, trillion. The way these words get thrown around has made us desensitized to what they really mean. But we did stop short when we saw a story asking if IBM could become a trillion-dollar stock by 2030. You will have to read the top headline below to see how realistic of a goal that is, but if Nvidia, Microsoft, and Apple can do it, why couldn’t Big Blue? Read on to consider that, and get the rest of the headlines of the week. Plus, don’t miss our growing Chats, Webinars, Seminars, Shows, and Other Happenings section. There are … The post Four Hundred Monitor, April 24 appeared first on IT Jungle.

Travis build: 166

Welcome to the #IBMi update for the past four weeks in March / April 2024. This month, we’re at the i-UG event in London and investigate modern development languages with IBM i Champion, Andy Youens as well as why keeping everything on i makes sense for your data. You can watch the video below or The post IBM i Update: March/April 2024 appeared first on Proximity.

IBM i security is a top priority for nearly every organization that uses the OS, but achieving this goal is easier said than done. Every year, IT environments grow in complexity – making it difficult to prioritize IBM i security. The 2024 State of IBM i Security Study results are here to help you make the most of your time and resources. IBM i security experts Amy Williams and Sandi Moore will walk you through the new data, illustrated by examples from their work helping hundreds of IBM i organizations.Watch this webinar to understand:- Real-world data from actual IBM i systems – Today’s top IBM i security trends – Action-oriented tips to help you make improvements on your systemsIf you’re responsible for cybersecurity, compliance, or IBM i systems, you don’t want to miss this session!Find out where your systems are secure and where they could be vulnerable with a free IBM i Security Scan: https://www.fortra.com/solutions/data-security/security-vulnerability-scan

The PRTSTORE (Print System Store) command in QMGTOOLS allows the user to print the certificates in the *SYSTEM store and include a list that is expiring within the days specified.  This command uses the QSYS2.CERTIFICATE_INFO IBM i Services table function.https://www.ibm.com/docs/en/i/7.4?topic=services-certificate-info-table-functionThis is only supported on R730 and later versions.  It is not supported on R720.

Let’s do the security bulletins first and then the denial of service issues. First, we have Security Bulletin: IBM i Access Client Solutions is …

Kisco Systems today announced the opening of the next selection process for the Richard C. Loeber Fellowship for Careers in IBM i The post Selection Process Open for Kisco’s IBM i Career Development Fellowship appeared first on TechChannel.

Dawn May reviews how to get started with the Performance Data Investigator in Navigator for i The post Getting Started with the Performance Data Investigator appeared first on TechChannel.