Error DSF=NAT when running DDTRSLM

Products

• Datacom
• DATACOM - AD

Issue/Introduction

Description:

Running Datacom/AD DDTRSLM to IMPORT an SQL Table definition fails with:

DDTRS0015E ADDOCC FAILED DSF COMMAND STRADD, RC: NAT.

Resolution

During the DDTRSLM IMPORT TABLE a Table entity-occurrence insertion in DATA-DICT fails with DSF error NAT .
DSF RC=NAT means NO SUCH AUTHID .
Each table that is SQL-able has an AUTHID (Schema Authorization-id) .
In the Datadictionary environment where this IMPORT TABLE runs this AUTHID that this table uses does not exist .

An AUTHID can be added by running DBSQLPR CREATE SCHEMA AUTHORIZATION name;
or by running DDUPDATE
-USR …
-BTG AUTHORIZATION,name
1500 AUTH-USAGE,S
-END
-UPD AUTHORIZATION,name(0001),PROD
-END