Re: update/ delete protect

[Raul Jager <raul@xxxxxxxxxx>]

They are easy to change.  controlling the journal after is as heavy as
looking for updates in the journal.


On 09/07/2017 01:12 PM, Steve Pitcher wrote:
> Why not assign read-only rights to the table?
>
>
>
> Steve Pitcher 
> iTech Solutions
> Office: (203) 744-7854 Ext. 176
> Mobile: (902) 301-0810
> http://www.itechsol.com
> http://www.iInTheCloud.com
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Raul Jager
> Sent: Thursday, September 7, 2017 1:40 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: update/ delete protect
>
> When I create a file with CRTF, I have a pair of parameters, ALWUPD and ALWDLT that makes it ideal for applications where you want to make sure data is no modified.  But I did not find an equivalent when I create a table. (SQL)
>
> Is there a way to CREATE TABLE so it will not be possible to change nor delete data?
>
> If I  remember well, CHGPF had a  parameter to set the ALWUPD and ALWUPD to no, and it did not allow to set it back to yes, but in 7.3 I do not have that in CHGPF.
>
> TIA,
>
> Raúl
>
>
>
> -- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
>             -- Verificado por Anti-Virus Corporativo Symantec --
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --