Checking the Resulting Microsoft SQL Server Table

Once the COBOL application has finished, you should review the resulting database table to ensure that it has the desired format and column names.

1. To review the structure of the table, open Microsoft’s SQL Server Management Studio.
2. Connect to the data source used in your configuration file. The entries map as follows:

   Server Management Studio	Database Connectors
   Server name	A-MSSQL-DEFAULT-CONNECTION
   Login	A-MSSQL-LOGIN
   Password	A-MSSQL-PASSWD

3. Once you are connected, perform the following steps:
   1. Expand the Databases folder.
   2. Expand the folder referred to in the A-MSSQL-DATABASE setting from your configuration file.
   3. Expand the Tables folder.
   4. Locate and expand the folder containing the name DBACCTFIL.

This folder contains a list of subfolders that describe the columns that comprise the table, as well as the indexes on the table. (Note that there is also a folder titled Keys. Don't confuse this with the Indexes, which is where the equivalent of the COBOL keys are created.)

Indexes names take the form I<tablename><key>.

Review the objects in the Columns folder for readability and to ensure that the COBOL fields you wanted to be included were indeed created. You can affect field names with the use of the NAME directive placed in your COBOL FD. You can modify the table structure with the USE GROUP, WHEN, and other directives placed within your COBOL FD. Please refer to your Micro Focus Database Connectors Reference Help for further details on these directives.