Re: update/ delete protect

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