WebSphere Strategies: Finding the Value in SQL and WebSphere

[Search400.com]

Title: WebSphere Strategies

May 20, 2004 Published by  Search400.com WebSphere Strategies IN THIS ISSUE: Finding the Value in SQL and WebSphere Read from a specific member of a physical file Execute SQL via a standard command interface Calling an SQL stored procedure SQL on the iSeries Words Of The Day -- SQL and WebSphere SPONSORED BY:  Search400.com Product and Vendor Guide The Buyers guide is one of the most comprehensive directories of vendor and product information on the Web. It covers a wide range of areas for your research needs, including Application Dev, E-Commerce Solutions, Security and more. Simply search by topic, company name or keyword and you have access to complete vendor and important product information without having to comb through multiple sites. Click Here! Finding the Value in SQL and WebSphere [Search400.com] by Paul Holm and Colin Slade A frequent problem encountered in Web application development is when attempting to allow optional selection criteria. Many applications allow users to select records based on selection criteria. The big trick, however, is to get the search to ignore values in the search if the user does not specify them. This article details how this type of search can be coded. MORE INFO: View other tips by Paul Holm Read from a specific member of a physical file [Search400.com] A user was trying to read from a specific member of a physical file. He tried using both SQL through the JDBC and the Java Toolbox for iSeries provided by IBM, but no luck. Site expert Jim Mason pointed out the step he was missing. Execute SQL via a standard command interface [Search400.com] This is a command/program set that user Herb Bujak has been using since V3R2. The features that make it different from other utilities are the optional printed log, an interactive warning if there's no WHERE clause (update/delete) and the ability to syntax check (no execution). Calling an SQL stored procedure [Search400.com] A user needed help calling an SQL stored procedure written for a MS NT server to update a server table. Site expert Jim Mason was on hand with some advice. SQL on the iSeries [Search400.com] One user wondered if SQL was fast on the iSeries and what its advantages and disadvantages were. Site expert Jim Mason explained. TOPICS: Words Of The Day -- SQL and WebSphere Expand your technical vocabulary and knowledge by visiting our iSeries glossary. Impress your co-workers and be a know-IT-all! Learn more about SQL and WebSphere. TOPICS: WebSphere/Web Development Forum -- Interact with your peers Looking for a great place to mingle with your peers, ask or answer Web-related questions, or just catch up on the latest info? Check out Search400.com's WebSphere/Web Development Forum. TOPICS: User poll: IBM's new pricing model What do you think of IBM's new pricing model, which significantly lowers the price of many models of iSeries, including the new i5? 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] ABOUT THIS E-NEWSLETTER This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "WebSphere Strategies": Go to unsubscribe: http://search400.techtarget.com/u?track=NL-182 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 MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494