========================================= SEARCH400.COM ADMINISTRATOR TIP May 2, 2001 More administrator tips at http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f8,00.html ========================================== SPONSORED BY: FORMation mg ========================================== Workflow Management and Distribution Software FORMation mg is the AS/400 and iSeries leader in e-document form Design and Distribution. Integrate and manage spool and database files within your enterprise network. Automatic conversion to PDF, RTF, HTML and other popular formats. FORMation's software suite will provide your company with a one-stop-one-solution for workflow management, and PC or wireless spool file and document delivery throughout your entire network. "Eliminate the cost of pre-printed checks and forms forever". Download free 30-day evaluation: http://www.as400email.com/mc Call: 800-693-3933, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] COMMON, N.Orleans - Booth 933 ----------------------------------------- TIP OF THE MONTH WINNERS ----------------------------------------- Congratulations to Larry Pepin, winner of April's tip prize, a Garmin eMap! Larry will be inducted into our Hall of Fame for his winning tip: A new and improved find command, http://www.search400.com/tip/1,289483,sid3_gci543134,00.html Kudos to our runner-up winners: Sudhakar Kunji, Mary Milliron and JR Friedman. NEW May PRIZE! Submit a tip and let the votes determine the winner of this month's prize, a Toshiba DVD player! http://search400.techtarget.com/tipsSubmit/1,289485,sid3,00.html ========================================== Save your bacon with SQL By Richard A. Davis, search400 member Reader Richard A. Davis offers a way to do some editing on source members when you don't have the normal tools available. Sometimes you just HAVE to edit a source member, but the machine does not have SEU installed, nor is Operations Navigator available. It happened to me, and I was desperate. WAIT! Isn't every, virtually every file on the 400 part of the DB2 database? Sure enough, you can use interactive SQL to update source member records. 1. Make a copy of the member first just in case you mess something up: CPYF FROMFILE(APP43/QSQLSRC) TOFILE(APP43/QSQLSRC) FROMMBR(L43S2) TOMBR(L43S2_SAVE) MBROPT(*ADD) 2. Choose the source member you want to update by overriding the file: OVRDBF FILE(QSQLSRC) TOFILE(APP43/QSQLSRC) MBR(L43S2) 3. Determine the source statement that you want to modify using SQL to display the member and note its SRCSEQ number: SELECT * FROM QSQLSRC 4. Make sure you have the right record number before you try to make the change: SELECT * FROM QSQLSRC WHERE SRCSEQ=0046.00 5. Then do the update: UPDATE QSQLSRC SET SRCDTA='CREATE INDEX XAK1PROP_HDR ON PROP_HDR' 6. Exit SQL and use Display Physical file Member to be sure the change was what you wanted: DSPPFM FILE(APP43/QSQLSRC) MBR(L43S2) It would be very tedious to make more than a few changes this way, but when you really need to and 5769-ST1 is installed, it can save your day! ---------------------------------------------------- OTHER DEVELOPER TIPS ---------------------------------------------------- Search400 members also submitted the following administrator tips recently: Run remote command exit program Submitted by Mary Milliron http://search400.techtarget.com/tip/1,289483,sid3_gci546334,00.html Copy multiple spool files at one time Submitted by Chris Seager http://search400.techtarget.com/tip/1,289483,sid3_gci546328,00.html What is hogging our system? Submitted by Mike Poweleit http://search400.techtarget.com/tip/1,289483,sid3_gci547516,00.html How to take entire system backup and monitor disk status Submitted by Ramakrishna Chavalla http://search400.techtarget.com/tip/1,289483,sid3_gci547533,00.html Object comparison Submitted by Hugh Woods http://search400.techtarget.com/tip/1,289483,sid3_gci547508,00.html What do you think of these tips? Love them or not, we want to know. Click over to check them out and rate them. Or e- mail us at mailto:[EMAIL PROTECTED] to sound off or submit a tip of your own. ----------------------------------------------------------- SEARCH400 ONLINE EVENT ----------------------------------------------------------- Boost Domino Performance on your iSeries 400 Join us for a Live Expert Q&A session on May 10 at 2pm EDT (18:00 GMT) with Kim Greene from Kim Greene Consulting. Kim is an independent consultant who specializes in Domino for iSeries consulting, education and performance. Log on to this session to discover specialized tips and techniques to fine-tune your Domino environment and get the most optimal performance on the iSeries 400. If you run Domino on the iSeries, don't miss this exclusive event! Log on Thursday, May 10 at http://search400.techtarget.com/onlineEvents/0,289675,sid3,00.html --------------------------- FEATURED BOOK --------------------------- Title: iSeries and AS/400: SQL at Work Author: Howard F. Arner Description: Whether you are just learning SQL or are an experienced user, this book will show you how to make SQL work in your business environment. Beginners will benefit from the chapters that teach SQL basics by relating them to the concepts beginners already know. For those more experienced in SQL, this book offers practical, solid information on performance tuning of SQL statements, the AS/400 query optimizer, advanced SQL capabilities, and special tips and tricks specific to the AS/400. http://www.digitalguru.com/dgstore/product.asp?isbn=1583470247&ac_id=55 --------------------------------------------------- To Remove your email address from the distribution list for this specific newsletter "Reply" to this message with REMOVE in the subject line. You will receive an email confirming that you have been removed. To Remove yourself from additional distribution lists or to update your preferences, go to the search400.com registration page at: http://search400.techtarget.com/register
