For example, a few years ago, I encountered a customer who did not have
source code, or even PDM, because their BP/Software vendor told them that
they would never need it. The BP said "We'll take care of everything for
you." (grab a shovel)
This company had the need to export payroll time card data to an Oracle
platform. Using SEQUEL and its run time variable prompting and scripting
capabilities, I was able to extract the data for the proper week ending
date, perform some cleansing to make things compatible with the Oracle
tables (turning character fields into numerics and vice versa) and ftp the
data in CSV format to the Oracle box.
To run this, the user clicks an icon on her desktop, clicks on the
appropriate date in a Windows calendar box, and then clicks OK
The whole project took me about 90 minutes. Try doing the same thing in the
same time frame with the "native" tools.
Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Nathan Andelin
Sent: Thursday, August 09, 2007 10:30 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL views
Paul N wrote:
I see all the posters on this list struggling with SQL to manipulate
data (Updates, etc.) and I shake my head, knowing that using
SEQUEL "I can name that tune in 3 notes". :-))
I don't disagree, but it might be helpful if you give an example of how you
handle a problem with SEQUEL.
I sometimes use Visual Foxpro to do mass updates to a database, using the
wizards to define "Remote Views", and command line statements to REPLACE xyz
with abc for someConditionalExpression.
Nathan.
midrange.com
