On 30.07.2013 23:29, Kevin E wrote:
> When running a COBOL code through gpre:
>
>
> EXEC SQL
> SET DATABASE DB2 = "/Db/Iccb/a1.db";
> USER '**' PASSWORD ''
> END-EXEC.
> EXEC SQL
> DECLARE C CURSOR FOR
>
i thing that u have some names with spaces at the beginning
use this select to find
select substring(upper(fname), count(*) from customer group by 1
Att,
Alexis Diel
On Sat, Aug 3, 2013 at 5:01 AM, Masotti Umberto wrote:
> **
>
>
> Field fname is NOT NULL?
> count(*) value differs from count
Field fname is NOT NULL?
count(*) value differs from count(fname) AFAIR.
Inviato da iPad
Il giorno 01/ago/2013, alle ore 16:20, "ASOrg" ha scritto:
>
> Dear All
>
> select count(*) from customer ( returns 235384 )
>
> select count(*) from customer where substring(upper(fname) from 1 for 1 )