Skip to main content

Support Tip: PL/I compiler incorrectly reports ES0130 errors for certain SQL statements.

  • May 18, 2022
  • 0 replies
  • 0 views

Heather Caldwell

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