fhs
Volume 9, Number 12 -- March 24, 2009

SoftTree Updates SQL Assistant

Published: March 24, 2009

by Alex Woodie

SoftTree Technologies recently launched a new release of SQL Assistant, a programming tool designed to speed the programming of SQL. With version 4.6, the tool gains new time-saving devices, including real-time syntax lookup and visual bookmarks for code editors.

Writing SQL code can be a pain in the you know what. Many application developers avoid getting their hands dirty with low-level SQL programming by basically outsourcing its generation to automated development tools. One of those tools is SQL Assistant, which SoftTree says supports all major databases, including DB2 for i (DB2/400).

SQL Assistant cuts development time through an array of handy features, such as Intellisense code completion, using historical coding patterns to suggest commonly used queries, and providing real-time checks for syntax and spelling errors. Overall, the product has the capability to reduce the number of keystrokes required to write SQL statements by a factor of three, SoftTree claims.

With version 4.6, the Staten Island, New York, company has added several new features. One of these is support for visual bookmarks, which it calls an "obscure and rarely used" function found in many code editors. By tapping into the visual bookmarks function, SoftTree expects to help users find what their looking for faster. The feature is so useful, even seasoned coders "will grow to love and use [the function] often," SoftTree says.

Support for real-time syntax lookup and in-place prompts in version 4.6 will help eliminate a coder's need to find answers in printed manuals, or browse the Web for electronic manuals. Users can also now use the product's mouse-over feature to view hints for procedure and function parameters, or to view tables and columns for objects whose names contain spaces and special symbols, the company says.

Version 4.6 enables developers to compare code in their editors against code residing in databases, files, or other editors, thereby streamlining the error-checking processes, SoftTree says. Finally, this release introduces fourth-generation Intellisense and code completion technology.


RELATED STORIES

SoftTree Adds New Goodies to SQL Assistant

SoftTree Adds MySQL Support to Data Audit Tool

SoftTree Offers Centralized Reporting of Database Access



                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
COMMON

Register today for COMMON's 2009 Annual Meeting & Exposition, April 26 - 30, 2009, in Reno, Nevada, at the Grand Sierra Resort and Casino - learn more at www.common.org/annualmeeting

This premier Power Systems educational and networking event is COMMON's largest event of the year, offering five full days of IBM i and AIX education, evening networking socials, and the largest Power Systems-related Exposition to supplement your education. The Annual Meeting will feature well over 500 educational sessions, hands-on labs, and all-day workshops covering a wide variety of topics. All sessions are delivered by the most respected and knowledgeable presenters in the industry. Highlights include:

  · Providing attendees with over 500 educational sessions to choose from over five days on
     IBM i and AIX-related topics.
  · The most cost-effective conference option available to meet your 2009 Power Systems-related
     educational needs.
  · All-day pre-conference workshops providing an unprecedented opportunity to gain in-depth
     and wide-ranging education that will immediately impact your daily work.
  · The largest Exposition of its kind, giving you the ability to supplement your education
     with the latest Power Systems-related solutions available.
  · Over 80 vendors present in the Exposition to experience first-hand the next generation of
     technologies and solutions that you can implement immediately.
  · Special keynote address during Opening Session by Jeff Jonas, IBM Distinguished Engineer
     and Chief Scientist, Entity Analytic Solutions, IBM Software Group.
  · Extraordinary networking opportunities with other members of the COMMON community.
  · Having fun and sharing with your peers, renowned speakers, IBM executives, and
     fellow members.

Best Conference Value in 2009
The broad range of education on IBM i and AIX topics, the non-stop networking opportunities, and the largest Power Systems-related Exposition make the COMMON Annual Meeting an invaluable conference event. In fact, when you consider value of holding this event in Reno, this Annual Meeting is the most cost-effective Power Systems educational conference option in 2009.

Largest Power Systems-related Exposition
You will also have access to the world's largest Power System-related Exposition, which encompasses more that 80 of the leading industry exhibitors, including a large IBM presence. The COMMON Exposition provides a one-stop source of up-to-the-minute information and products for the IT industry. Discover what's new in the Power Systems world, and learn how you and your company can reduce costs and improve productivity by leveraging the products and services featured at the COMMON Exposition. It's a great way to supplement your education with hands-on exposure to the latest products and solutions available.

Invaluable Networking
In addition to the leading edge education, the Annual Meeting and Exposition provides an invaluable networking forum for attendees to interact with their Power Systems community. After a full day of education, the evening "Power Down" social events provide attendees the opportunity to relax, have some fun, and exchange knowledge and real-world experiences with fellow attendees, speakers, solution providers and IBM. The contacts you make at the conference will be as valuable as the education you receive.

The COMMON 2009 Annual Meeting and Exposition is a Power Systems educational
and networking event that you and/or your team won't want to miss.

To learn more about the conference visit www.common.org/annualmeeting


Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Halcyon Software:  Register now for our Multi-Platform Virtualization Webinar, March 31, 10 a.m.
System i Developer:  RPG & DB2 Summit in Orlando, April 15-17 for 3 days of serious training
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada


 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
Wall Street Makes IBM, Sun Strange Bedfellows?

Measure Twice, Cut Once Applied to ERP Implementations

UCG Partners with MaxAva, Expands DR and HA Capabilities

As I See It: Generation Gap

BCD Cranks Up Services, Training for PHP Deployments

Four Hundred Guru
Looking for Commitment, Part 2

Treasury of New DB2 6.1 (V6R1) Features, Part 3: Client Special Registers

Admin Alert: Changing your SMTP Server is Easy-ish

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
March 21, 2009: Volume 11, Number 12

March 14, 2009: Volume 11, Number 11

March 7, 2009: Volume 11, Number 10

February 28, 2009: Volume 11, Number 9

February 21, 2009: Volume 11, Number 8

February 14, 2009: Volume 11, Number 7

TPM at The Register
Platform lands OCS cluster deal with HP

SAS schemes $70m biz analytics cloud

Sun's Niagara gets Linux (again)

Penguin floats hybrid Linux supers

Sun and IBM - What price Bigger Indigo?

Sun pitches new cloud as 'Open Platform'

Rackable shrinks CloudRack cookie sheets

Sun breaks through the clouds

California: Cisco gives out some details, finally

Sun lands Sparc-Xeon super on Cape Town

Cisco throws California virt-server gauntlet

Storage software bucks hardware sales trend

HP in NonStop rack server chase

Cloudera floats commercial Hadoop distro

THIS ISSUE SPONSORED BY:

looksoftware
Help/Systems
COMMON
SkyView Partners
RJS Software Systems


Printer Friendly Version


TABLE OF CONTENTS
Capitalware Clamps Down on WebSphere MQ's 'Big Dirty' Security Secret

FalconStor Casts a Wider De-Duplication Net

Help/Systems Extends i OS Job Scheduler to Linux and Unix

Shield Adds More Smarts to Budget HA Software

Appian Expands Web-Based Reporting GPS Tracking for Fleets

News Briefs and Product Shorts:

m-Power Gets Calculation Enhancements . . . Meridian and Varsity to Go After IBM i Shops Together . . . SoftTree Updates SQL Assistant . . . Lotus Symphony Gets Visio Alternative with SmartDraw Plug-In . . . LANSA Introduces eLearning Option of Education and Training . . .

Four Hundred Stuff

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement