Adaptive Server 15.0.2 includes allows you to create user-specified passwords on keys with create encryption key. The syntax is:
create encryption key [ db.[owner ]. ] keyname [ as default ]
[ for algorithm_name ] [ with { [ keylength num_bits ]
[ passwd 'password_phrase' ] [ init_vector {NULL | random } ]
[ pad {NULL | random } ] } ]
For more information, see “Key protection using user-specified passwords”.