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

Total: 127 results found.

Search for:
Search Only:

Page 2 of 3

51. DB2 TR5 Offers Lots to Be Excited About
(DB2)
...  INNER JOIN QWQCENT.STORES B ON A.STORECODE = B.STORECODE This enhancement also solves a bugger of a problem that many have encountered in the past: the inability to explicitly qualify a User-Defined ...
Created on 27 January 2013
52. In the Wheelhouse: Doubling Down Distributors and High Fashion
(Analysis of News Events)
... an option). IBM Builds Circuit 10,000 Times Thinner Than Paper Two scientists at IBM's Thomas J. Watson Research Center have designed a circuit that they believe could lead to powerful electronic devices ...
Created on 20 January 2013
53. Introduction to SQL, Part 2
(SQL)
... to specify three types of Join operations: Inner Join (type 1), Left Outer Join (type 2), and Exception Join (type 3). The following three examples show the proper syntax and the results for each of these ...
Created on 11 December 2012
54. Partner TechTip: Building Runtime-Prompted Views with SEQUEL
(System Administration)
...  "Backorder" WHEN otype="O" THEN "Blanket" when otype="R" then "Regular" ELSE "Invalid Type" end NAME(otype2),       invno.ordhead FROM       sequelex/custmast,sequelex/ordhead INNER JOIN      cusno.custmast=cusno.ordhea ...
Created on 06 December 2012
55. Infor Kicks Off Inforum 2012 User Conference
(Enterprise Resource Planning / Financial)
... show car. Musical Headliner: Three-time Grammy Award winners Train will perform at Infor's Customer Appreciation Night on Tuesday night. Infor Excellence in Action Awards: Infor will honor customer ...
Created on 23 April 2012
56. Profitero Named IBM Global Entrepreneur of the Year
(Channel News)
... and merchandising strategies. IBM has announced that it named Profitero the IBM Global Entrepreneur of the Year and winner of its SmartCamp competition for startup companies. Profitero analyzes competitor ...
Created on 07 March 2012
57. Nine Startups Vie for IBM Global Entrepreneur Honors
(Trends)
... providing current travel times, estimations on congestion rates and accident alerts (winner, SmartCamp Barcelona). C-B4 Context Based 4Casting: CB4 has created a context-based system for ...
Created on 25 January 2012
58. What Are the Differences Between DB2 for i and SQL Server SQL Syntax?
(SQL)
... APPLY and OUTER APPLY CROSS APPLY (similar to a row-based INNER JOIN) and OUTER APPLY (similar to a row-based LEFT JOIN) are not supported in DB2 for i, although sometimes the same thing can be accomplished. ...
Created on 10 January 2012
59. IBM Watson and Jeopardy! Relive History with Encore Presentation
(Servers)
... of concurrent tasks and data while analyzing information in real time.  Jeopardy! is the winner of 29 Emmy awards, including the 2011 Emmy for Outstanding Game/Audience Participation Show. The series ...
Created on 07 September 2011
60. IBM Turns 100
(Trends)
... at the Mars Corporation, and Sunil Mittal, founder and CEO of Bharti Enterprises, the largest telecom company in India. "Wild Ducks" was directed by Davis Guggenheim, an Oscar® winner for the documentary ...
Created on 17 June 2011
61. DB2 for i: Observing, Learning, Adapting, and Generating Faster Queries Automatically!
(DB2)
... orders o INNER JOIN customers c ON    o.customer_number = c.customer_number INNER JOIN items i       ON    o.item_number = i.item_number WHERE       c.customer_state IN ('IA', 'IL', 'MN') AND         ...
Created on 23 May 2011
62. COMMON Unveils New Virtual Education Product COMMON LIVETRACK
(Certification / Training)
... for Power Systems, will reveal the winner of the 2011 COMMON/IBM Power Systems Innovation Award, presenting the company with the crystal statue and certificate of achievement. More details about COMMON ...
Created on 13 April 2011
63. IBM Watson Computing System to Challenge Jeopardy! Champions
(Servers)
...  About Jeopardy! Jeopardy!, the winner of 28 Emmy awards since its syndicated debut in 1984, is in the Guinness Book of World Records for the most awards won by a TV Game Show. The series is the #1-rated ...
Created on 14 December 2010
64. SEPATON Marks Midyear with Innovative Products, New Strategic Alliance, and Record Customer Adoption
(Storage)
... 100 Finalist and winner of the Tech Awards Circle, taking bronze in the Midrange Hardware category for the SEPATON S2100 data protection appliance with DeltaStor deduplication software. Regional expansion: ...
Created on 23 September 2010
65. IBM Awarded 2010 SAP Pinnacle Awards
(Trends)
Winners were selected based on more than 230 nominations in 27 categories received from partners and SAP employees. IBM announced it has been awarded two 2010 SAP Pinnacle Awards including Customer ...
Created on 25 May 2010
66. V7's RPG Enhancements Include Open Access
(RPG)
... sorted. In this example, the inner array containing the monthly sales values is sorted into ascending sequence, and then the outer array (i.e., products) is sorted into product code sequence.   D products2       ...
Created on 13 April 2010
67. TechTip: Members Only? No Problem with DB2 Web Query
(DB2)
... the modified DECLARE CURSOR statement (from the stored procedure) is shown below.   DECLARE C1 CURSOR WITH RETURN TO CALLER FOR SELECT A.*, B.*, C.*, D.* FROM QTEMP/ORDERS_MBR A INNER JOIN QWQCENT/STORES ...
Created on 11 March 2010
68. Impulse TV
(Commentary)
... Electronic Express Dalai Lama—into embracing his inner Gordon Gekko.   I guess it's still too early to render a final verdict on my salesman's character or the quality of the Acme Bohem-a-tron flat-panel ...
Created on 25 February 2010
69. ERP for Free?
(Enterprise Resource Planning / Financial)
... inner workings of the software because they want a happy customer. Of course, if a solution requires a few hours of their time, then you're sure to pay for that time.   Will there ever be a true and relevant ...
Created on 07 February 2010
70. Navigate DB2 for i Through the SQL Server Galaxy
(DB2)
...    This is quite a bit for a beginner to learn to do, so we'll take the easy way out and use the Data Transfer wizard to get things set up for us. This wizard will create our source (SQL Server) and destination ...
Created on 10 November 2009
71. Practical SQL: Don't Be Afraid of Recursio
(SQL)
... final select, add the clause "where CMCORP = 0" and you'll get only the highest-level parent. Switch the inner join to "Corporate.ID = CMCORP" and now instead of parents, you'll get children.   And this ...
Created on 21 October 2009
72. Anchor Intelligence Reports Uncovering Huge Click-Fraud Ring
(New Products, Agreements and Trends)
... “Every buyer or seller of online advertising that uses the Anchor ClearMark system becomes an instant winner in the battle against bad actors," he said. "Rather than fighting the arms race against the fraudsters ...
Created on 12 October 2009
73. News Potpourri for the Week
(Channel News)
...  Other award winners of the IEEE 2009 Honors Ceremony include: Tingye Li, former division manager of AT&T Labs-IEEE Edison Medal Craig R. Barret, former chairman of Intel Corp.-IEEE Founders Medal Peter ...
Created on 26 June 2009
74. Rev Up "i" Reporting with SQL Server 2008 Reporting Service
(Microsoft)
...             SUM(sd.OrderQty) AS Qty,            SUM(COALESCE((UnitPrice*((1.0)-UnitPriceDiscount))            * OrderQty, 0.0)) AS LineTotal       FROM SalesPerson sp INNER JOIN  SalesOrderHeader ...
Created on 27 May 2009
75. Modest Attendance at COMMON Belies Underlying Energy
(Analysis of News Events)
... Bedenbender of Dot Foods (center) was the lucky winner of a camcorder at the ARCAD Software booth. Pictured with Corey are Joelle Cilley, ARCAD senior sales executive, and Philippe Magne, ARCAD CEO.  ...
Created on 02 May 2009
76. Practical SQL: Embedding SQL in Free-Format RPG
(SQL)
... JOIN rather than an OUTER JOIN. Because of that, I don't have to worry about NULL values, but I will lose any customer records that don't have matches. Such is the tradeoff between INNER and OUTER ...
Created on 24 February 2009
77. North Americans Enter IDUG's Global Search for XML Superstar
(Database)
... prizes along with broad personal and community recognition are coming to XML superstar contest winners in the U.S., Canada and globally after the competition closes," says Julian Stuhler, president ...
Created on 05 January 2009
78. TechTip: Creating Local OLAP Cube Data Files with DB2 Data
(DB2)
... & _ "      FROM Northwind.OrderDetails OD " & _ "INNER JOIN Northwind.Orders       OH ON OH.OrderID=OD.OrderID " & _ "INNER JOIN Northwind.Products     PD ON PD.ProductID=OD.ProductID ...
Created on 23 October 2008
79. Making the Best Use of V6 SQL OLAP Functions
(SQL)
... classes (Figure 9). This makes sense, given there are no local selection predicates for any of the tables. The inner join order is students, then activities and students, and then classes. To accomplish ...
Created on 21 October 2008
80. IBM and ISVs Promise Accelerated Software Delivery
(Development Tools / Utilities)
...  In related Rational Software news, IBM announced winners of the inaugural Rational Awards recognizing business partners for delivering outstanding value to clients and innovative approaches to solving ...
Created on 08 June 2008
81. IT Companies Shell Out for Charity as PGA Golf Tourney Opens in L.A.
(Channel News)
... forces this week to help fight inner-city poverty by sponsoring a viewing and reception area at the L.A. Open PGA Champions golf tourney. The sponsors are IBM Tivoli and IBM Business Partners AVNET, Azaleos, ...
Created on 14 February 2008
82. RPG and DB2 Will Sizzle at the Summit in Orlando
(RPG)
... other, and to avoid the hassles of doing your meals on your own, we host a welcome reception and dinner on the first evening, and also continental breakfast, lunch, and break refreshments for each of the ...
Created on 04 December 2007
83. SQL Subselect: Soup to Nuts
(SQL)
... In this example, it is called the primary or outer SELECT: SELECT  nbr,  nam,  sal,  dpt, FROM  emp  The second SELECT statement is the subselect (also called the inner SELECT): (SELECT  dpt  FROM  dep  WHERE  dnm  LIKE  'S%')  ...
Created on 06 November 2007
84. Book Review: DB2 9 Fundamentals
(DB2)
...  As a software engineer frequently working with database-related technology, chapters 5 and 6 are my personal favorites of the book. Sanders not only covers beginner's SQL syntax (CRUD statements, ...
Created on 23 October 2007
85. What's an RPGer to Do
(RPG)
... provide breakfast and lunch each day as well as a dinner event on the first evening, knowing that community-oriented meals provide opportunities to meet others and discuss your specific issues. Often, ...
Created on 06 September 2007
86. All Dressed Up and Nowhere to Go
(Analysis of News Events)
... of my house and not come back except to take me out for dinner since they will be making great money. Please, no angry mobs or tar and feathers! I am really on your side! Let me know what you think. ...
Created on 06 September 2007
87. FCC Tweaks Auction Rules on 700-MHz Wireless Broadband in Favor of Consumer Choice
(Standards Organizations)
...  At the same time, the coalition expressed disappointment that the FCC rejected proposals to require "wholesale open access" conditions on the auction winner. Such conditions promised to bring ...
Created on 07 August 2007
88. Nationwide Insurance Is Finalist in Innovation Award Competition
(Business Integration)
... for multiple purposes, we show an even higher return on investment for the software." Created by IBM and COMMON, the Innovation Awards showcase best practices within the System i market. Winners are selected ...
Created on 22 April 2007
89. "Hot Company" Award: Info Security Anoints Comodo for 200
(Channel News)
... providing end-users with effective and deployable protective solutions against the next generation of highly sophisticated and blended attacks. The evaluation used to select the winner of the 2007 Hot ...
Created on 05 February 2007
90. Comodo Presented Award by Security Publication
(Channel News)
...  The evaluation used to select the winner assessed each vendor's entrepreneurial spirit, executives with relevant experience, understanding of the security market, products and solutions that are positioned ...
Created on 05 February 2007
91. Server Technology
(Commentary)
... extreme wardrobe malfunction risk she's taking? For seven years running, she's been the grand-prize winner on the top-rated Fox network program, America's Greatest Floozy. She'll go out with anyone...even ...
Created on 25 January 2007
92. RPG World
(RPG)
This conference in Las Vegas is a sure winner.For the last several years, Jon Paris, Susan Gantner, Paul Tuohy, and I have produced the popular RPG World conference. This year, it's scheduled for May 15 ...
Created on 18 April 2006
93. Investigating Costs
(Commentary)
... that, even after considering the exchange rate, the Canadian Firearms Centre beat the FBI in the over-budget race, although I'm not suggesting that any country should be proud to be the winner of that competition. ...
Created on 30 March 2006
94. Slicing and Dicing RTVDIRINF Output
(CL)
... value for each object. The SQL statement is as follows: SELECT QEZDIRNAM1, QEZOBJNAM, DATE(QEZCHGTIMA) AS DATE, DAYS(CURRENT_DATE)-DAYS(QEZCHGTIMA) AS DIFFERENCE, QEZDTASIZEFROM EXMPLIB.EXAMPLED AS D                    INNER JOIN EXMPLIB.EXAMPLEO AS O ON D.QEZDIRIDX = O.QEZDIRIDX     ...
Created on 07 March 2006
95. The New Alchemy
(Commentary)
... pension, sell your house, take all of your savings, go to eBay, buy every game token and weapon that you can possibly can, unilaterally declare yourself the game's winner, and then grab a bite to eat, meet ...
Created on 20 October 2005
96. "I Used to Be an App Server
(Development Tools)
...  The air is getting thinner. The next level of SOA adoption is called "enterprise-wide SOA." This is where the IT department undergoes a complete shift in culture--from the way applications ...
Created on 31 July 2005
97. TechTip: A Review of SQL Multi-File Result Sets
(SQL)
... to the data in B1. The tells us which rows are returned. And here are the join clauses: INNER This default syntax selects only rows from A that have matching rows on B. This is the result set, ...
Created on 28 July 2005
98. Make Your Career Shockproof
(General)
... applying good judgment, comparing notes with colleagues, and paying attention to only those unbiased pundits with a good track record will significantly increase your chances of picking the winners. Despite ...
Created on 06 March 2005
99. Weaving WebSphere: WebSphere and .NET, and What's a Longhorn, Anyway
(Development Tools)
... and their philosophies. Unlike the iSeries, which is a clear winner over any other platform for business transactions, there is no such clear distinction between J2EE and .NET. Therefore, you have to take ...
Created on 07 November 2004
100. PM Certified: To Be or Not to Be?
(General)
... to determine which choices to keep and which ones to eliminate. Talking with others who had recently taken the exam helped to give me the exam perspective. The PMI chapter dinner meetings are great opportunities ...
Created on 17 October 2004