Re: SQL and qualified DS

["Bruce Guetzkow" <bruceg@xxxxxxxxxxxxxxxxxxxxxxx>]

Frank:

SQLRPGLE most definitely does NOT work with qualified data structures at
V5R2 (IBM has indicated that they will be supported in a future-as yet
undefined-release).  If you are using fields in a data structure in an
embedded SQL statement, the data structure must NOT be qualified and
must be explicitly defined in the source member (cannot be in a /COPY
statement), though it can reference an external definition (EXTNAME
keyword).

One other issue I came upon:  The data structure that you use in your
SQL statement may NOT have any fields with the same name as fields in
another (qualified) data structure.  If you do, the pre-compiler may end
normally and your program/module may even compile with no errors, but
you may get "unexpected" results.  Here is an example of what I mean:

d datastruct1     ds                  inz
d  field1
d  field2

d datastruct2     ds                  qualified inz
d  field1
d  field2

The RPGLE compiler will understand this, but the SQL pre-compiler will
not.  There is a PTF to correct this:  SI11744 (product 5722ST1).

Hope this helps,
Bruce Guetzkow
Information Services Director
United Credit Service, Inc.
Phone: 262-723-2902
Fax: 262-723-5568
Email: bruceg@xxxxxxxxxxxxxxxxxxxxxxx
Web: www.unitedcreditservice.com