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?
