VisualAge Generator to Enterprise Generation Language Migration Guide

SQL I/O and !itemColumnName

VisualAge Generator: For SQL I/O, VisualAge Generator permits the use of !itemColumnName in some clauses of the SQL statements. Test and generation determine the SQL column name that corresponds to the item name in the SQL row record.

EGL: The use of !itemColumnName is not supported.

Associated part needed for migration: The SQL record and the record specified as the alternate specification record, if any.

Figure 38. Ambiguous situations for functions--SQL I/O and !itemColumnName

Migrating with the associated part
Migrating without the associated part
Based on the first migration of this function, if the SQL record and its alternate specification record are available, the migration tool converts any !itemColumnNames to the corresponding SQL column name based on the SQL record or, if applicable, its alternate specification record. If the SQL record and its alternate specification record are not available, the migration tool does the following:
  • Uses !itemColumnNames for any column name variables.
  • Issues an error message that the function needs to be reviewed.

Potential Problem: A problem only arises if there are two records with the same name (generally in different subsystems) that have different SQL column names corresponding to an !itemColumnName.

Possible Solution: Make a copy of the function for use in the second subsystem and modify the new function to use the correct SQL column names. Disadvantage: This has the potential to ripple back into functions that use this I/O function.

Potential Problem 1: A problem arises for any modified SQL statement or any SQL statement that uses Execution Time Statement Build.

Solution: Review the list of error messages for any messages related to !itemColumnNames. Modify the SQL I/O function to include the correct column names based on the SQL row record.

Potential Problem 2: The same potential problem and solution as shown for Migrating with the associated part apply.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]