Sql question

I'm using ARDGATE to connect to an MSSQL Server. I was shocked I got it
working so quickly. I'm able to run my SQL statements using STRSQL.



Now I'm trying to convert them to SQLRPGLE, and I'm receiving an error
Cursor not prepared.



If you can't tell, I'm still learning SQLRPG. Here is what I'm doing. I
have SqlRec is a DS with the 4 fields I'm looking to retrieve.



Exec SQL CONNECT TO :RDBAX USER :USERX USING :PASSX;

pBol = '351787';

EXEC SQL

Declare C1 Cursor for

select OCR_PATH, MANIFEST_NO, BOL, DOCUMENT_ID

from shipping where bol = :pBol

and DOCUMENT_ID <> -1;

EXEC SQL Open C1;

EXEC SQL Fetch Next from C1 into :SqlRec;

dow sqlstt = '00000';

// do stuff here

EXEC SQL Fetch Next from C1 into :SqlRec;

Enddo;





Thanks, Jack