To use WRITE_NOS, you need to be authorized by the external object storage. A user can provide credentials to the external storage using AUTHORIZATION syntax in the WRITE_NOS command.
- Log on to the database as an administrative user with the required privileges to create an authorization object and function mapping.
- Create an authorization object for the external object store you are writing to, if not already done:
CREATE AUTHORIZATION MyAuthObj_Write USER 'YOUR-ACCESS-KEY-ID' PASSWORD 'YOUR-SECRET-ACCESS-KEY';
See an example of using an authorization object with the AUTHORIZATION syntax in the query: Example: Using WRITE_NOS with AUTHORIZATION.