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
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
SQL embedded in COBOL program
Collapse
X
Comment