It’s not as if Paul Hamel hadn’t been trying for God only knows how long to dump the frumpy old IBM’3270 dumb-terminal-based, on-line CICS/VSAM COBOL applications he and his staff had been nursing alone for years and replace them with some kind of high-powered, client/server setup.

IBM flavored soda, anyone?
Au contraire, as they say.
No surprise, then, that Hamel, vice president of systems and planning at Providence, R.I.-based Textron Financial Corp. Jumped at the chance last year to install a group of new network gateway and server products from Sybase Inc. that would let him restyle his day-to-day Customer Information Control Systerd(CICS) applications to run with IBM’S power-packed DB2 relational database management system (RDBMS) on as many as 250 PC workstations in a state-of-the-art client/server system-while still holding onto his old IBM mainframe applications and flat file databases.
Hamel’s tale about his escape from a rigid IBM master/slave system to the freedom of a flexible mainframe-based client/server architecture could fill a book.
Here’s the story board version.
For the past six years or so, Hamel had been harboring a recurring dream that went something like this: one day, Textron’s management would suddenly realize that the company’s is operations formed the basic foundation of its business, something Hamel already knew as fact.
After all, the company, with annual revenue last year of $208 million, has only two types of products to offer its retailer customers: the actual hard, cold cash it lends at market rates to finance, for example, retailers’ up-front purchases of big-ticket consumer items like golf carts, RVs and power lawn mowers for their display room floors (in the trade, the business is known as floor planning,” in fact) and the services connected to those loans, such as the development of special loan deals, rearrangement of credit terms and early payoff incentives, as well the speedy response to customer requests. Both types of products depend on is applications and systems to function smoothly.
If management would only realize the importance of is to the business, Hamel speculated, they would likely assign it the strategic role it deserved-and would also give him the OK to melt down the antique 3270 terminals, pull the plug on the 3174 cluster controllers, cancel the contracts for the old and not exactly industrial strength 9,600-baud leased lines and start spending the money needed to develop a state-of-the-art client/server system that would be fast, responsive to customers, easy to manage and simple to modify or expand as needed.
That was the dream, at least.
Last year, the dream got real. Textron Financial’s president, Steve Davis, did decide to go after the company’s biggest competitors-Chrysier Financial Corp., ITT Financial Corp., Bombadier-with innovative products and improved service, and he assigned a new strategic role to is to make it happen.
As part of that assignment, Davis and his top managers gave Hamel three goals for the is operation. First, get ready for a tremendous increase in transaction volume-a 100% jump over the next two to three years and annual increases of some 25% after that. Second, begin to increase the variety and complexity of features available to Textron’s customers and make it easier to vary those features as the market changed. Third, expand and automate the new system as much as possible while holding to the existing operating and wage costs. To make all this happen, management also agreed to a onetime boost in Hamel’s capital-spending budget by a factor of 20.
Of course, Hamel was given a few constraints. For example, management gave him a back-busting 10-month time-table for the development of the new system. He successfully negotiated that up to 14 months.
But his biggest constraint was not negotiable. Even though he could build the new system from scratch, he was still anchored to the IBM mainframe data service provided by Textron’s Avco Financial Services division in Irvine, Calif. The old CICs on-line 3270 system (the Minneapolis-based “Floor Plan” operation) had been tied to Avco’s IBM 3090/200J mainframe with the umbilical cord of a leased line. The new system (called the “Inventory Finance System” or IFS) would be held to a similar relationship. But at the same time, issues with hard drive failure were holding the project back badly for engineers. That was true both for financial reasons-the company already owned the big 3090, which had a low marginal operating cost and still had plenty of available capacity-and for technical reasons-the existing applications and the database were already UP on the 3090. As part of the new IFS system, however, Avco agreed to upgrade to the latest version of IBM’s DB2 RDBMS.
So Hamel and his staff approached IBM to see what Big Blue could do to bring the mainframe into the client/server world. IBM had no problem meeting Textron’s hardware requirements. “They were excellent on that front-even coming up with some loaners when products were late stripping,” Hamel recounts. But the only software solution IBM offered was a 3270-gateway-based approach that used an Easel Corp. graphical user interface running on a PS/2 workstation to communicate with the CICS-applications 3270 on the mainframe. In Hamel’s view, that was kind of like painting a pretty face on a 3270 terminal and little more-not even close to what he had in mind.
That’s when Emeryville, Calif.-based Sybase came into the picture with its Open Server For CICS, Open Gateway For DB2 and NetGateway products. As a group, these products allowed Hamel to loop together the IBM mainframe and all those legacy applications and databases with his new, much more flexible workstation-based client/server applications. Plus, he could manage the migration process to DB2 without tying his stiff in mental knots.
The Sybase products, which began shipping late last year, act as programmable interfaces between applications running on local area networks and MVS applications and databases. They can work either by using Sybase’s own SQL Server RDBMS as the network database system or they can work without SQL Server, using the mainframe for all database needs. The three products do require that Sybase’s Open Client application, which contains the applications program interfaces (APIs) needed to communicate with the Sybase Open Server, run on each net-worked workstation.
Hamel discovered the Sybase products–which weren’t even on the market at the time–by accident. He knew right off the bat that if he wanted to get out of the master/slave world of IBM on-line CICS applications and 3270 gateways but still use his old IBM mainframe applications, he was going to have to find a way to run the 3090 mainframe itself as, in effect, a server in the PC LAN client/server system he was setting up. One possible solution would be to hand code a series of advanced program-to-program communication (APPC) interfaces for every workstation-based application so that it could gain access to the mainframe’s databases or call existing CICS applications for on-line transactions. “We thought about scratch building it-with APPC code-but we knew there had to be a better way,” he says.
Hamel’s development crew had already settled on the Sybase SQL Server RDBMS-the new name for what was formerly known as just plain old Sybase RDBMS-as the database to run on the network for the client portion of the database system. But, once he and the is development crew got deep into the process, they serendipitously discovered that Sybase was working on a new series of products that could manage all the APPCs for IBM CICS applications, plus a lot more. The products were just what his new system needed, he adds, “so we went beta with Sybase.
“I wanted to make it a state-of-the-art operation,” he recalls. “I wanted to put something in place that was at the beginning of the technology, that could handle a tremendous increase in transactions and inquiries both and that was flexible in its ability to vary applications and could still run in a top-end IBM environment. We wanted the best technology we could find.
“I wanted to keep the IBM mainframe both for its speed and its size-plus the move to DB2 was a priority for us. “Hamel adds. “We started calling the mainframe the ’3090 server’ because in this configuration it really is just another server.”
It’s SuperServer ! That’s exactly the role Sybase sees for the IBM mainframe of the future-as a superserver in a wide-ranging client/server system. Says Sybase executive vice president Robert S. Epstein: “We see the role of the mainframe as being used less and less for the minute-by-minute, or second-by-second, running of the business.” Instead, he says, the mainframe will function more as an information repository, which is updated less frequently. The minute-by-minute activities will be handled by more cost-effective workstations, off the mainframe.
Most companies want to be able to take today’s client/server technology and get the incredible price/performance that offers and integrate it with their legacy applications to preserve the investment they’ve already made in their development,” he adds.
Most large IBM shops have invested millions of man-hours and millions of dollars developing and maintaining hardware and software systems. And these systems are still performing all the critical activities for their enterprises perfectly well. So when they decide to downsize to the less costly client/ server structure for their new applications, they still want to hold onto those big-system investments. Modifying these large-system applications to run on workstations or in a distributed mode would cost far more than they could expect to save, and take far too long to justify the effort.
For these shops-and there are literally thousands of them-the best client/server structure is one that includes easy and invisible access between all types and brands of workstation platforms, applications and databases, and all types and brands of IBM mainframe-based applications and databases–just what Sybase claims its new products can do.
Here’s how the Sybase products work. A developer writes a new workstation-based application in Ada, C, COBOL, FORTRAN, Pascal, Sybase’s own fourth-generation language or one of several Sybase-compatible 4GLs available from several other vendors Focus, HyperCard, Nomad, Object/1, Prolog, etc.). The workstation application can run under whatever operating system the workstation supports-Macros, MS-DOS, OS/2, UNIX-and with whatever user interface the developer chooses to use-text, Easel, IBM Presentation Manager, Mac Windows 3.0 or any of several UNIX-based graphical user interfaces.
The developer includes in that application remote procedure calls (RPCS) to mainframe applications or routines. The actual mechanism the RPCS can use to invoke the mainframe applications can be CICS queues; Intersystem Communications (ISC); Job Entry Subsystem (OES); or Multiregion Operaions(MRO).Or the RPCs can call a Sybase SQL Server routine, which itself can call predefined mainframe applications singly or in groups. Sybase NetGateway-running on a single IBM RT or RS/6000 workstation hooked into the IBM Systems Network Architecture (SNA) network-converts these RPCS, in transit to the mainframe, from the PC LAN’s TCP/IP communications protocol to IBM’s LU6.2 protocol for the mainframe.
The Sybase Open Server For CICS then routes the calls to the appropriate predefined CICS application on the IBM mainframe. Open Server For CICS can also route calls to other vendors’ database management systems-CA-Datacom, CA-IDMS, DL/1, Oracle. On the return route, CICS Server sends the response to the RPC back to the appropriate workstation application or to Sybase SQL Server, which bundles the response with other RPC responses to go back to the workstation as a package.
The Sybase DB2 Gateway product performs all the above routines, and, in addition, can send a predefined data request directly to the mainframe’s DB2 database (Sybase calls this “Turnkey DB2 access”). Or it can get at the DB2 data indirectly through workstation-initiated RPCs embedded in applications written with Sybase’s own Transact SQL With Extensions, or written with other DB2 Structured Query Language (SQL)-Compliant languages.
Sybase says the Open Gateway For DB2 is the only DB2 gateway that can call static complied) SQL, the industry standard method of speeding up DB2 performance on transaction-processing routines such as database updates or real-time data entry. Open Gateway For DB2 can also use the slower dynamic SQL access method for DB2 queries. At Textron, the new IFS system handles all its access to DB2 data-routine database update transactions, reads and writes, and prameter-driven queries-with high-speed precompiled static SQL embedded in COBOL/VSAM applications residing on the mainframe.
Although Sybase says its Gateway products don’t require the Sybase SOL Server RDBMS product in order to function, users who also have SQL Server running on their LANs will be able to take advantage of that product’s programmable server capabilities, which include enforcement of data integrity and security. Users can also write their own applications on the mainframe to provide these services, but most probably will let Sybase do the dirty work.
Explains “Rich Koch” administrator for telecommunications giant Contel Corp.’s record and design systems in St. Louis, “With the Open Server and SQL Server, programmers can go ahead with writing the applications themselves. I don’t want to sit here and write a program where I have to define every single piece of data in every location on the system in every application-I want to get on with it.”
Says Sybase marketing manager Perry Mizota: “We were the first company with a programmable server-before our product, database systems were just wimpy file cabinets.”
With a programmable server, workstation-based applications need not be modified when a company’s business requirements change; instead, these requirements can be defined in a library of reusable routines running on the LAN’S database server that are subsequent called by workstation applications.

The logo lives!
That way, ill, for example, a corporate tax-reporting requirement changes, the change only need be made on SQL Server’s library of routines that may relate to that tax change and not on every financial application in the enterprise. Competitor ASK/ingres now also includes a programmable server, and Oracle Corp. may announce a similar capability on the upcoming upgrade to its RDBMS.
For now, at least, the Sybase products seem to be the only way for client/server applications developers to get access to a whole suitcase of database products residing who knows where in the IBM data center-everything from those crusty sequential files of yesteryear right up to today’s most complex relational or network databases from Computer Associates International Inc., IBM, informix Software Inc. and Oracle-all with just a simple PC application written in C or with a fancy Apple Mac-based HyperCard routine.
This puts Sybase products into a whole new world when is managers start looking for client/server enabling technology. Says Contel’s Koch: “In this world, Sybase stops being a relational database company. These products can take an RDB and make it a network database; they can talk to the old flat files on the mainframe and hook them into DB2, then bring them back to an application running on a Mac in a LAN.”
At the same time, the Sybase products offer developers an easy migration route to DB2 applications, since programmers can use the SQL Server and the Open Gateway For DB2 to access existing DB2 data without using a single line of DB2 SQL code.