I've been trying to make this work with UNLOAD ALL but cannot successfully reload my db afterwards. I've run AUTOCHK and the db is clean before the output. It works with RRBYW14 so there's a personal problem here... Any ideas?
TIA, Claudine :) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, January 30, 2008 8:09 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: Encrypting UNLOADed DATA File Wednesday, January 30, 2008 Supported Versions: . R:BASE 7.6 and C/S:I 7.6 for Windows . R:BASE Turbo V-8 for Windows Traditionally, the UNLOAD command is used to unload the structure, data, structure with data, forms, labels or reports to a specified OUTPUT file. Depending on the option used, the UNLOAD command also creates a LOB file with matching output file name. Typically, you can view the entire ASCII unloaded data using text editor. However, it becomes critical when the unloaded file contains sensitive data, including owner and user passwords, etc. Did you know that you can encrypt the entire file using the new built-in 512-bit ENCRYPT option in R:BASE 7.6, C/S:I 7.6 and Turbo V-8 for Windows? -- Example 01: CONNECT RRBYW14 OUTPUT rrbyw14.str ENCRYPT mypassword UNLOAD STRUCTURE OUTPUT SCREEN This will create an encrypted password-protected rrbyw14.str file. -- Example 02: CONNECT RRBYW14 OUTPUT rrbyw14.all ENCRYPT mypassword UNLOAD ALL OUTPUT SCREEN This will create an encrypted password-protected data rrbyw14.all and rrbyw14.lob file. -- Example 03: CONNECT RRBYW14 OUTPUT employee.asc ENCRYPT mypassword UNLOAD DATA FOR Employee USING + EmpID,EmpFName,EmpLName,EmpAddress,EmpAddress2,EmpCity,EmpState, + EmpZip,EmpPhone,HireDate,EntryDate,EMailAddress AS ASCII OUTPUT SCREEN This will create an encrypted password-protected ascii employee.asc file. While using the built-in RBEdit or external R:BASE Editor 7.6, you may also create/edit any external command file/EEP and add the encryption by using the "Add Encryption" when Saving or Save As option. An output file created with "ENCRYPT yourpassword" option can only be opened using any version of R:BASE for Windows (listed above) or R:BASE Editor 7.6 and higher. Attempting to edit or run the encrypted file will prompt you to enter the appropriate password. Imagine the possibilities! Very Best R:egards, Razzak.
