RE: DB2 Software

[Gord Royle <GRoyle@xxxxxxxx>]

One of the advantages that you have is that DB2/UDB is "supposed to use
standard SQL syntax across all platforms. Therefore, you could write a
common SQL statement (complete with DB2 extensions to standard SQL) and then
execute it on the AS400 or Win2K (also on AIX Unix). Whether this is an
advantage or not is anyone's guess. We use SQLServer in our shop as well as
the AS400. You constantly have to think about differences in function when
you're writing SQL. For instance, the Substring function has four or five
different names depending on the database and the tool being used.

Gord Royle

-----Original Message-----
From: Keith Nolan [mailto:knolan@dublinport.ie]
Sent: Friday, January 24, 2003 6:07 AM
To: Midrange List (E-mail)
Subject: DB2 Software


Hi all,

We are implementing a new Time and Attendance system here which uses DB2
as it's Database.  The system runs on a Windows 2000 server.  We are at
OS400 V4R5 and we use client access express as our connectivity tool on
our windows clients.  The contractors are now saying that we need to
install a new piece of software called "DB2 Universal Database for
Windows"  We are not familiar with this software and I was wondering if
anyone out there is familiar with it and what are the set-up
implications from both the AS/400 and the windows environment...

TIA


Keith



********************************************************************* 
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please advise the
sender immediately and delete this message. Any views or opinions
presented are solely those of the author and do not necessarily
represent those of Dublin Port Company or its associated companies
unless otherwise specifically stated. Thank you.

Visit Our Web Page <http://www.dublinport.ie> 
********************************************************************* 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.