If you are opening an existing file, all file systems linked into the runtime will be searched for the named file. If, however, you are creating a new file, you will need to tell the runtime which file system to use. You accomplish this with one of two runtime configuration file variables; the first is:
DEFAULT-HOST filesystem
This will designate the file system to be used for newly created files that are not individually assigned. For example,
DEFAULT-HOST MSSQL
means that all new files will be Microsoft SQL Server tables unless otherwise specified by the second configuration variable, which is:
filename-HOST filesystem
where filename is the file name, without any extension, named in the ASSIGN TO clause of your SELECT statement. This configuration variable is used to assign an individual data file to a file system. Any file so assigned will use the designated file system, and not the one specified by DEFAULT-HOST. For example,
myfile-HOST VISION
means that myfile will be under the Vision file system.
You can use these runtime configuration file entries in combination to assign your new files in a default with exceptions manner; for example, this set of entries:
DEFAULT-HOST VISION
afile-HOST MSSQL
bfile-HOST MSSQL
means that all new files except afile and bfile will be assigned to Vision, and those two files will be assigned to Microsoft SQL Server.
(You can also change the values of these variables during program execution by including in your code:
SET ENVIRONMENT "filename-HOST" TO filesystem
or
SET ENVIRONMENT "DEFAULT-HOST" TO filesystem
This enables you to change file systems during the execution of your program. This is not the typical way to specify a file system; normally it is designated in the runtime configuration file and is not changed in the COBOL program.)
NOTE
The ACUCOBOL-GT interface to Microsoft SQL Server allows you to create a Microsoft SQL Server table with an OPEN OUTPUT statement, just as you can create Vision indexed files. The Microsoft SQL Server equivalent of a Vision file is a table, not a database. You need to create a database for your Microsoft SQL Server tables before you run the COBOL program that creates the tables, just as you need to create a directory for your files before you run a COBOL program that creates Vision files.
IMPORTANT
You are now ready to use the sql.acu program.
After you learn about and use this utility, you will next find out about preparing and compiling your COBOL program, followed by learning to use the demonstration program.