Multiple-record array definitions getting message IWAQ0003W

Technote (FAQ)


Question

Why am I getting many of following messages?

IWAQ0001W Warning messages were encountered

IWAQ0003W SQL warnings were found

SQLState=S1000 Multiple-record array definitions at the same level have
been detected. The number of record arrays is 2 The Cartesian product
(rows per access) is 64.

SQLState=S1000 Multiple-record array definitions at the same level have
been detected. The number of record arrays is 3 The Cartesian product (rows per access) is 192.

Answer

It is because the copy book has quite a few arrays and you choose to map them all as arrays instead of flattening the arrays or mapping them as multiple tables.

We advise mapping only one array as an array per table because mapping multiple arrays results in a cartesian product (aka LOTS of rows output for one row in the actual table). For example, if you had 3 arrays and one had up to 5 occurrences another, 8 and another 10, you would get 5*8*10= 400 rows back for each row in the actual table. This is why the warning messages are issued.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Classic Federation Server for z/OS
General issues

Software version:

9.1, 9.5

Operating system(s):

z/OS

Software edition:

All Editions

Reference #:

1432586

Modified date:

2012-11-08

Translate my page

Machine Translation

Content navigation