=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SEARCH400.COM | Today's news Oct. 9, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- FROM OUR SPONSORS:
Exchange EDI directly over the Internet - ZMOD Exchange EDI-INT http://search400.com/r/0,,6455,00.htm?trailblazersystems =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- IN THIS ISSUE | Today's Highlights 1. FEATURES AND TOP STORIES - Featured Topic: iSeries Regatta servers - News: Linux-only Regatta servers possibility - News: CRM vendors must tailor to midmarket - Expert Advice: Basic SQL programming advice - Forum Advice: Client Access unattended download 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free Book Excerpt: AS/400: System, Utilities, Database, and Programming, 2/e - Current Poll: How long have you been working on the AS/400? - Tips Exchange: Win a $50 Amazon.com gift certificate - OS/400 Discussion Forum: Interact with other administrators - The Missing Link: True IT blooper: Compaq Portable code red _________________________________________________________________ *************** SPONSORED BY Trailblazer Systems ************** ***Headed to COMMON? Visit Trailblazer Systems, Booth #206**** You're invited for coffee at COMMON in Denver, October 13-15, Booth #206. LEARN how fast you can be EXCHANGING SECURE EDI transactions with trading partners on the Web with your AS/400. Our ZMOD Exchange products support any protocol - FTP, SMTP, HTTP, EDI-INT - with any security method - PGP, SSL/TLS, S/MIME, SSH. Get the power to exchange any transaction - any way. For more information, visit http://search400.com/r/0,,6455,00.htm?trailblazersystems ************************************************************ ISERIES REGATTA SERVERS | Search400.com Featured Topic Thanks to the Regatta i890 server, IBM is making headway into the high-end server market. Learn more about this powerful server and how it compares to others.. >> CLICK for current Featured Topic: http://search400.techtarget.com/featuredTopic/0,290042,sid3_gci854833,00.html >> CLICK for previous Featured Topics: http://search400.techtarget.com/featuredTopics/0,290043,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- OTHER STORIES In addition to the headlines below, others are available on our news page. >> Full Stories: http://search400.techtarget.com/news/0,289141,sid3,00.html LINUX-ONLY REGATTA SERVERS POSSIBILITY | Midrange Server IBM might be readying a set of Linux-only Power4-based "Regatta" servers to take on the Unix installed base, including Big Blue's own AIX base. CRM VENDORS MUST TAILOR TO MIDMARKET |iSeries Network CRM vendors are finally recognizing the untapped potential of the midmarket and adjusting their products and sales strategies accordingly. (Free registration to this site required.) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- ADDITIONAL NEWS HEADLINES All headlines above and below are available on our news page >> Full Stories: http://search400.techtarget.com/news/0,289141,sid3,00.html -- GOLDMAN CUTS IBM 2003 EARNINGS VIEW (Reuters) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BASIC SQL PROGRAMMING ADVICE | Expert advice: Search400.com Dear Ask the Expert, We are trying to use the "With common table expression" to use the result set from the first SQL in the second SQL and then return two results sets. Sometimes, the files from the first SQL are very large and this select already narrows the data down for the second select. We have read a lot, but there is no good example of the common table expression and how to use it. Application development expert John Brandt offers some advice. >> CLICK here to view the complete expert Q&A: http://www.search400.com/ateQuestionNResponse/0,289625,sid3_cid493970_tax285217,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CLIENT ACCESS UNATTENDED DOWNLOAD | Forum advice: Search400.com One user writes, "When doing an unattended file transfer, I'm getting the message "CWBTF0004 - no data was matched to the specified options". I think this is happening when there are no records in the file being downloaded. Is there a way to block this message from appearing? It stops the process and waits for an operator to respond. I have the 'display warning messages during transfer' disabled." One suggestion was made. Do you have any others? >> CLICK here to respond to this discussion thread: http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84638/2694 ___________________________________________________________________ ___________________________________________________________________ IMPORTANT FEATURES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE BOOK EXCERPT | AS/400: System, Utilities, Database, and Programming, 2/e Search400.com would like to offer our members the opportunity to download the first chapter of AS/400: System, Utilities, Database, and Programming, 2/e written by George Lin and Gayla Stewart for free. AS/400: System, Utilities, Database, and Programming, 2/e is a single source for many of your AS/400 needs. Topics covered include Java, TCP/IP network, Internet and Web with the AS/400, Internet security and firewalls for AS/400, HTTP server, Lotus Notes and Domino for AS/400, SAP on the AS/400, and ILE. >> DOWNLOAD the chapter: http://search400.techtarget.com/whitepaperPage/1,293857,sid3_gci855315,00.html >> BUY the book: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=0130830674&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TAKE OUR POLL | Search400.com Reader Survey How many years have you been working on the AS/400? >> CAST your vote: http://www.search400.com/poll =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN A $50 AMAZON.COM GIFT CERTIFICATE | Submit your tip to win This month we're giving away a $50 Amazon.com gift certificate. Buy yourself something that you really want, rather than settling for something less. You can choose from several categories of items such as books, music, videos, electronics, gardening, toys, housewares and more. Submit a winning tip and treat yourself to something you really want at Amazon.com! Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsSubmit/0,289485,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= OS/400 DISCUSSION FORUM | Interact with other administrators Are you looking for advice on OS/400 issues? Join your peers in our OS/400 forum to ask and answer questions about V5R1, installation, implementation, security and much more. http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]^[email protected] >> RECENT DISCUSSION THREADS you may find of interest: * Using authorization list when LMTCPB=yes http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84638/2695 * Block access to the iSeries option and print crystal report output on the iSeries printer http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84638/2681 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE MISSING LINK | True IT blooper: Compaq Portable code red The most recent newcomer to "Oopsburgh" learned the hard way that too much disk space can be a bad thing -- especially when the file that basically runs the computer has been tossed out with the rest of the "trash." Want an analogy? Think of a doctor telling you that a good way to lose weight would be to have your brain removed! Source: SearchWindowsManageability.com http://searchwindowsmanageability.techtarget.com/originalContent/0,289142,sid33_gci853662,00.html >> RECENT missing link stories you may enjoy: http://search400.techtarget.com/bestWebLinks/0,289521,sid3_tax292189,00.html ___________________________________________________________________ *********************SEARCH400.COM CONTACTS************************ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. KATE EVANS-CORREIA, senior news editor (mailto:[EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. _______________________________________________________ **********************ABOUT THIS NEWSLETTER************ Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002 TechTarget. All rights reserved. Unsubscribe from 'Daily News' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
