SEARCHDATABASE.COM | Database Administrator Tips December 18, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Oracle vs. DB2: Examining the differences - Quest Software http://searchCRM.com/r/0,,8525,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Fast access to DB2 on the iSeries with PHP - SQL Server: Word wrapping with T-SQL - Oracle: Refresh variable only after a commit - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Oracle question? Ask Brian ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Are you managing applications on both Oracle and DB2 databases? Quest Central(tm) can help! Download the free presentation, "Oracle vs. DB2: Examining the Differences" to learn distinctions between basic components and terminology, architectural layout, storage management, logging and backup/recovery options, and more. Download the presentation today and get your free trials of Quest Central for Oracle and DB2 at http://searchCRM.com/r/0,,8525,00.htm?questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: FAST ACCESS TO DB2 ON THE ISERIES WITH PHP | Alex Corretge i Bergua The author has a dream: Access DB2 on the iSeries with an Web-based application written in PHP. He used the simple steps in this tip to make that dream a reality. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci868255,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WORD WRAPPING WITH T-SQL | Andrew Novick There are times when there isn't a suitable front-end that can perform a word wrapping task and so it has to be done by SQL Server itself. Here is a UDF, called udf_TxtN_Wrap, that wraps a nvarchar string at a given line length. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci869491,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REFRESH VALUE OF A GLOBAL VARIABLE ONLY AFTER COMMIT | Murali Krishna Through any front-end applications it's easy to control the value of any variable via re-initialization at any point. But what happens if you want to reinitialize the value at the SQL prompt or at the database level? Here's how to do it in Oracle. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci854788,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CONNECT TO AN SQL SERVER FROM THE ISERIES | Santosh Prasad http://www.searchDatabase.com/tip/1,289483,sid13_gci868252,00.html A quick tip about how to connect to a SQL Server database from DB2 on AS400/iSeries using Java Tool Box. TABLESPACE USAGE VIEW | Andrew Barringer http://www.searchDatabase.com/tip/1,289483,sid13_gci867509,00.html This SQL Server view allows you to easily see the top 10% by Row Count, Space Used, etc. This is useful for answering the question "what's taking up all the space in my database?" CONTROL ACCESS TO ORACLE OBJECTS FROM SQL*PLUS | Murali Krishna http://www.searchDatabase.com/tip/1,289483,sid13_gci867728,00.html The PRODUCT_USER_PROFILE table can be used to control users' access to various Oracle objects from SQL*Plus. Here is how to implement it. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL Server: Equivalent of Oracle's TO_CHAR function http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid507747_tax285648,00.html DB2: Inserting multiple rows into a DB2 table http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid506741_tax285651,00.html Oracle: PL/SQL UTL_SMTP procedure to send e-mail http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid507746_tax289341,00.html DB2: NULLs and storage space http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid506457_tax285651,00.html SQL Server: Restricting access when *.mdf, *.ldf files are copied http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid507748_tax285648,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE QUESTION? ASK BRIAN | SearchDatabase.com Featured Topic Brian Peasland is a certified Oracle DBA with 15 years experience in the trenches. He's been through it all and is available to answer your burning Oracle questions. Browse the nearly 500 he has already answered inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci868897,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (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, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
