Tweet
I am trying to get a record count from a SQL join in a COBOL program. SELECT COUNT(*) INTO :ROW-COUNT FROM FILEA AS A JOIN FILEB AS B ON (A.KEY1 = B.KEY1 AND A.KEY2 = B.KEY2 AND A.KEY3 = B.KEY3 AND A.KEY4 = B.KEY4 AND A.KEY5 = B.KEY5 AND A.KEY6 = B.KEY6 AND A.KEY7 = B.KEY7) It compiles no problem but when the statement runs I get a SQLCODE of -204 Which is telling my that my file is not found although it most certainly is there. Any ideas would be greatly appreciated
Comment