Administrator Tip: Write results of SQL Select statement to an outfile

[Search400.com]

Title: Administrator Tips

February 16, 2005 Published by  Search400.com    Administrator Tips Issue Sponsored By:   >  Data Center Decisions IN THIS ISSUE:   >  Write results of SQL Select statement to an outfile   >  Running multiple SQL statements   >  Use SQL to Select data directly to a CSV file   >  Poor response time when running a SQL Select statement   >  Set SQL outfile column names   >  i5 iSeries capacity planning Write results of SQL Select statement to an outfile [Search400.com] by Ron Turull Outfiles are status quo on the iSeries, but did you know that SQL can produce them intrinsically? Following these steps, you can have the results of a Select statement written to a database file. MORE INFO: > View previous tips by Ron Turull     Attend Data Center Decisions 2005 Join us in New York for Data Center Decisions 2005. Learn about the latest technologies for the data center, get top advice from industry experts & win a new Mercedes SLK. Register today.     Running multiple SQL statements [Search400.com] Search400.com member Linda Fiato says you can run more than one statement in a single-source member, just put a semicolon at the end of each statement -- except the last. Use SQL to Select data directly to a CSV file [Search400.com] This command from Search400.com member Herb Bujak directs the results of any valid SQL Select statement directly into a CSV file in the IFS and, optionally, insert a column heading row based on the file/field descriptions of the result set. Poor response time when running a SQL Select statement [Search400.com] A user wrote in and said he was having a problem in which he was getting a significant variance in response time when running a SQL Select statement over a view. Search400.com expert Kent Milligan took a look and offered some advice. Set SQL outfile column names [Search400.com] Search400.com member Deborah Bergeron shows you how you can control the column names used when creating an outfile from SQL. This is especially useful when you have the same source column from two different files, fields with long alias names, or when the output contains calculations. TIP CONTEST:  Enter to win a Garmin eMap With the Garmin eMap, you'll never be lost again. Send in your tech tip -- programmer, administrator, security or WebSphere Strategies -- for a chance to receive this cool gadget. Don't forget to go in and rate our recent tips: Quickly copy any source member from one iSeries to another Copying objects from one iSeries to another How to encapsulate SNA over TCP V5R3 view disk IOA cache battery expiration Find wasted space in files ITKNOWLEDGE EXCHANGE (ITKE):  i5 iSeries capacity planning Recently an ITKnowledge Exchange (ITKE) member asked about replacing his existing iSeries machines with i5 servers. Thankfully, fellow iSeries users jumped in on the conversation and offered him some good advice. SURVEY:  User poll: IBM/SAP Lovefest? IBM seems to be courting SAP. Is this a match made in heaven or a partnership of convenience? Vote now   Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED]     Free E-Newsletters! Select e-newsletters you would like to receive via e-mail!  Search400: Today's News  Search400: Programmer Tips  Search400: WebSphere Strategies Not a Member? We'll activate your membership with your subscription.   This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. To unsubscribe from "Administrator Tips": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?cid=504644&lid=430676&track=NL-176&ad=504644 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search400 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494