In article <qtt3u35t5f16ej8v6loh3pfnf3v5d3f392@[EMAIL PROTECTED]
>,
Robert <no@[EMAIL PROTECTED]
> wrote:
>On Thu, 20 Mar 2008 01:01:37 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
() wrote:
>
>>In article <s6f3u3dlalc0i5g0jq4gtilg43kke5nm0o@[EMAIL PROTECTED]
>,
>>Robert <no@[EMAIL PROTECTED]
> wrote:
>>>On Wed, 19 Mar 2008 12:35:35 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
() wrote:
>>
>>[snip]
>>
>>>>(note - this is a shop that runs on files, not on a database)
>>
>>[snip]
>>
>>>select name, separation_date, dirty_money
>>> from employees emp,
>>> (select employee, sum(amount_paid) as dirty_money
>>> from payroll_detail pd
>>> where debit_account = '6969'
>>> and payment_date between to_date(20051001) and
sysdate
>>> group by employee
>>> having dirty_money > 0) crook
>>> where crook.employee = emp.employee
>>> and emp.separation_date is not null
>>> and emp.division in
>>> (select division from divisions where division_name like
>'Midwest%')
>>> and emp.start_date >
>>> (select min(start_date) from employees where name like
'%Dwarf%')
>>>
>>>-- Query preparation time: 5 minutes
>>
>>Amount of time spent carefully reading what preceded query preparation
>>time: not enough to catch a clear and unambiguous note.
>
>All ya gotta do is write a schema defining the flat files and define it
>as an ODBC data
>source. If there are multiple files, concatenate them with copy command,
>in JCL, or write
>a view containing a UNION.
That's just the kind of response I'd expect from a Manager, Mr Wagner...
are you considering a career-change?
(actually... I found out Just The Other Day that they *do* have a 'Re****ts
Group' just for situations like this and the Re****ts Group does...
something-or-other with an Oracle loading of the files I interrogate with
COBOL and DFSort.
My tech lead said that the users have expressed a preference for putting
these requests into my hands... because I seem to Get More Done. Go
figure, eh?)
DD
|
