Compiling SQL statements containing group variable expansions can result in a compiler error. For example, consider the following PL/I code:
EXEC SQL
SELECT * INTO :
FROM MYTABLE
WHERE ( MYFIELD = :MYSTRUCT.FIELD1 )
;
Attempting to compile the above code can result in the following erroneous exception:
Severe MPLIE09995S : ES0130 Host variable MYSTRUCT.FIELD1 is part of a group variable expansion that is not supported
in this type of SQL statement.
Full article: https://portal.microfocus.com/s/article/KM000006672
#SupportTips/KnowledgeDocs
#EnterpriseDeveloper



