Query returns SQL1585N

#1

Hi all.

DB2 LUW 9.5 fixpack 5.

My application has a query that returns SQL1585N.
I created a temporary tablespace with 32k pages, but the same error is
returned.

Important details:

1) This query has 44 fields. When I remove three fields from the
original query regardless of which fields I remove, the query works.
2) There is a subquery, in this query, with XML agreggate with 12
fields.

Any ideas?

OBS: If necessary, I can put the query here, in the forum.

Thanks in advanced.

#2

On 8/4/2010 2:40 AM, brunoalsantos wrote:

Quote:

Hi all.

DB2 LUW 9.5 fixpack 5.

My application has a query that returns SQL1585N.
I created a temporary tablespace with 32k pages, but the same error is
returned.

Important details:

1) This query has 44 fields. When I remove three fields from the
original query regardless of which fields I remove, the query works.
2) There is a subquery, in this query, with XML agreggate with 12
fields.

Any ideas?

OBS: If necessary, I can put the query here, in the forum.
Provide the query AND all the column definitions.

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

#3

On 3 ago, 20:39, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:

Quote:

On 8/4/2010 2:40 AM, brunoalsantos wrote:

Hi all.

DB2 LUW 9.5 fixpack 5.

My application has a query that returns SQL1585N.
I created a temporary tablespace with 32k pages, but the same error is
returned.

Important details:

1) This query has 44 fields. When I remove three fields from the
original query regardless of which fields I remove, the query works.
2) There is a subquery, in this query, with XML agreggate with 12
fields.

Any ideas?

OBS: If necessary, I can put the query here, in the forum.

Provide the query AND all the column definitions.

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab- Ocultar texto das mensagens anteriores -

- Mostrar texto das mensagens anteriores -

Serge.

The query is too long to post here.
I'll send you via email.

Thanks.

Bruno

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query returns SQL1585N

comp.databases.ibm-db2 comp.databases.ibm-db2

Query returns SQL1585N - 08-03-2010 , 01:40 PM

Re: Query returns SQL1585N - 08-03-2010 , 06:39 PM

Re: Query returns SQL1585N - 08-04-2010 , 12:33 PM