InterSystems is pleased to announce an addition to their Web site - an online demonstration of the MultiValue capabilities we’ve added to Cache`.

View the "Cache` For MultiValue Developers" online demonstration at
www.InterSystems.com/mv

The demonstration shows how you can use MultiValue technology within Cache`, as well as some of the new development options open to you with Cache`. In particular, the demonstration showcases how you can seamlessly access data via MultiValue syntax, objects, and SQL. It also demonstrates using MultiValue Basic with Cache`’s capabilities for rapid development of Web applications.

Cache` is the multidimensional, post-relational database and rapid application development environment from InterSystems. It allows you to leverage your investment in your existing MultiValue applications, while extending them with object technology, Web services, advanced security, powerful SQL, browser-based system management, and more.

You can also try Cache` (enhanced with MultiValue capabilities) for yourself. Download a FREE evaluation version of the Cache` MultiValue Developers Release at www.InterSystems.com/mv
 

Revelation's OpenInsight for Linux version 7.2 (OIL) was named a finalist at the recent Linux World show in San Francisco for the category of Best Application Development Platform or Tool.  We have also been admitted into the Red Hat Ready Partner Program.  This means that we've been certified to run on various distributions from Red Hat. 

To read more about Revelation's Success, Click Here

Release 2.4-14 of the QM Multivalue Database is now available for download from
www.openqm.com/downloads.htm

• This release is mainly to fix a serious bug in alternate key index scanning. This will only affect applications that use the QMBasic SELECTLEFT and SELECTRIGHT operations.
• The VOC now contains an F-type entry named MD as a synonym for VOC to give better compatibility with other systems.
• Shutting down the QMSvc service on Windows systems now force logs out all QM users on network connections.

Execu-Sys, ltd - Positions Available

Growing manufacturing company in Orange County, CA has an opening for an experienced PICK programmer; EPICOR experience highly preferred. Salary 70-90K (local candidates only); excellent opportunity to crosstrain Web & Datawarehouse technologies.

For additional information contact Matt Hart @ (800)423-1964 x302 or mh@eslny.com
 

Unidata-System Builder Programmer / Technical Analyst / Project Manager Position in Chino, CA

Tools set:
Unidata, UniBasic, System Builder, AIX, Data Warehousing (specifically MITS Data Warehouse)

Primary Focus:
Maintaining MITS data warehouse, report writing using System Builder & UniBasic or other tools
Data validation of our Unidata database & MITS, Unidata File Sizing, Application Integration with main business application (Unidata Database) and third-party bolt-ons, Data Uploads & Data Extractions
Assisting with upgrades & new module rollouts, special projects as they arise (portions of e-commerce & EDI), automating procedures. Project management of outside contractor/programmers.

Soft Skills:
Collaborative team player, Independent judgment. Written & Verbal communication.

Benefits:
Fun Environment
Appreciation of work
Internal growth – lots of diversity over time
Vacation (2 weeks; 5 years = 3 weeks; 15 years = 4 weeks), Holidays (7 annual days), Sick Pay
Health Insurance (Medical, Dental, Vision)
Life Insurance
401 (k) Plan
Profit Sharing at employer’s discretion

Contact Candace Bywater, Information Technology Applications Manager (cbywater@hipco.com)

Harrington Industrial Plastics, LLC
14480 Yorba Avenue, Chino, CA 91710 (800) 669-8641

Northgate Information Solutions, a major provider of relational database management software solutions and managed services, today announced it has entered into an agreement to migrate the Nebraska Furniture Mart (NFM) retail applications solutions to the Reality Multi-Relational Data Management System. NFM is the largest furniture retail outlet in the U.S. with stores in Omaha, Neb., and Kansas City, Kan.

NFM's selection team chose Northgate's Reality based on its open platform, ability to maximize the use of existing technologies and support of NFM's disaster recovery architecture. The five-year agreement with Northgate for their Reality products and services will provide excellent implementation engineering in the short run and offer superior support in the long run.

David Bash, NFM's Director of I.T. states "While it won't be seamless, our expansion and renovations have placed real demands on our IT capabilities and Reality will help us solve many of those issues."

As Northgate's MultiValue enhanced relational database management system, Reality delivers maximum mission-critical performance for a single user to many thousands. The Reality RDMS will enable NFM's systems to continue running AIX on Bull hardware. Currently, NFM has 2,000 active users and the Reality solution will provide a growth path that will allow many times this number.

According to Northgate spokesman John Seaman, "We are very pleased that following an intense and comprehensive evaluation of Multi-Value options, NFM has selected Northgate with Reality as their partner of choice. We look forward to working closely with NFM to enable them to achieve their expansion objectives. Reality will expand NFM's interoperability with other on-site databases, and establish robust resilience options with fail-safe back-up protection, while providing new remote access capabilities. It will also allow them to leverage Web Services for increased operational power and flexibility," Seaman concluded.

With continuous product innovations and enhancements stretching over three decades, Reality will provide NFM an impressive array of powerful features including fast backup and recovery, inbuilt XML parsing and creation, seamless CSV file integration, dataBasic Profiler, and an industrial strength SQL engine.

Suppose your data has a series of attributes that correspond to - say - lines on an order, or lines on a call log, or maybe lines on a time sheet.

You want to display the line number beside the other data.

"LINE" will do the trick assuming that attribute 1 is part of that data.

LINE
001 S
002 0
003 Line
008 F;1;NV
009 R
010 2

If you just need a count of the "lines" referenced by the multi-value data in attribute 1, then "CTR" will do that for you.

The assumption is that there are no null elements in attribute 1.

CTR
001 S
002 0
003 Count
008 F;1;C;#;S
009 R
010 7
 

This Tips was derived from Tom Phillips. He has lot of more samples like this at http://www.tom-phillips.info