Informix Error -828

-828 Command file not found.

The SQL command file that you specified is not found in the current directory or in the directory that is listed in the DBPATH environment variable. Check the spelling of the name and the setting of DBPATH.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-828 fires when a specified SQL command file isn't found in the current directory or any directory listed in DBPATH — per the official guidance, checking spelling and DBPATH are the two documented steps.

A misspelled filename, per the official guidance.
DBPATH not including the directory where the file actually lives, per the official guidance.

Solutions / Resolution

Check the spelling of the name, per the official guidance.
Check the setting of DBPATH, per the official guidance:
```
echo "$DBPATH"
```
Confirm the file exists in the current directory or one of DBPATH's listed directories:
```
ls -l the_file.sql
```

Examples

Checking DBPATH and file presence

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

Diagnostic Checks

Check filename spelling and DBPATH's setting, the two documented checks.

Related Errors / Related Topics

-802 — "Cannot open file for run." A related file-access error, once the file is found but can't be opened, rather than not being found at all.
-808 — "Cannot open file for choose." A related file-access error, in the Choose context specifically.

Check filename spelling and DBPATH, per the official guidance's two documented steps.