Assessment Properties group
- Available Assessments
- List of previously created assessment tasks.
- SQL Server Connection
- The name of an existing SQL Server connection.
- Qualifier (default schema)
- The name of a schema to use as the default qualifier for this assessment. Optional.
- Ignore Schema Errors
- When checked, errors related to schema specification and HCOSS table and function names are ignored and not reported in the results. Default is checked.
Note: Do not uncheck this checkbox if you have not installed HCOSS on the server machine that contains your SQL Server database.
- Source Code Path
- The directory containing your COBOL source files or the parent directory to one or more subdirectories containing your COBOL source files. Use the browse button to select a directory.
- New
- Create a new assessment task.
- Save
- Save the assessment task specified in the
Available Tasks field.
- Delete
- Delete the assessment task specified in the
Available Tasks field.
File Counts group
- Total
- Total number of files available for assessment.
- NoSQL
- Total number of files that contain no SQL code.
- Processed
- Total number of files that have completed processing.
- Pending
- Number of files awaiting processing.
- Excluded
- Number of files not processed in the completed assessment.
- Dynamic SQL
- Number of dynamic SQL statements encountered.
Statement Counts group
- Total SQL Statements
- The total number of DB2 SQL statements encountered in the processed files.
- OK
- For each of the
As is,
Code convert,
HCOSS no BIND, and
HCOSS with BIND conversion scenarios, reports the number of DB2 SQL statements that can be executed successfully in SQL Server.
- Must fix
- For each of the
As is,
Code convert,
HCOSS no BIND and
HCOSS with BIND conversion scenarios, reports the number of DB2 SQL statements that require a manual fix before they can execute successfully in SQL Server.
- In doubt
- For each of the
As is,
Code convert,
HCOSS no BIND and
HCOSS with BIND conversion scenarios, reports the number of DB2 SQL statements for which HCOSS cannot determine the potential for successful execution in SQL Server.
- As is
- Reports the number of DB2 SQL statements that fall into each of the
OK,
Must fix, and
In doubt categories if you were to use the code in its original state.
- Code convert
- Reports the number of DB2 SQL statements that fall into each of the
OK,
Must fix, and
In doubt categories if you were to
you manually converted your SQL DB2 statements to T-SQL statements before compilation before migrating to SQL Server.
- HCOSS no BIND
- Reports the number of DB2 SQL statements that fall into each of the
OK,
Must fix, and
In doubt categories if you were to use the code in its original state and compile your SQL Server application using the SQL(DIALECT) directive option without the SQL(DBRMLIB) directive option.
- HCOSS with BIND
- Reports the number of DB2 SQL statements that fall into each of the
OK,
Must fix, and
In doubt categories if you were to use the code in its original state and compile your SQL Server application using both the SQL(DIALECT) and SQL(DBRMLIB) directive options. For more information, see the
Manage Packages and Plans Tool and
DSN BIND utility topics.
- Unsupported
- The number of processed SQL statements that are not ANSI SQL syntax compliant.
Error Counts group
- Without HCOSS
- The number of mainframe DB2 SQL statements that could not be executed by the OpenESQL runtime emulator.
- With HCOSS
- Of the mainframe DB2 SQL statements that could not be executed by the OpenESQL runtime emulator, the number of those statements that continue to be unexecutable even after applying an HCOSS conversion.
Summary grid
A file-by-file summary of the assessment, including a breakdown of the
In doubt and
Must fix counts represented in the
Statement Counts group.
Assessment Actions group
- Process Files
- Run the assessment process.
- Pause
- Pause assessment processing.
- Reset Status
- After processing completes, clear all fields in preparation for rerunning the current assessment or for running a new assessment.
- Export Report (txt)
- Save the assessment specifications and results as a text file.
- Export Details (csv)
- Export the information in the
Summary grid on the
Results tab to a CSV file compatible with spreadsheet software.
