Re: Wiping a file on open in RPG

[Jimmy Sansi <jsansi@xxxxxxxxx>]

Embedded SQL is native? And faster than those DOU loops on large tables.

On 2024-01-09 12:24, James H. H. Lampert via RPG400-L wrote:

> On 1/9/24 12:11 PM, Bryan Dietz wrote: 
>
> > i scanned some source i accumlated for "_Ropen"
> >
> > it can be used in RPGLE.
>
> Right. I've had more than one occasion to use runtime calls more idiomatic to C, but here, I was looking for something that was RPG-native and RPG-idiomatic.
>
> And Scott said: 
>
> > I mean...  yes you can do this, but...  if the only reason is to
> > clear the file, wouldn't it be easier to just run CLRPFM prior to
> > opening it?
>
> I quite agree. In this case, lacking a native equivalent, it would probably be easier to make the file USROPN, and wipe the file by shelling out a CLRPFM with QCMDEXC, than to use the _Rxxxxx calls.
>
> --
> JHHL