PH57488: COMPILATION ERROR SQLCA RECEIVED DURING PROJECT BUILD

APAR status

• Closed as program error.

Error description

• During the project build, there are many syntax errors related
  to missing variables from includes using compiler directives in
  the build log, for example:
  
  - Syntax error: 'ORDER' inside EXEC  SQL  DECLARE  C-IBS902-DB
  CURSOR WITH HOLD...,
  - Syntax error: 'IBS5510DB2'
  - Syntax error: 'A'
  

Local fix

• n.a
  

Problem summary

• - Many syntax errors like E.g.: Syntax error: 'ORDER' inside
  EXEC  SQL  DECLARE  C-IBS902-DB CURSOR WITH HOLD..., at line
  1776 from MBS01704
  - Syntax error: 'IBS5510DB2' at line 2396  from MBS11146
  - Syntax error: 'A' at line 2396  from MBS11146
  

Problem conclusion

• Each issue stated above was fixed by modifying the code to
  accept:
  a) inline comments in SQL
  b) deeper imbrication levels in SQL grammar
  c) correction of SQL grammar rule for With-As clause/statement
  d) accepting COPY preprocessor command inside EXEC SQL... END
  EXEC blocks
  

Temporary fix

• Test fix on top of AD v6.1.2 ifix2 is available upon request.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  APPL DISCOVERY

• Fixed component ID

  5737B1600

Applicable component levels