Re: [OT] Business Requirements Analysis... Sort Of

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.