SQL Script parameter passing with dbisql.com

[JimDiaz]

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 dbisql.com utility

How do I pass in the parameter "encryption_key"

Thanks

Jim

[VolkerBarth]

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?

[Breck_Carter]

"%SQLANY16%\\bin64\\dbisql.com"^
   -c "ENG=ddd17; DBN=ddd17; UID=dba; PWD=sql"^
   READ ENCODING Cp1252 "master.sql" [c:/temp/]

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

[JimDiaz]

You are a genius, thanks