I am trying to run the simplest of SQL Queries.
INSERT INTO DRTEST (DRSCNT, DRDATE, DRTIME, DRDATETIME,
DRDESC) VALUES(3, CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP,
'Test 1')
It works fine from a STRSQL screen, or in a Navigator Window.
I copy paste the exact code into RPG
But if I run it from a RPG SQL Program nothing happens, but no error either.
C/EXEC SQL
C+ INSERT INTO DRTEST (DRSCNT, DRDATE, DRTIME, DRDATETIME,
C+ DRDESC) VALUES(3, CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP,
C+ 'Test 1')
C/END-EXEC
Am I missing something silly ??
INSERT INTO DRTEST (DRSCNT, DRDATE, DRTIME, DRDATETIME,
DRDESC) VALUES(3, CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP,
'Test 1')
It works fine from a STRSQL screen, or in a Navigator Window.
I copy paste the exact code into RPG
But if I run it from a RPG SQL Program nothing happens, but no error either.
C/EXEC SQL
C+ INSERT INTO DRTEST (DRSCNT, DRDATE, DRTIME, DRDATETIME,
C+ DRDESC) VALUES(3, CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP,
C+ 'Test 1')
C/END-EXEC
Am I missing something silly ??
Comment