"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message news:<Ic********************@rogers.com>...
Bob Sparks wrote: I upgraded to stinger and got stung. Not all my code compiles. Most of
the problems are stinger seems to be more stringent on casting
varchars to vargraphics. This I am working out, however, one procedure
fails to compile and gives the following message.
[IBM][CLI Driver][DB2/NT] SQL0901N The SQL statement failed because
of a non-severe system error. Subsequent SQL statements can be
processed. (Reason "Can not enforced Maxcard > 1".) LINE NUMBER=67.
SQLSTATE=58004
Searches on google searches on maxcard db2 don't reveal much.
Any thoughts?
Bob
Can you post here (or e-mail me: jasinek at attglobal dot net) smallest possible
example which demonstrates tyhis problem - including DDL to create objects needed?
Jan M. Nelken
Jan
My manager doesn't want me posting any real code. I have supplied some
similar code.
By divide and conquer I determined that it was not happy with the
"FETCH FIRST 1 ROWS ONLY"
here is the where clause it wasn't happy with
where x_value=coalesce(y_value,(select * from table
(fn_value_list('P')) as T FETCH FIRST 1 ROWS ONLY)) and value_cd =
v_input
had to be replaced by
where x_value=coalesce(y_value,(select min(value) from table
(fn_value_list('P')) as T FETCH FIRST 1 ROWS ONLY)) and value_cd =
v_input
notice I had to both explicilty name the single column and get a
single row by using min()
I have the same error message reported elsewhere but I have dug into
it yet.
I would say maxcard may mean "maximum cardinality" which means it
can't figure out how to get a single row.
Bob