"cshenk" > wrote in message
...
> "Ellen K." wrote
>> "Bjørn Steensrud" wrote
>
>>>> Now I just do SQL.
>
>> And I once had a job where I wrote a program that generated SQL
>> statements that were then SPUFI'd to the mainframe DB2 database by the
>> mainframe folks since I wasn't allowed to directly address it. It ran
>> once a month and each time it generated about 100 text files of 300 SQL
>> statements each (because they wanted me to make a commit every 300
>> statements). I analyzed the data from a real-time clone that was
>> propagated to an Oracle database running on one of the flavors of unix,
>> can't remember which one now. It took my program about 24 hours to
>> download the relevant data each month (made a bit faster by using two
>> PC's, each doing half).
>
> Faster now by far to do it!
>
> I mostly either freehand or when doing batches, use a concatinated excel I
> made to make it easier. 'Fill in the blank' as I do alot of inserts.
> Updates I pretty much freehand and of course random queries are freehand
> to check things out.
>

As noted, I was not allowed direct access to the mainframe DB2 database,
that was why I had to generate the scripts.