Re: how to copy dtaara text into a physical file

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

The QWCRDTAA API that I cited could be part of a UDF, of course - but 
why not call it directly in COBOL? That's the language in use where Joel 
works, certainly more than RPG.

Cheers
Vern

On 2/8/2013 2:59 PM, Roger Harman wrote:
> What about a UDF to grab the data area contents and return to the SQL?
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
> Sent: Friday, February 08, 2013 12:36 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: how to copy dtaara text into a physical file
>
> 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?
>
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
> Sent: Friday, February 08, 2013 2:23 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: how to copy dtaara text into a physical file
>
> On 2/8/2013 3:08 PM, Stone, Joel wrote:
>
> > What is a simple way to accomplish?
> >
> > Anything better than CL & SQL?
> I know it helps me if I can have an understanding of the business problem.
> Is there a 3rd party program putting a status in a data area and you want to
> keep an audit log?  What tooling is available to you?
> CL, Cobol, Java, MI, PL/I, Python, QShell, Rexx, RPG?  What drawbacks would
> you like to avoid?  Batch, interactive (is response time paramount)?  Are
> you in 'let's learn something cutting edge' mode, or more like 'let's just
> bang this one out'?
>    --buck
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
> ________________________________________________________________________
> This inbound email has been scanned for all viruses by the MessageLabs
> SkyScan
> service.
> ________________________________________________________________________
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs
> Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________