• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • SoftTree Updates SQL Assistant

    March 24, 2009 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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    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

    Things That CIOs Should Know Keep Their CEOs Awake Nights Treasury of new DB2 6.1 (V6R1) Features, Part 4: Index and Data Type Enhancements

    Leave a Reply Cancel reply

Volume 9, Number 12 -- March 24, 2009
THIS ISSUE SPONSORED BY:

looksoftware
Help/Systems
COMMON
SkyView Partners
RJS Software Systems

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
  • 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

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle