Re: sql error

[Bryan Dietz <BDietz@xxxxxxxxxx>]

The error I got:

                         Additional Message Information
 Message ID . . . . . . :   CPI4314       Severity . . . . . . . :   10
 Message type . . . . . :   Information
 Date sent  . . . . . . :   01/18/05      Time sent  . . . . . . :
13:04:35
 Message . . . . :   Comparison of selection operands may never be equal.
 Cause . . . . . :   The digits, decimal positions, or length of the field
   operand have been increased so that it may be properly compared with one
or
   more literal operands.  Therefore, the field operand may never equal the
   literal operand.  The operands are DBNAME, AB36F, and *N, and are used
by
   operator X'0001' in selection item 6 for selection type 1. If an operand
is
   *N, the operator does not require that operand.  Selection type 1
indicates
   record selection and selection type 2 indicates group by selection.

I would say the sql statement has issues.

But I would also say that it should not dump.

just more ammo for talking to IBM

----------------------------
Bryan Dietz

Aktion Associates

rpg400-l-bounces@xxxxxxxxxxxx wrote on 01/18/2005 12:02:30 PM:


>
> But I think I got it with:
> SELECT substr(TABLE_NAME,1,10), substr(TABLE_SCHEMA,1,10), "CCSID"
> FROM syscolumns WHERE "CCSID" <> '37' and TABLE_SCHEMA = 'AB36F'
> SQL system error.
>
> So, yes, I can duplicate it here.
>