Once the COBOL application has finished, you should review the resulting database table to ensure that it has the desired format and column names. For this exercise, we are using Microsoft SQL Server.
- To review the structure of the table, bring up Microsoft’s SQL Server Management Studio.
- Connect to the data source you 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
|
- Once you are connected, perform the following steps:
- Expand the
Databases folder.
- Expand the folder referred to in the
A-MSSQL-DATABASE setting from your configuration file.
- Expand the
Tables folder.
- Locate and expand the folder containing the name
purch1.
This folder contains a list of subfolders that describe the table columns and indexes. Note that the folder titled
Keys, which should not be confused with the
Indexes folder, which is where the equivalent of the COBOL keys are created.
Index 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 by placing the NAME directive in your COBOL FD. You can modify the table structure with the USE GROUP, WHEN, and other directives placed within your COBOL FD.
