I have a table (db2), records have a Status column. This is my problem:
there are double records with status LMC and ACT (among other... not important) and some just with LMC.
I need those "LMC only" records. How could I do this THE FASTEST WAY. I thought about Access like Join query "All from tbl1 and only those from tbl2..."
But this should really be done fast (records exceed millions) so Im sceptic about DataSets, the best way would be the SQL Select itself, but I dont have any clue how to do that
this is the select that gets all of them (with LMC and ACT, remember I just need the ones that have only LMC and not ACT) -->
SELECT CSCDNR, CSCHDNAME, b00ca1, b00ca2 FROM LBZVD02.CDCS00, LBEOD03.BMF00P, LBEOD03.BMF40P, LBEOD03.CAFIXP WHERE CSACCOPU = B40OPU AND CSIBSACC = B40ACC AND B40CLT = B00CLT AND CSCDTYPE = ATMC AND CSCDSTAT = *LMC AND B40STS NOT IN (C) AND csibsacc = FIXTAC AND CSPRTDATE = " & sqlDate
there are double records with status LMC and ACT (among other... not important) and some just with LMC.
I need those "LMC only" records. How could I do this THE FASTEST WAY. I thought about Access like Join query "All from tbl1 and only those from tbl2..."
But this should really be done fast (records exceed millions) so Im sceptic about DataSets, the best way would be the SQL Select itself, but I dont have any clue how to do that
this is the select that gets all of them (with LMC and ACT, remember I just need the ones that have only LMC and not ACT) -->
SELECT CSCDNR, CSCHDNAME, b00ca1, b00ca2 FROM LBZVD02.CDCS00, LBEOD03.BMF00P, LBEOD03.BMF40P, LBEOD03.CAFIXP WHERE CSACCOPU = B40OPU AND CSIBSACC = B40ACC AND B40CLT = B00CLT AND CSCDTYPE = ATMC AND CSCDSTAT = *LMC AND B40STS NOT IN (C) AND csibsacc = FIXTAC AND CSPRTDATE = " & sqlDate