RE: ILE and locked file

[Michael Quigley <MichaelQuigley@xxxxxxxxxx>]

Birgitta,

Thanks for pointing this out! I had missed the WITH REPLACE clause in the documentation. That'll keep thins simpler.

Michael Quigley
Computer Services
The Way international
www.TheWay.org

> -----Original Message-----
> message: 1
> date: Wed, 20 Jul 2022 19:26:36 +0200
> from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
> subject: RE: ILE and locked file
>
> I assume the problem is the DLTF!
> Is it really necessary to delete it first?
> Have you tried to create a Global Tempoarary Table (DECLARE GLOBAL
> TEMPORARY TABLE ... WITH REPLACE).
> https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fww
> w.ibm.com%2Fdocs%2Fen%2Fi%2F7.5%3Ftopic%3Dstatements-declare-
> global-temporary-
> table&amp;data=05%7C01%7CMichaelQuigley%40theway.org%7C84aadf714
> 48f42a43d3208da6a9c57e0%7Cdfc3789155b94fe0bc8b34a0f4b6650f%7C0%7C
> 0%7C637939516984332988%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLj
> AwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%
> 7C%7C&amp;sdata=aJk80VCNTiAYyWQgpt86ZvHO288DDlo2YgYHc2v9K6I%3D
> &amp;reserved=0
>
> WITH REPLACE:
> Specifies that, in the case that a declared temporary table already exists with
> the specified name, the existing table is replaced with the temporary table
> defined by this statement (and all rows of the existing table are deleted).
>
> Mit freundlichen Gr??en / Best regards
>
> Birgitta Hauser
> Modernization ? Education ? Consulting on IBM i
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown) "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> ?Train people well enough so they can leave, treat them well enough so they
> don't want to.? (Richard Branson)