RE: Embedded SQL with data structure subfields

Eric DeLong wrote on 04/10/2006 04:13:49 PM:

What release are you on?  I'm not sure, but I thought the use of 
qualified DS subfields in SQL was still a problem.  This might have 
been fixed at V5R4, but I'm not to that release yet....

I'm at V5R3.  The Redbook "Embedded SQL Programming" for V5R3 specifically 
states: "When writing an SQL statement, referrals to subfields can be 
qualified. Use the name of the data structure, followed by a period and 
the name of the subfield. For example, PEMPL.MIDINT is the same as 
specifying only MIDINT."

In the book, the example DS is not declared as qualified.  Does this 
matter?  Is this a bug of some sort, or am I just trying to do the 
impossible?  It doesn't make any sense to me that the qualified naming 
would be allowed, but only if the DS is not itself qualified.

#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################