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

Total: 127 results found.

Search for:
Search Only:

Page 3 of 3

101. Microsoft Computing: Contest Programming
(Microsoft)
... that has solved the most problems wins. If more than one team has the same number of solved problems, the total minutes taken determines the winner. The fewer minutes taken to solve the problems, the better.Contestants ...
Created on 18 April 2004
102. Query Remote Database Tables from the iSeries Using SQL and Java
(SQL)
Many iSeries shops host additional database servers, including Oracle, SQL Server, and MySQL. A common solution to integrating heterogeneous data consists of nightly data transfers and batch processing ...
Created on 04 April 2004
103. Do You See UCCnet?
(Commerce - Other)
... digit. An Interleaved 2 of 5 (I2of5) carton ID number can be used as is for the GTIN. This item can represent a case, pallet, inner pack, master pack, etc. In all of these cases, the fourteenth digit represents ...
Created on 01 February 2004
104. TechTip: SQL GetMiles Function
(SQL)
... ORDERS INNER JOIN CARRIERS ON ORDERS.CARR = CARRIERS.CARRA slightly more complicated example uses the function as part of an ORDER BY clause to return the data based on distance in miles. The statement ...
Created on 07 December 2003
105. SUSE Linux: Enjoy the Movie, Hate the Novell-ization?
(Commentary)
... and a proclivity for forgettable acronyms. No wonder it moved in for the customer kill! One comparative look between Windows NT and a NetWare administrator's interface, and the winner was easy to discern. ...
Created on 16 November 2003
106. Weaving WebSphere: WebSphere Express and Tomcat
(Development Tools)
... WebSphere Express is better than previous versions of WAS and much better than Tomcat. And the Winner Is... So, if I were to summarize the results of this comparison, I'd get the following (a plus sign ...
Created on 07 September 2003
107. Java Journal: Encryption
(Java)
... wheel's inner circle, in addition to an arrow that pointed from the hole to the rim. So to encode your secret message you would dial the inner wheel to point to the letter you wanted to encode and then ...
Created on 27 July 2003
108. The Way We Word: File Transfer for Dummies
(Microsoft)
... _       & "SUM(T02.ILQTY) AS ILQTY " _     & "FROM BPCS405CDF.SIHL60 T01 " _     & "INNER JOIN BPCS405CDF.SILL02 T02 " _      & "ON T01.SIINVN = T02.ILINVN " _     & "WHERE T01.SIPRF = '" & pcSelect & "' " _     & "AND (SUBSTR(ILPROD,1,6) BETWEEN '110101' AND '901301') " _     & "GROUP BY T01.SIPRF, SUBSTR(T02.ILPROD, 1, 9)"     Set rsInvoiceData = New ADODB.RecordsetrsInvoiceData.Open SQL, cniSeries, adOpenStatic, adLockReadOnlylRow = 1Do While Not rsInvoiceData.EOF   Cells(lRow, 1) = rsInvoiceData("STYCLR")   Cells(lRow, 2) = rsInvoiceData("ILQTY")   rsInvoiceData.MoveNextLoop[snip]Application.ScreenUpdating = TrueMsgBox "Your selected data has been extracted!", _ ...
Created on 15 December 2002
109. The Way We Word: OLE! VBA and ADO Bring iSeries Data to Excel
(Microsoft)
... we need to populate it with the data we want to use. Here's how we do that: Application.StatusBar = "Inserting availability records..."''Insert records into the table created in the previous step.'The records inserted contain the current 'on hand, and PO dates. 'Note that on-hand is a calculated field: Opening balance'                                       + receipts'                                       - issues'                                       + adjustments'                                       - minimum balance'                                       -----------------'                                         On Hand'sSQL = "INSERT INTO USERFILES.JAVAIL " _     & "SELECT T02.IPROD, T02.IDESC, " _     & "(T02.IOPB + T02.IRCT - T02.IISS + T02.IADJ - T02.IMIN) " _     & "AS ONHAND, "      & "T01.WP01DT, T01.WP02DT, T01.WP03DT, T01.WP04DT, " _     & "T01.WP05DT, T01.WP06DT, T01.WP07DT, T01.WP08DT, " _     & "T01.WP09DT, T01.WP10DT, T01.WP11DT, T01.WP12DT, " _     & "FROM USERFILES.WAVAIL T01 " _     & "INNER JOIN PRODUCTION.IMAST T02 ON T01.WSKU = T02.IPROD"    iSeriesDataCN.Execute sSQL ...
Created on 16 June 2002
110. TechTip: Record Selection and Query/400
(General)
... the join criteria, join this file to the file containing the production data over common date fields. If the join is an inner join (i.e., the join type is 1, Matched records), add it anywhere to the list ...
Created on 14 January 2002
111. Crunching AS/400 Data with OLAP Cubes and Excel 2000
(Microsoft)
...  CS.CompanyName, CS.Country, CS.Region, PD.ProductName, SP.CompanyName , CT.CategoryName, OH.OrderDate FROM Northwind.OrderDtls ODINNER JOIN Northwind.Order OH ON OH.OrderID=OD.OrderIDINNER JOIN Northwind.Products ...
Created on 31 December 2000
112. Of Shoes and SQL Subqueries
(SQL)
... subselects, inner queries, or inner selects. A subquery is a nested query within another query. You can even nest a subquery within another subquery. A subquery may be used in the WHERE, HAVING, or FROM ...
Created on 31 December 2000
113. V4R5: Of Wizards and Korn Shells
(IBM i (OS/400, i5/OS))
... AS/400. Visual Explain will show you every step of the query optimization—e.g., opens, closes, outer joins, inner joins—all in an easy-to-view GUI. Experienced query users will be able to view ...
Created on 30 June 2000
114. Mapping Your Data to XML the Easy Way
(Web Languages)
... becoming the universal tool for mapping data between databases. It is more than a markup language, as Mark Johnson states in his article “XML for the absolute beginner” (www.javaworld.com/javaworld/ ...
Created on 29 February 2000
115. Picklists on the Fly!
(RPG)
... joined. You also need to specify the type of join; valid types are I, L, E, and C for inner, left, exception, and cross, respectively. The “join,” “from,” and “to” fields ...
Created on 30 November 1999
116. The Global Group
(Collaboration & Messaging)
... aspect of modern business, is global, and those strategists who realize this will be the winners in the race to provide multinational rather than local or regional solutions. While Microsoft seems to be ...
Created on 31 August 1999
117. Click Here for Powerful Data Transfer
(General)
It’s Wednesday morning. Your sales director walks into your office and says, “What would it take for me to come in first thing tomorrow morning, click a button, and see the total of yesterday’s ...
Created on 30 April 1999
118. Set-at-a-time Power Programming
(General)
... hope more shops will begin to use it as a result of reading this article. Now let’s look at a couple of examples of set-at-a-time programming. When Is an Outer Join Not an Outer Join? Inner joins ...
Created on 30 June 1998
119. Is IBM/Lotus the Next Microsoft?
(Commentary)
... 4 Release 2 was destined to start rumors long before its details were fully disclosed. (See "In Platform Politics, IBM's AS/400e Model 170 Is a Winner" and "OS/400 V4R2: The Real Version 4 Rears Its Head" ...
Created on 28 February 1998
120. Use Performance Tools to Avoid Application Performance Surprises
(IT Infrastructure - Other)
... of the changes as part of the software upgrade plan, and execute the plan faithfully. Every time I've seen it done this way, the upgrade winds up a winner and so do the system administrators. Jim Oberholtzer ...
Created on 28 February 1998
121. Getting the Most Performance from ODBC Query and Development Tools
(APIs)
... C, etc... WHERE many complex inner and outer joins are specified The fact that you didn't have to write this complex query yourself sure is nice, but is this statement actually what the tool is processing? ...
Created on 31 March 1996
122. Visual Basic Database Access Made Easy
(Visual Basic)
... sample application is displayed as shown in Figure 2. To navigate through the records in the table, you click on the arrow buttons of the data control. The inner arrows move you backward and forward through ...
Created on 29 February 1996
123. An Introduction to SQL Subqueries
(SQL)
... called an inner query or a nested query). An SQL subquery is a SELECT statement embedded in the WHERE or HAVING clause of another SQL query. It can contain any SQL clauses except for ORDER BY and UNION ...
Created on 31 January 1996
124. X.400 E-mail Standards in an AS/400 World
(IBM i (OS/400, i5/OS))
... fax, voice, graphics, and video. It's a little soon to declare a winner in the E-mail sweepstakes, but X.400 will at least be an important gateway protocol for exchanging mail between competing systems. ...
Created on 31 May 1995
125. Free SQL and Improved Query Through Query Manageme
(SQL)
... friendly report generator that allows the inner and outer join of up to 10 database files. Like SQL/400, albeit with less power, Query/400 has record selection, calculated fields and record sequencing. ...
Created on 31 January 1992
126. Flexible Reporting with Open Query File
(Business Intelligence)
... one file. Program SLSC5 in 7 joins four files, SLSHIST, CUSMAST, ITMMAST, and REPMAST, with an inner join, and selects joined records for processing if they fall within a certain period of time (determined ...
Created on 31 May 1990
127. 5250 Data Stream Programming
(General)
Getting complete control over your 5250 display by Craig Pelkie Suppose you are in your kitchen, cooking dinner. You decide it would be nice to have some canned string beans, so you get a can, run ...
Created on 31 March 1990