Re: how to copy dtaara text into a physical file

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

I'd just make a simple UDF that reads a data area.  Then any SQL 
statement can do it.

On 2/8/2013 2:36 PM, Stone, Joel wrote:
> No 3rd party stuff.  All internal.
>
> Performing an ETL function, dropping the output files on a network folder.
>
> Need to drop a single sentinel file on another network folder telling a network scheduler that the ETL files are ready to pick up.
>
> I keep a data area showing the ETL start/end dates/times.  I would like to send that data area contents as the sentinel file.
>
> I am planning on RTVDTAARA into a CL var, then SQL INSERT that into a table to be dropped onto a network file via QNTC as the sentinel file.
>
> Any better / simpler method?