Difference between revisions of "ENCRYPT"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) (→Example) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Encrypt the specified table or tables | Encrypt the specified table or tables | ||
| − | |||
==Syntax== | ==Syntax== | ||
ENCRYPT <.dbf> | <skeleton> KEY <expC1> | ENCRYPT <.dbf> | <skeleton> KEY <expC1> | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[APPEND FROM]], [[COPY FILE]], [[COPY STRUCTURE]], [[COPY | + | [[APPEND FROM]], [[COPY FILE]], [[COPY STRUCTURE]], [[COPY]], [[CRC32()]], [[DECRYPT]], [[DES3_DECRYPT()]], [[DES3_ENCRYPT()]], [[DECRYPT]], [[DIR]], [[MD5()]], [[MD5FILE()]], [[SHA1()]], [[SHA1FILE()]], [[SET ENCRYPTION]], [[USE]] |
| − | + | ||
==Description== | ==Description== | ||
| − | The ENCRYPT command is used to encrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. If the <skeleton> syntax is used, then all matching tables will be given the same encryption key. The <expC1> must contain a three part comma-separated key. The key may optionally be enclosed in angled brackets. Each part of the key can be a maximum of 8 characters. The key is | + | The ENCRYPT command is used to encrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. If the <skeleton> syntax is used, then all matching tables will be given the same encryption key. The <expC1> must contain a three part comma-separated key. The key may optionally be enclosed in angled brackets. Each part of the key can be a maximum of 8 characters. The key is 3DES encrypted and stored in a .dkf file with the same basename as the table. After encryption, the three parts of the key must be specified correctly before the table can be accessed. |
| − | + | ||
==Example== | ==Example== | ||
| Line 24: | Line 20: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category: | + | [[Category:Databases]] |
| − | [[Category: | + | [[Category:NoSQL Commands]] |
| − | [[Category: | + | [[Category:Encryption]] |
| − | + | ||
Latest revision as of 06:43, 20 April 2022
Contents
Purpose
Encrypt the specified table or tables
Syntax
ENCRYPT <.dbf> | <skeleton> KEY <expC1>
See Also
APPEND FROM, COPY FILE, COPY STRUCTURE, COPY, CRC32(), DECRYPT, DES3_DECRYPT(), DES3_ENCRYPT(), DECRYPT, DIR, MD5(), MD5FILE(), SHA1(), SHA1FILE(), SET ENCRYPTION, USE
Description
The ENCRYPT command is used to encrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. If the <skeleton> syntax is used, then all matching tables will be given the same encryption key. The <expC1> must contain a three part comma-separated key. The key may optionally be enclosed in angled brackets. Each part of the key can be a maximum of 8 characters. The key is 3DES encrypted and stored in a .dkf file with the same basename as the table. After encryption, the three parts of the key must be specified correctly before the table can be accessed.
Example
encrypt accounts key "key1,key2,key3" encrypt salaries key "<key_1,key_2,key_3>" // encrypt all .dbf files in the directory encrypt *.dbf key "key1,key2,key3"
