To use the Btrieve (Pervasive.SQL) file system for a file, identify the file with the SELECT clause as shown below.
SELECT file1 ASSIGN TO 'BTR-MyFile'
If the runtime option FILESYS(BTRIEVE) is in effect, the following assignment is valid:
SELECT file1 ASSIGN TO 'MyFile'
If you have defined the environment variable MYFILE (for example, SET MYFILE=BTR-MYFILE), the following assignment is valid:
SELECT file1 ASSIGN TO MYFILE