SQL OPTION on CRTSQLRPG and CRTSQLRPGI

[rob@xxxxxxxxx]

We've been at V5R1 for some time now.  We recompiled a SQLRPG program with
the options:
Precompiler options  . . . . . . OPTION       > *XREF
SQL path . . . . . . . . . . . . SQLPATH        *NAMING

and it no longer works.
If, however, we change it to:
Precompiler options  . . . . . . OPTION       > *XREF
                          + for more values   > *SYS
SQL path . . . . . . . . . . . . SQLPATH        *NAMING

Then it works.

Correct me if I am wrong but if I do not select *SQL for OPTION isn't *SYS
assumed?  Or is that something which changed with V5R1?  Pressing F1 for
help on OPTION lists many options, among them *SYS and *SQL, but *SYS is
underlined indicating that this is a default.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.