Embedded SQL Problem

 >> Ignore my previous message. You CAN use a group name (i.e. your VENDR).

I know that is the theory - but even when the qualification is not required
(i.e. there is no duplicate name) the pre-compiler barfs on a declaration
that includes it.

For example - I have now a real simple subset of the program.  With this
declaration:

       01 VENDR1.
          03  VR1.
            05  VNID   PIC X(6).
            05  VNNAME PIC X(30).

This is valid
            Insert into VendSmall
            Values(:VR1)

But this is not:
           Insert into VendSmall
           Values(:VENDR1.VR1)

If I could use the first version it would be OK, but I can't because I have
the same field names etc. in multiple generated (COPY DDS) structures.

Several people have suggested using BEGIN DECLARE SECTION to cure this.
Unless I am missing something it makes zero difference.  The manual doesn't
help since it clearly states that this statement must be present - when
clearly that is not true.  As far as I can see it has zero effect.

Jon Paris
Partner400