April 14, 2014, 12:53 PM
AAranha[CLOSED] Creating a job to delete rows
I keep receiving an error
(FOC14010) SYSDATE IS NOT A VALID COLUMN NAME
When i try to run this job..
ENGINE SQLORA SET DEFAULT_CONNECTION WORLD
SQL
DELETE
FROM AATEST
WHERE ROLE_ID LIKE 'ZE%'
AND ROLE_DESC = 'AAA'
AND ROLE_DATE > sysdate-1
END
Any ideas on how to resolve the error?
This message has been edited. Last edited by: <Kathryn Henning>, April 14, 2014, 01:22 PM
Francis MarianiUnless you issued this command before your SQL DELETE command
SET SQLENGINE = SQLORA
try
SQL SQLORA...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server