HomeMy WebLinkAboutAgenda Report - June 19, 2002 E-07' CITY OF LODI COUNCIL COMMUNICATION
AGENDA TITLE: Adopt resolution authorizing the purchase of Sequel Viewpoint software for
use on IBM AS400 from Advanced Systems Concepts, of Schaumburg, IL.
($10,000) (ISD)
MEETING DATE: June 19, 2002
PREPARED BY: Information Systems Manager
RECOMMENDED ACTION: That the City Council authorize the purchase of a 4 -user license for SEQUEL
VIEWPOINT, a data query tool from Advanced Systems Concepts to be used
on the IBM A$400.
BACKGROUND INFORMATION: The IBM AS400 computer is the general store of data for the City of Lodi. All
transactions for the City's billing system (Orcom) and its financials (J.D. Edwards), among other data, are stored on
the AS400. Data queries are written in order to provide reports and print checks, among other important tasks. As an
example, if the City Council wanted to know how many business licenses were taken out from January through March
of a given year, and where the businesses were located on Pine Street, this product would make it faster and easier to
write the query needed to return this information.
Currently, the process required to write such queries is both complex and time-consuming. The Sequel Viewpoint
product will enable our staff programmers to write queries much faster, allowing reports and information requests to be
handled more expeditiously. While it is difficult to predict turnaround times (because not all queries are the same),
reports that once took days or weeks to produce could be done the same day. Sequel Viewpoint also utilizes newer
technology, which will make it easier to learn the product. This is a unique utility, specifically made for use on the IBM
AS400. Having researched other, similar products, staff believes Sequel Viewpoint is the "best of breed" and the most
cost effective solution.
This product includes 4 different modules, which are included in the purchase. Normally, the software is sold with a six
license minimum; however, we were able to negotiate a 4 -user license deal if purchased by June 30, 2002. The City
will realize a savings of approximately $5,000 at this negotiated price.
FUNDING: PC Replacement Fund 123001.7715 ($10,000)
FUNDING AVAILABLE:
. PA4.& bof A,4
Vick ie, Finance Directotly" Steve ann, Info oon"'///&'e
APPROVED:
H. Dixon Aynn -- City Hager
Steve Mann
City of Lodi
221 W. Pine Street
Lodi CA 95240
DESCRIPTION
Revised User Based License: 4 -user
(AS/400 model 510/2143)
SEQUEL Kernel - $1,000/user
SEQUEL User Interface - $500/user
SEQUEL Viewpoint-$500/user
SEQUEL Report Writer - $500/user
Quotation valid until June 30"', 2002
Advanced Systems Concepts, Inc.
1300 Woodfield Road, Suite 310
Schaumburg, Illinois 60173
**********
PRICE QUOTE
Tel. 847.605.1311
Fax 847.605.1912
email: asc@asc-iseries.com
June 10, 2002
AMOUNT
$ 4,000
$ 2,000
$ 2,000
2,000
$ 10,000
RESOLUTION NO. 2002-138
A RESOLUTION OF THE LODI CITY COUNCIL
AUTHORIZING THE PURCHASE OF SEQUEL
VIEWPOINT SOFTWARE FOR USE ON THE IBM AS400
WHEREAS, Lodi Municipal Code §3.20.070 authorizes dispensing with bids for
purchases of supplies, services, or equipment when it is in the best interest of the City to do so;
and
WHEREAS, the IBM AS400 computer is the mainframe that stores billing system
transactions as well as financial data among other things for the City of Lodi; and
WHEREAS, staff recommends purchasing Sequel Viewpoint software, a data query tool
for the AS400, from Advanced Systems Concepts, of Schaumburg, IL; and
WHEREAS, data queries are written in order to generate a certain type of report, or to
print checks, among other things; and
WHEREAS, the process currently is very complex and time consuming. The Sequel
Viewpoint software will enable programmers to write queries much faster, allowing reports and
information requests to be handled more expeditiously; and
WHEREAS, typically this software is sold with a six -license minimum, however, City staff
was able to negotiate a four -user license deal if purchased by June 30, 2002, thus saving the
City approximately $5,000.00.
NOW, THEREFORE, BE IT RESOLVED, that the Lodi City Council does hereby
authorize the purchase of Sequel Viewpoint software (four -user license) for the AS400 from
Advanced Systems Concepts, of Schaumburg, IL, in the amount of $10,000.00.
Dated: June 19, 2002
------------------------------------------------------------------------
I hereby certify that Resolution No. 2002-138 was passed and adopted by the Lodi City
Council in a regular meeting held June 19, 2002 by the following vote:
AYES: COUNCIL MEMBERS — Hitchcock, Howard, Land, Nakanishi, and Mayor
Pennino
NOES: COUNCIL MEMBERS — None
ABSENT: COUNCIL MEMBERS — None
ABSTAIN: COUNCIL MEMBERS — None
SUSAN J. BLACKSTON
City Clerk
2002-138