In this blog post, let’s learn about the error message “20074 IMPORT cannot open datafile – file name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20074 IMPORT cannot open datafile – file name.
Reason for the Error
SQL was unable to open the data file that you specified either because it was missing or because of some other file system problem. The input file might be corrupt or, if it resides on a remote system, the remote system password is not set.
Solution
Check the validity of the input file. If the input file is a valid remote file, verify that the remote password for the system is set
