=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCH400.COM | Top Expert Advice Aug. 20, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS: New Search400 Salary Survey: http://search400.techtarget.com/salarySurveySkill/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Answers to your technical questions and expert advice on using DB2/400 and DB2 UDB for the iSeries. More Q&As: http://search400.techtarget.com/ateAnswers/0,289620,sid3_tax285216,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. Expert Questions on DB2/400 and DB2 UDB - Combining columns on a DB2 table - Create one DB2 file from multiple stream files - The impact of re-using deleted records 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: Database issues resolved - News: DB2 UDB enhancements will impress iSeries users - Best Web Links: DB2/400 and DB2 UDB - Featured Book: DB2 -- The Complete Reference - Tip Exchange: Win a Beetle CD stereo __________________________________________________________________ ***************** New Search400.com Salary Survey **************** Are you paid enough? Take our new salary survey to see where you rank with other iSeries professionals. Our new interactive salary survey allows you to get instant results that are tailored to your needs. You can sort the immediate results by gender, title, salary, industry and more. http://search400.techtarget.com/salarySurveySkill/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- COMBINING COLUMNS ON A DB2 TABLE | by Pascal Jacquemain There are three separate columns on a DB2 table that have to match the corresponding input info that I have to pull off the rows I need. The input data is combined into one element. Can the three columns be combined into one in the select statement? >> Read Pascal's answer: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid482916_tax285216,00.html >> Check out Pascal's other Q&As or submit your own DB2/400 or DB2 UDB question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_tax285216,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATE ONE DB2 FILE FROM MULTIPLE STREAM FILES | by John Brandt How do you copy multiple stream files into one stream file in order to create one DB2 file? >> Read John's response: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid474399_tax285216,00.html >> Check out John's other Q&As or submit your own DB2/400 or DB2 UDB question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid457190_tax285216_idx2,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE IMPACT OF RE-USING DELETED RECORDS | by Pascal Jacquemain If I use 're-use deleted records' on a database file, what impact on performance should I expect? If the performance is not going to suffer too much, do I still have to run reorg on the file on a regular basis or is it 'cleaner' automatically by using spaces created by previously deleted records? >> Read Pascal's response: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid473545_tax285216,00.html >> Check out Pascal's other Q&As or submit your own DB2/400 or DB2 UDB question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_tax285216,00.html _____________________________________________________________ ::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS :::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE ISSUES RESOLVED | Featured Topic To make the best decisions when it comes to data management you'll need to keep up on emerging technologies, such as DB2 UDB, data management tools, integration, BI, and much more. Let us help you find the resource you'll need. http://search400.techtarget.com/featuredTopic/0,290042,sid3_gci843202,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 UDB ENHANCEMENTS WILL IMPRESS ISERIES USERS| News Database enhancements, such as user-defined table functions, improved encoded vector index builds and a new query optimizer, provide some of the most compelling reasons for iSeries shops to consider a V5R2 upgrade. http://search400.techtarget.com/newsItem/0,289139,sid3_gci845213,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 UDB FOR THE ISERIES | Best Web Links Have a question about using DB2 UDB for the iSeries? Chances are you'll find the answer here. This section is full of articles advising you of the best methods for accessing data, replicating data, warehousing and mining data -- and much more. http://search400.techtarget.com/bestWebLinks/0,289521,sid3_tax286869,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FEATURED BOOK | Search400.com's Bookstore Title: DB2: The Complete Reference Authors: Paul Zikopoulos and Roman Melnyk Get an inside look at the new version of DB2 using this in-depth reference. You'll get detailed coverage of SQL keywords and DB2 data structures, and learn to use DB2 to create powerful e-business solutions. Whether you're a developer or an administrator, you'll find this to be an invaluable resource. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=0072133449&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN A BEETLE CD STEREO | Submit your Tip to Win This month we're giving away a Beetle CD stereo. The stereo has dual stereo speakers in the wheels and a CD tray that slides out from the bumper. Built in FM digital tuner and CD play controls are accessed from under the hood. Send in your tip -- programmer, administrator, security or WebSphere Strategies -- you could be our next winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsSubmit/1,289485,sid3,00.html _____________________________________________________________ ::::::::::::::::::: SEARCH400.COM CONTACTS ::::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. _____________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. _____________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. _____________________________________________________________ KATE EVANS-CORREIA, senior news editor (mailto:[EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. _____________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. Unsubscribe from 'Updates on new site content' - 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."
