Can't access data when selecting records using embedded SQL in COBOL code
I am adding the following SQL to my COBOL program. It returns ZEROES as the SQLCODE, but does not put the fields in my COBOL fields so that I can use them in my program.
SELECT TOP 1
WHERE "CrtCaseDefNo" = :WS-CRTCASE AND
"DeleteInd" = 'N'
Studio Enterprise Edition 6.0 Platform Net Express Database is MS SQLServer
We have 37 new tables for this project. Can access tables by primary keys (SIDS), but all access using Alternate keys has been problematic. This is the code from the first table which I have tried using both the middle tier software to access and embedded SQL. Both return a SQLCODE value of zero, but no values in the fields declared in the INTO variables. The second table I tried to access using embedded SQL with a cursor. It works until it gets to the FETCH statement and then it bombs with a nonsensical error.