22
Fri, Nov
1 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 127 results found.

Search for:
Search Only:

Page 1 of 3

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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
21. 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
22. 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
23. 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
24. 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
25. 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
26. 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
27. 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
28. 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
29. 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
30. 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
31. 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
32. 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
33. 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
34. 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
35. 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
36. 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
37. 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
38. 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
39. TechTip: SQLing to the Cloud in Seven Steps
(SQL)
... the same fields in the mirror image file, then the record was updated and should be sent as an Update. This is accomplished in SQL by creating an inner join by joining the key from the current image file ...
Created on 09 October 2015
40. SQL 101: Writing More Complex Queries
(SQL)
... , ExpDate FROM        InvMst InvMst INNER JOIN ItmMst ItmMst ON InvMst.ItemID = ItmMst.ItemID WHERE       InvMst.ItemID = 'A123' AND WHID = 333 ORDER BY    ExpDate   Even though this statement ...
Created on 10 July 2015
41. Build Real Teamwork in a Virtual Team
(General)
... together without them having to be together. You could run team competitions and bring the team together on a virtual team day to discuss the entries and maybe vote on the winners. Introducing a fun and ...
Created on 09 March 2015
42. TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i
(SQL)
...  FROM numbered_sets s INNER JOIN navigate_sets n      ON s.make = n.make AND s.rownum = n.rownum+1 )                           SELECT make, MAX(model_list) FROM navigate_sets GROUP BY make The ...
Created on 12 February 2015
43. Data Security in a Nebulous World
(Security - Other)
... entirely. Storing your data in-house not only makes you a smaller target, but also tightens the inner circle of server administration. There's no longer any need to give strangers at a server farm access ...
Created on 25 January 2015
44. Profound UI Version 4.8 Delivers New Features That Support Modern RPG Development Latest Release
(Development Tools / Utilities)
Version 4.8 Includes the Ability to Use Descriptive Field Names, Tools for Browser Detection, and a New Application Development API. Version 4.8 Includes the Ability to Use Descriptive Field Names, ...
Created on 16 January 2014
45. Maxava Shares Richard Dolewski's IBM i Business Continuity Expertise Globall
(Other Industry Solutions)
Maxava, a leader in IBM i high availability (HA) and disaster recovery (DR) software for both on-premise and cloud environments, announced that Richard Dolewski is currently appearing at a number of events ...
Created on 23 September 2013
46. Build a Searchable Web-Service Using OmniFind Text Search Server for DB2 for i
(DB2)
... AS "Resume URL" FROM resume_app.applicant applicant      INNER JOIN      resume_app.position job USING (position_id) WHERE job.job_code = 'JB001' ORDER BY applicant.name ASC; Listing 1: The SQL query ...
Created on 14 August 2013
47. Introduction to SQL, Part 5
(SQL)
... We will now prompt the Select statement we created, and then we will do an Inner Join with the ZIPPF table so that we can display the city and state columns in our SQL result set. In Figure 13.43, ...
Created on 12 June 2013
48. In the Wheelhouse: V5R4 Goes on Life Support, and IBM Markets IBM i Social-Style
(Analysis of News Events)
... The three value prizes for direct voting will be awarded during the Gala Dinner celebrating the 25 years of IBM i on June 20. The preliminary results will be announced during July 2013. Here are the ...
Created on 06 May 2013
49. Introduction to SQL, Part 4
(SQL)
Editor's note: This article is an excerpt from Mastering IBM i, published by MC Press. Written by James Buck and Jerry Fottral SQL's version of a logical file is a view. Although a view is conceptually ...
Created on 10 April 2013
50. Introduction to SQL, Part 3
(SQL)
... with the following statement:   Select     LASTNAME, PM.EMPNO,              Count(*) As NUM_OF_PROJECTS,              Decimal(Sum(HRSTD),4,0) As TOTAL_HRS From     PRJMBRPF PM Inner Join EMPPF ...
Created on 13 March 2013