hi all::
1. double, 3ble check on liblist : only one file called "FC.CTSD" on qs36f : it has 4 keys
2. & NO file called "BC.CTSD"
3. cpyf FC.CTSD TO BC.CTSD
4. check total records : both file are same
what i going to do is find (count) the duplicate records in "FC.CTSD"
i think above stmt is correct
it shows incorrect figure actually i end the process bcos it selected records more than i hope
but when i use same qry to 'BC.CTSD' ?? (use F9 to retrive statment & change F to B) it shows correct result???
check again and again with 2 senior PGMRs
wondering!!!
what's the wrong ????
thanks
dhanuxp
1. double, 3ble check on liblist : only one file called "FC.CTSD" on qs36f : it has 4 keys
2. & NO file called "BC.CTSD"
3. cpyf FC.CTSD TO BC.CTSD
4. check total records : both file are same
what i going to do is find (count) the duplicate records in "FC.CTSD"
Code:
SELECT COUNT(*) FROM QS36F/"FC.CTSD" A WHERE rrn(A) > (select min(rrn(B)) from QS36F/"FC.CTSD" b WHERE A.CTSCNO = B.CTSCNO AND A.CTSCAT =B.CTSCAT AND A.CTSSHE = B.CTSSHE AND A.CTSSSQ =B.CTSSSQ)
it shows incorrect figure actually i end the process bcos it selected records more than i hope
but when i use same qry to 'BC.CTSD' ?? (use F9 to retrive statment & change F to B) it shows correct result???
check again and again with 2 senior PGMRs
wondering!!!
what's the wrong ????
thanks
dhanuxp
Comment