Previous Topic Next topic Print topic


Customizing SQL Identifiers

Restriction: This topic applies to Windows environments only.

HCOSS maps many DB2 identifiers to their SQL equivalents to resolve differences and enable smooth migration. For example, by default, HCOSS maps z/OS DB2 identifiers TRAN and APPLICATION to "TRAN" and "APPLICATION" respectively in SQL Server. This mapping is defined as such because while TRAN and APPLICATION are perfectly valid z/OS DB2 identifiers, they are reserved words in SQL Server. Therefore, to prevent these DB2 identifiers from failing to execute in SQL Server, they are mapped to SQL Server surrounded by double quotes.

In addition to using the default mappings, you can also define customized SQL identifier mappings in HCOSS using the SQL Name Mappings Tool. For more information, see Default Function Mappings, Default Special Register Mappings, and To customize SQL name mappings.

Previous Topic Next topic Print topic