RE: Re: Source PF member exists?

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. Re: Source PF member exists? (Vernon Hamberg)
>
>The resulting outfile has no key, unless you create one especially
>for this. CHAIN is not the best way - a SELECT and checking the SQL
>code is going to tell you whether you have a hit.
>
>But the CHKOBJ is even better.
>
>At 04:56 PM 12/19/2005, you wrote:
>
>>You could try something like this:
>>DSPFD FILE(srclib/srcfile) TYPE(*MBRLIST) +
>>              OUTPUT(*OUTFILE) OUTFILE(mylib/myoutfile).
>>Then chain to the outfile with the member you are trying to create. If
>>you get a hit then you know that the source already exists.

Vern:

True, the outfile doesn't have a key, but...

I've never needed to use this for an RPG CHAIN:

  ==>  dspobjd  ...outfile(mylib/mymbr)
  ==>  chgpf    mylib/mymbr maxmbrs(1)
  ==>  addpfcst mylib/mymbr type(*UNQCST or *PRIKEY) key(MLNAME)

Ought to work, no? It's a handy way to get keys on files that never had keys 
before.

Tom Liotta