Skip to main content
B
blemay1-Visitor
1-Visitor
September 11, 2014
Solved

'14' to compile SQLINDX does not substitute correct #SRCLIB/#SRCFIL

  • September 11, 2014
  • 1 reply
  • 1582 views

We are starting to use Index Adviser to create new indexes by cutting and pasting the SQL statements into a source member for compile and promotion through Implementer. However, when I go to compile in our Development environment with '14', the command RUNSQLSTM uses QTEMP/QSQLSRC for the Object Code substitution variables #SRCLIB/#SRCFIL.

The SQLINDX object code has a default source file of QSQLSRC, but I have overridden the Development environment to FCOSRCLE. The source library for our Development environment is MM4D3SRC; the environment override is set to *SRCLIB.

So I expected Implementer to substitute the environment override value of FCOSRCLE for the source file and environment source library value of MM4D3SRC for the source library, but instead it used QTEMP/QSQLSRC.

Best answer by DawnBlohm

There is a known issue with SQL compiles when the source file is overridden for an environment. This is logged as Request for Change #171583. I will log a support case so that you will be notified when it is corrected. As a workaround, you can compile outside of Implementer.

We apologize for the inconvenience.

1 reply

D
DawnBlohm12-AmethystAnswer
12-Amethyst
September 12, 2014

There is a known issue with SQL compiles when the source file is overridden for an environment. This is logged as Request for Change #171583. I will log a support case so that you will be notified when it is corrected. As a workaround, you can compile outside of Implementer.

We apologize for the inconvenience.

Terms & ConditionsCookie settingsAccessibility statement