Using the Relational Data Framework › What Are the Differences From Standard SQL?

What Are the Differences From Standard SQL?

The CA OPS/MVS version of SQL supports the tasks required to create, modify, access, and delete tables. It also has several features not offered by standard SQL:

• The CA OPS/MVS SQL converts numeric values to printable text strings, allowing you to compare numeric fields and character fields. After removing leading and trailing blanks from the character string and the converted numeric string, CA OPS/MVS compares the two strings.
• The CA OPS/MVS SQL always returns values passed to or fetched from SQL in a printable format. For example, CA OPS/MVS passes or retrieves values stored in binary format as a string of numeric digits and retrieves hexadecimal values in a printable X'n' format.