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. Read More
More about getting information about SQL Views noreply@blogger.com (Simon Hutchinson)
[[{“value”:”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 »”}]] Read More
TD/OMS Version Conflicts (and how to resolve them) Remain Software
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. Read More
Hey AI — “What are the different types of IBM i SQL Variable?” NickLitten
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 Read More
How to initialize a timestamp variable using IBM i SQL NickLitten
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 Read More