Encrypt Database Output

[Former Member]

Want to be able to select from a SQL Anywhere Database and output to a CSV file and encrypt that file and send it to my client who does not have sql anywhere but should be able to decrypt the file. So do i install SQL Anywhere Client on the client machine so they can decrypt or need a full SQL Anywhere insttallation.

Regards,

[graeme_perrow]

You can use the encrypted clause with the unload select statement to create an encrypted file containing the data, but your client will need to use the load table statement to decrypt the data. This means that the client will need a full installation of SQL Anywhere.

Alternatively, you could use the unload select statement to create the file, and then use some non-SQL Anywhere technology to encrypt the file.