14
Mon, Sep
2 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 139 results found.

Search for:
Search Only:

Page 1 of 3

1. SQL 101 – Making the DB User Friendly – Checking Database Consistency with the Exception Join
(SQL)
... If you read the previous article, you know how the EXISTS predicate works and have a good grip on the whole INNER/OUTER JOIN thing; explaining the exception join will be a breeze. In the previous article, ...
Created on 02 March 2026
2. SQL for IBM i - Checking Database Consistency with the Exception Join
(SQL)
Now that you know how the EXISTS predicate works and have a good grip on the whole INNER/OUTER JOIN thing, explaining the exception join will be a breeze. By Rafael Victória-Pereira Like many IBM i ...
Created on 09 June 2025
3. SQL 101: DML Recap—Joining Tables, Part 2
(SQL)
Once you get the hang of this, you’ll be joining tables left and right (pun intended). By Rafael Victória-Pereira We’ve discussed the INNER JOIN, which is similar to the IMPLICIT JOIN you’re probably ...
Created on 01 November 2022
4. SQL 101: DML Recap—Joining Tables, Part 1
(SQL)
... EXCEPTION JOIN, for later. Let’s start with the simplest of them all: the INNER JOIN. They say no man is an island. We’re social creatures and (most of us) need to live in a community. In a properly ...
Created on 06 September 2022
5. And The Winner is...Team WMCPA
(Channel News)
On behalf of the Maxava iFoundation, we'd like to thank everyone who participated in "the IBM i Community Strikes Back" bowling tournament. Please join us in congratulating Team WMCPA! On behalf of ...
Created on 21 September 2017
6. Practical SQL: Three Ways to JOIN
(SQL)
... of the JOIN syntax introduces the JOIN keyword. This brings us not only the JOIN (also known as the INNER JOIN), but also the LEFT and RIGHT OUTER JOINs, the FULL OUTER JOIN, the CROSS JOIN, and the EXCEPTION ...
Created on 05 October 2011
7. TechTip: Don't Get Stuck on Field Names When Creating File Joins in SQ
(SQL)
...  inner join SALES" on the "FROM files" line and no field names to complete the join clause. Creating a second session and performing a DSPFFD command would solve the problem, but here's a quicker, easie ...
Created on 12 June 2009
8. Exploit the Power of Joins in SQL SELECT Statements
(SQL)
Inner joins, outer joins, exception joins, cross joins... Do you know how to take full advantage of all the types of joins? By Kevin Forsythe Editor's Note: In this excerpt from SQL for eServer ...
Created on 07 October 2008
9. Nominations Open for Joint COMMON/IBM Innovation Awards
(Operating Systems)
... that has demonstrated an outstanding commitment to the i5/OS community. A committee of representatives from both COMMON and IBM will select the award recipients. Each winner will receive an engraved ...
Created on 15 February 2008
10. TechTip: Full Outer Joins on DB2 for i5/OS
(DB2)
... case, a full outer join enables a query to return both matching and non-matching rows from both of the tables specified in the join. This is different from inner joins (which return only the matching rows), ...
Created on 11 January 2007
11. TechTip: It's Easy to Join If You Know How to Chai
(General)
... supports several types of joins, depending on the implementation. For the iSeries, joins can be divided into three broad categories. Inner joins produce results only when the values of the join fields ...
Created on 19 May 2005
12. New Linux Servers Join IBM's POWER Portfoli
(Analysis of News Events)
... consolidation and business intelligence. Over time, the OpenPower family will gain additional models. For instance, IBM intends to ship a thinner (2U high) one- to two-way model during the first quarter ...
Created on 12 September 2004
13. Beginner's Luck with AV
(General)
... to the screen faster! Once we went live on the new AS/400, however, there was no contest. The NT server was easily the winner. I then had to stop and think about all this, not only what this difference ...
Created on 31 January 2000
14. In the world of heterogeneous computing the winner is . . .
(Commentary)
... after page. So what are the right answers? May I have the envelope, please? And the winner is...you! Despite all the hype vendors can muster, none of these computer products and none of our information ...
Created on 30 April 1996
15. Advanced Join Techniques Using OPNQRYF
(Business Intelligence)
... variance quantity (VARQTY) as the quantity shipped minus quantity ordered. This number will be positive for overshipments and negative for undershipments. Since this is an inner join, we can code join ...
Created on 31 July 1995
16. Using OPNQRYF to Join Files
(Business Intelligence)
... will perform a type of join?the exception join?that isn't available through join logical files. Types of Joins Some relational database systems support only one type of join?the inner join?but the AS/400 ...
Created on 30 June 1995
17. TechTalk: Using Outer Joins in SQL
(SQL)
... RETURNS record; the nulls returned showed as dashes. As you can see in the syntax diagram, the new syntax also supports inner and exception joins. Inner joins return only records that have matching records ...
Created on 30 June 1995
18. Joining Files
(General)
... to consider only three: the inner join, the partial outer join, and the exception join. These are distinguished by what happens when a record from the primary join file has no matching records in the secondary ...
Created on 30 June 1990
19. Unlocking the POWER of AI on IBM i: Your Practical Guide to Smart Integration with Python, REST & Db2
(RPG)
... the intelligence derived from AI may come from the cloud as a service, the source of irreplaceable value will always be the enterprise data that resides on the IBM i platform today. Rather, the winners ...
Created on 06 July 2026
20. SQL 101 – Making the DB User Friendly – Other CASE use cases
(SQL)
... CLASS_NAME             , CLASS_YEAR             , STUDENT_NAME             , GRADE    FROM     UMADB_CHP4.TBL_GRADES             INNER JOIN UMADB_CHP4.TBL_SORT_SEQ                   ON TABLE_NAME ...
Created on 02 June 2026
21. iCON 2026: A Look Back at an Incredible Conference!!
(Industry News)
... day in the life is like for developers and admin. A highlight of every iCON, this year's RPG competition brought out some outstanding talent. Congratulations to all of the winners: 1st Place: Cedric ...
Created on 27 March 2026
22. SQL 101 – Making the DB User Friendly – The beauty and usefulness of the EXISTS predicate
(SQL)
...        , DIRECTOR.NAME as "DIRECTOR_NAME"       , DIRECTOR."RANK" as "DIRECTOR_RANK"       , TA.NAME as "TA_NAME"       , TA."RANK" as "TA_RANK" FROM UMADB_CHP4.TBL_COURSES COURSES       INNER JOIN ...
Created on 01 December 2025
23. SQL 101 – Making the DB User Friendly – Using Views to simplify data access, Part 2
(SQL)
... the SELECT statement I’ve been working with to include the Classes table, using another INNER JOIN, and add a COUNT to the SELECT clause, like this: SELECT      COURSES.COURSE_ID       , COURSES.NAME ...
Created on 29 September 2025
24. SQL 101 – Making the DB User Friendly – Using Views to simplify data access, Part 1
(SQL)
...        , TA.NAME as "TA_NAME"       , TA."RANK" as "TA_RANK" FROM UMADB_CHP4.TBL_COURSES COURSES       INNER JOIN UMADB_CHP4.TBL_TEACHERS DIRECTOR ON COURSES.CODE = DIRECTOR.NAME       INNER ...
Created on 31 August 2025
25. 2025 Cost of a Data Breach Report: Navigating the AI rush without Sidelining Security
(Security)
The cyber landscape has changed dramatically with the rapid adoption of artificial intelligence. In the frenzied race to harness the potential of AI, organizations often find themselves up against the ...
Created on 11 August 2025
26. SQL for IBM i - Hiding Database Complexity
(SQL)
... statement I’ve been working with to include the Classes table, using another INNER JOIN, and add a COUNT to the SELECT clause, like this: This works, no doubt. But it can get really confusing, really ...
Created on 12 May 2025
27. The Boldest Ideas from the THINK Stage
(Analytics & Cognitive)
Innovators from Ferrari, Meta, Lumen and other major players took the stage at IBM Think 2025 this week to share how they’re using AI to solve real-world problems—from deploying purpose-built AI to extracting ...
Created on 12 May 2025
28. SQL 101: DDL Recap—Seeing Things from a Whole New View (Pun Intended)
(SQL)
... sensitive data. Let’s start with the database-complexity issue: Even in our simple database, it’s not very practical to include the same INNER JOIN lines on every single SELECT statement to establish the ...
Created on 03 December 2024
29. IBM Launches Fourth Annual Call for Code Global Challenge to Tackle Existential Threat of Climate Change
(Industry News)
... team to incubate and deploy their solution in communities where it's most needed, just as we've done with past winners. I encourage every developer and innovator around the world to seize this opportunity ...
Created on 23 March 2021
30. TechTip: Streamline Your SQL Procedures, Functions, and Triggers
(SQL)
... p INNER JOIN assignment_count a ON p.program_schema = a.program_schema AND p.program_name = a.program_name WHERE routine_body='SQL' AND routine_type IN ('PROCEDURE','FUNCTION','TRIGGER') AND    MONTHS_BETWEEN(CURRENT_DATE, ...
Created on 13 January 2021
31. IBM Drives Capabilities for Clients to Run Business-Critical SAP Software Workloads on Hybrid Cloud
(Cloud News)
... 37,000 SAP-certified professionals, and is one of the most awarded SAP partners, named an SAP Pinnacle Award winner 36 times. 2 About IBM Cloud For further information visit: www.ibm.com/cloud/.   ...
Created on 22 October 2020
32. IBM Watson Demonstrates New Natural Language Processing Advancement in Premiere of "That's Debatabl
(Analytics & Cognitive News)
... arguing for the motion, against former U.S. Treasury Secretary Lawrence Summers and Manhattan Institute Senior Fellow Allison Schrager. To determine the winner of the debate, the virtual debate audience ...
Created on 13 October 2020
33. SQL 101: A Data Definition Language Hands-on Tour, Part 5
(SQL)
... are not shown because they’re in separate tables. You already know how to solve this, right? Just write a SELECT statement with an inner join, and you’re done—but you’ll need to add that inner join to ...
Created on 13 October 2020
34. Introduction to COBOL programming language
(IBM Videos)
... Beginner’s Practical Approach to COBOL": http://ibm.biz/COBOLwebinar Read more about COBOL: http://ibm.biz/BdqqbE Build Smart. Join a global community of developers at http://ibm.biz/IBMdeveloperYT  ...
Created on 22 May 2020
35. 2020 Call for Code Global Challenge Led by IBM Takes On Climate Change on 75th Anniversary of United Nations
(Other Industry Solutions)
... an emergency medical nurse, and three developers. As recently piloted, the Prometeo hardware-software solution is based on multiple IBM Cloud services. Other applications like 2018 Call for Code winner ...
Created on 26 February 2020
36. SQL 101: Killing Open Query File Operations with SQL Cursors
(SQL)
... statement looks like this: /Free    Exec SQL      DECLARE mainCursor CURSOR      FOR      SELECT InvMst.ItemID, ItemDesc, ExpDate      FROM   InvMst InvMst      INNER JOIN ItmMst ItmMst ON ...
Created on 12 August 2019
37. SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 1
(SQL)
... SELECT statement joins both tables (using an inner join) and returns the relevant columns of each of them. However, most programs are ready to treat a record at a time, not the entire set of data that ...
Created on 11 June 2019
38. SQL MERGE Statement Tricks
(DB2)
... line is extremely important! It explains how the records in the origin and target tables will be matched, just like you’d do in an INNER JOIN instruction. WHEN MATCHED THEN—This is where the fun begins. ...
Created on 23 July 2018
39. IBM Leads 'Call for Code' to Use Cloud, Data, AI, Blockchain for Natural Disaster Relie
(Cloud News)
... September. A prominent jury, including some of the most iconic technologists in the world, will choose the winning solution from three finalists. The winner will be announced in October 2018 during a ...
Created on 24 May 2018
40. Association of Public-Safety Communications Officials (APCO) International Taps IBM Watson Capabilities to Evaluate and Report on Emergency Calls
(Business Intelligence)
... IBM Business Partner and winner of the IBM 2016 Worldwide Watson Innovative Business Partner of the Year Award. APCO IntelliCommä will use Watson Speech-to-Text and other IBM Watson and machine learning ...
Created on 12 August 2017
41. Where Is RPG Going?
(RPG)
... of the computer world. Much as I like the simplicity of RPG I/O, I know that SQL is the ultimate winner. Everyone knows it (except maybe us), kids in grade school can code it, and it’s exceptionally ...
Created on 16 May 2017
42. TechTip: C# for RPGers - More List Methods and a String Surprise
(General)
... on the innermost method and making its way to the outermost one) to produce the appropriate result. Here’s how it could look: serverNames.RemoveAt(serverNames.IndexOf("S/38")); However, if you run your ...
Created on 25 January 2017
43. TechTip: DB2 for i Optimization Strategies, Part 6
(DB2)
...      ,pnt.Name AS PhoneNumberType FROM Person p     INNER JOIN Customer c     ON c.PersonID = p.BusinessEntityID     LEFT OUTER JOIN PersonPhone pp     ON pp.BusinessEntityID = p.BusinessEntityID ...
Created on 13 October 2016
44. December 16, 2022 | Volume 14 Issue 77
(MC TNT Tips n Techniques)
- LEAD ARTICLE: TechTip: Data Source Base Project, Part 1 - FEATURED NEWS: IBM and David Clark Cause Aim to Reduce Food Waste; Name AI-Powered Gardening App Winner of 5th Annual Call for Code - NEWS ...
Created on 08 October 2016
45. Benelux Power 2016
(Certification / Training)
... pointed Vendor Solutions flashes in the Expo area on Thursday 20 October. 6 Excellence Awards’ winner and finalists sessions on innovative Software and Infrastructure solutions. This is a brand new feature ...
Created on 20 September 2016
46. A Bootstrap Love Affair, Part Three
(Development Tools / Utilities)
...                  2.0   .carousel-inner > .item > img {    margin: 0 auto; }           Bootstrap carousel example 1   3.0     4.0    ...
Created on 09 August 2016
47. Benelux Power Excellence Awards 2016 Invites Best Solutions Involving the IBM i
(Certification / Training)
... – Infrastructure & Security, Software and Database solutions and Managed Services. A jury of representatives of Benelux Power and IBM will select the winner and the nominees. Their decisions are final. ...
Created on 04 August 2016
48. The Spark
(Commentary)
... week? 6:00 p.m. on Mondays and Wednesdays. Those are the days I coach my eight-year-old son’s baseball team. My wife and I work nearly opposite times of the day, so dinner time, when we’re all together, ...
Created on 17 July 2016
49. How Much Do You Really Know About Modern RPG Programming?
(RPG)
... FROM   InvMst InvMst      INNER JOIN ItmMst ItmMst ON InvMst.ItemID = ItmMst.ItemID      WHERE WHID = :K_WHID;   Notice the line in bold? The WHERE clause with host variables (in this case just ...
Created on 19 January 2016
50. SQL 101: Getting Rid of DFU with the Update and Delete Statements
(SQL)
...     Shl.WHID = ML.WHID AND Shl.ShelfID = ML.ShelfID );   So, what's going on here? I'm doing an implicit Inner Join between the Shelves and MaintenanceList tables using the warehouse and shelf IDs. ...
Created on 23 October 2015

LATEST COMMENTS

Buyer's Guide Search

Advanced Search

Popular Products

Nexus Portal
43,978
IPCharge
38,956
IPCharge
38,956
Barcode400
37,629
WebSmart ILE and PHP
37,112
Presto
36,878
Catapult
35,742
Catapult
35,742
EDI Software - EZConnect iSeries EDI/XML Software Solutions
25,562
EDI Software - EZConnect iSeries EDI/XML Software Solutions
25,562
Show more...

Buyer's Guide Menu