Informix Error -802

Reasons / Common Causes

-802 fires when a SQL command file named for execution (in an interactive tool like dbaccess) can't be opened for reading — per the official guidance, three possibilities: a misspelled filename, a file not present in the current directory or DBPATH, or a permissions problem.

1. A misspelled filename, per the official guidance — the most direct, common cause.
2. The file present but not in the current directory or a directory named in DBPATH, per the official guidance — the tool searches those specific locations, not an arbitrary path.
3. Insufficient read permission on the file, per the official guidance.

Solutions / Resolution

1. Review the filename for correct spelling, per the official guidance.
2. Check the file exists in the current directory, or in a directory listed in DBPATH, per the official guidance:

   echo "$DBPATH"
   ls -l ./the_file.sql
   

3. Check the account's read permission on the file, per the official guidance:

   ls -l the_file.sql
   

Examples

Checking DBPATH and file presence

$ echo "$DBPATH"
$ ls -l the_file.sql
ls: the_file.sql: No such file or directory

Confirms the file isn't in the current directory — check DBPATH's listed directories next, or correct the filename/path.

Diagnostic Checks

1. Check the filename spelling.
2. Check DBPATH and the current directory for the file's actual presence.
3. Check read permission on the file once its presence is confirmed.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -802 in this set yet.

Check spelling, then presence in the current directory or DBPATH, then read permission — in that order, per the official guidance's own sequence.