Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I am rebuilding a encrypted database in SQLA 17

The unload script created includes the statement

PARAMETERS encryption_key;

All LOAD TABLE statements include

ENCRYPTED KEY '{encryption_key}'

I intend to run this script with the utility

How do I pass in the parameter "encryption_key"



asked 08 Mar '21, 13:30

J%20Diaz's gravatar image

J Diaz
accept rate: 10%

Hm, I have often rebuilt encrypted databases (via supplying -ep or -ek to the unload utility), and never have noticed those LOAD TABLE statements with ENCRYPTED KEY clauses, and therefore had not to supply parameters for those. Is this a database with table encryption (-et), not fully encrypted?

(08 Mar '21, 14:38) Volker Barth

   -c "ENG=ddd17; DBN=ddd17; UID=dba; PWD=sql"^
   READ ENCODING Cp1252 "master.sql" [c:/temp/]

-- master.sql
READ '{rootDir}MyDevScript1.sql';
READ '{rootDir}MyDevScript2.sql';
permanent link

answered 08 Mar '21, 14:25

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

You are a genius, thanks

(08 Mar '21, 14:31) J Diaz
Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 08 Mar '21, 13:30

question was seen: 1,179 times

last updated: 08 Mar '21, 15:49