Is there a syntax error here ?
All the fields exist.
When I run my program, I think it fails here, because I get no output. When I comment it out, I get output.
C/EXEC SQL
C+ SELECT MIN(ARCCCU) INTO :SAVCUST#
C+ FROM QTEMP/RAR
C+ WHERE :W8RCST = RCUST and :W8WDOC = ARDOCN
C+ AND :W8AMT = RAMT
C/END-EXEC
Edit, I just reran with some error trapping and got
SQLCOD = 305
SQLSTT = 22002
gotta run and log off, will try to figure out codes later.
All the fields exist.
When I run my program, I think it fails here, because I get no output. When I comment it out, I get output.
C/EXEC SQL
C+ SELECT MIN(ARCCCU) INTO :SAVCUST#
C+ FROM QTEMP/RAR
C+ WHERE :W8RCST = RCUST and :W8WDOC = ARDOCN
C+ AND :W8AMT = RAMT
C/END-EXEC
Edit, I just reran with some error trapping and got
SQLCOD = 305
SQLSTT = 22002
gotta run and log off, will try to figure out codes later.
Comment