RE: Embedded SQL problem

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

Hi Jon,

Ignore my previous message. You CAN use a group name (ie your VENDR).

Here is an excerpt from "DB2 UDB for AS/400 SQL Programming with Host
Languages".
I found it in the InfoCenter at
http://publib.boulder.ibm.com/html/as400/v4r5/ic2924/index.htm

"A host structure is a named set of host variables that is defined in your
program's DATA DIVISION. Host structures have a maximum of two levels, even
though the host structure might itself occur within a multilevel structure.
An exception is the declaration of a varying-length character string, which
requires another level that must be level 49."

Note the "maximum of two levels". VENDR (at level 05) is the first one.
VENDORID, VENDORNAME, ADDRESSLINE1 (at level 10) would be the second one. Do
you have any group fields in your VENDR definition? That would cause the
error you described.

Hope this helps! I should have dug into the manual before I sent the first
message. At least I learned something!

Richard Casey